Calculating Form Fields - Create a Calculating Invoice in Word

Поделиться
HTML-код
  • Опубликовано: 23 ноя 2024

Комментарии • 100

  • @ForeverSongMinistries
    @ForeverSongMinistries 2 года назад +1

    Sharon, I came across your page looking how to make dependent fillable forms. I didn't know what they were called and googled and was frustrated, because I kept being led to websites to create forms. So thank you for giving words and language to the ideas that I have in my mind. You have been a tremendous help to my company. With the roll out of Good faith estimates, with your help I was able to create a form with dependent drop boxes that would auto populate the information needed to fill the form, created autocalculations for amounts thus making the form very easy to use and keeps us from using calculators and multiple windows to complete the form. I cannot thank you enough.

    • @SharonSmith
      @SharonSmith  2 года назад

      Oh, thank you so much for your very kind words and for taking time to leave such a nice comment!
      I am so glad you found my videos and that they helped you and your organization. I do try to write descriptions so people can find my videos. It is hard to know what to search for sometimes, and I know how that feels, so I try to make it so people who are looking for how to do something can hopefully find my videos, and that they help them with what they are trying to do. I'm proud of you for creating a great resource for your company and I wish you the best of luck. Thanks for watching my videos!

  • @surjies100
    @surjies100 Год назад +2

    Thank Sharon, this tutorial is exactly what Im longing for. Very clear tutorial too.

    • @SharonSmith
      @SharonSmith  Год назад

      Glad you found it helpful! Thanks for watching!

  • @alielsheikh8091
    @alielsheikh8091 3 года назад +3

    I was just looking for this and i knew it would be available at your channel; thanks Sharon.

  • @christianbowen2531
    @christianbowen2531 4 года назад +4

    Hi Sharon - You did an outstanding job on this video! Your planning and execution were flawless. Your instructions were easy to follow and straight-forward. Your stage and delivery were awesome. The only potential enhancement I could see was to move the sub-total field above the tax field to slightly improve usability of the form. Thank you for helping me!

    • @SharonSmith
      @SharonSmith  4 года назад

      Hi Christian! Thank you so much, I really appreciate your feedback and kind words. Great tip on the layout of the invoice fields as that would improve it! Thanks for watching my videos and taking time to leave a comment. Take care!

  • @user-dn9vd9xg9p
    @user-dn9vd9xg9p 2 месяца назад +4

    Rarely are invoices one line item. If there are multiple lines this example does not work. Do we need to name each line item bookmark differently for each of the lines?

  • @krishanjohnson2222
    @krishanjohnson2222 3 года назад +3

    Thank you so much. I have watched this whole playlist and learned a lot. The way you explain it step by step is just amazing and so easy to understand.

    • @SharonSmith
      @SharonSmith  3 года назад

      Oh, thank you very much Johnson! I appreciate your kind words and very glad to hear you have learned a lot from my videos. Thank you so much for watching! Take care!

  • @jake12466
    @jake12466 11 дней назад +1

    THANK YOU SO MUCH FOR THIS!!

    • @SharonSmith
      @SharonSmith  10 дней назад

      Glad to help! Thanks for watching!

  • @AslamCheval
    @AslamCheval 3 года назад +3

    Thank you, Sharon, for the amazing step by step video. could you create a video showing how to create an invoice similar to this but having multiple items. Thank you

    • @SharonSmith
      @SharonSmith  3 года назад

      Hello Aslam! Thanks for watching! I'll be sure to add your suggestion to my list of future video topics. Take care!

    • @idakottmeier2822
      @idakottmeier2822 5 месяцев назад

      @@SharonSmith Please do this. I am having the same issue. I want to add multiple items prices and then tax.

  • @dr.timothyr.morris5389
    @dr.timothyr.morris5389 2 месяца назад +1

    Awesome. Thank you Sharon. I'm a savvy excel user but never figured out how to set up calculations in word form fields.
    ALSO: Your video with camera on you + screen sharing is very engaging. What software did you use to record it? I am a physician and medical educator, and I'd like to learn how to record like you (a total pro!).

    • @SharonSmith
      @SharonSmith  Месяц назад

      Thanks so much, Dr. Morris! I'm so glad you like my videos and find them helpful. I record my desktop using Camtasia while also filming with audio on a green screen. I take my video, audio, and desktop capture and edit them together in Final Cut Pro using the Keyer effect. Camtasia also has a built-in effect you can use to Remove a Color from a background so you can do it all in Camtasia as well. I get a lot of questions on it so I plan to make a video on it someday. I'll be sure and let you know when I do. Best of luck with your endeavors!

  • @katestan7002
    @katestan7002 4 года назад +1

    Sharon, you are awesome! I like this video. Thanks!!!

    • @SharonSmith
      @SharonSmith  4 года назад

      Thank you so much Kate!! Thanks for watching and taking time to leave a comment. I really appreciate it. Best of luck to you!

  • @Center-mq9yz
    @Center-mq9yz Месяц назад

    Hello, Sharon and thank you for the video. One question can use formulas going horizontal?

  • @Abu.Youssef.66
    @Abu.Youssef.66 Год назад +1

    Hi Sharon
    How to remove the shading under the numbers in the table?
    Thank you

  • @anitanooknaidu9861
    @anitanooknaidu9861 3 года назад +1

    wow.--nice...!! Really Helpful

    • @SharonSmith
      @SharonSmith  3 года назад

      Glad you found it helpful! Thanks for watching!

  • @nedabenitez2211
    @nedabenitez2211 3 года назад +1

    Thank you for the tips & tricks! Which version of Microsoft Word are you using?

    • @SharonSmith
      @SharonSmith  3 года назад

      Hi Neda! I use Office 365 so it runs the latest version of MS Word on my PC. If you have a different version, you may find things look a bit different. I'm glad you found my videos helpful! Thanks for watching!

  • @ahrihr3523
    @ahrihr3523 4 года назад +3

    Thank you thank you thank you! Again, just so there is no misunderstanding..... THANK YOU!

    • @SharonSmith
      @SharonSmith  4 года назад

      You are very welcome! Glad you found my videos helpful. Thanks so much for watching!

  • @sophanasorn6218
    @sophanasorn6218 Год назад

    Love the way you teach😍

    • @SharonSmith
      @SharonSmith  Год назад +1

      Glad you found it helpful! Thanks for watching!

  • @ModernPindawale
    @ModernPindawale 4 года назад +1

    Very helpful and easy to understand 👍😊

    • @SharonSmith
      @SharonSmith  4 года назад

      Great! Glad you found it helpful and easy to follow. Thanks for watching!

  • @ΝικΝοκ
    @ΝικΝοκ 3 месяца назад +1

    Seems usefull, ill try it

    • @SharonSmith
      @SharonSmith  3 месяца назад

      Glad to help! Thanks for watching my videos. I appreciate it!

  • @maddumabandaragechandana9786
    @maddumabandaragechandana9786 Год назад +1

    Hi, Love your vedios and you as well!

    • @SharonSmith
      @SharonSmith  Год назад

      Thanks so much for watching my videos!

  • @user-dn9vd9xg9p
    @user-dn9vd9xg9p 2 месяца назад +1

    How can we set up the tax to show a cell with percentage and show the amount of tax (in other words not already added in). That way if tax rate changes we can change the percentage and the tax cell will automatically update the $ tax amount. Thank-you.

  • @samwest314
    @samwest314 10 месяцев назад

    Thank you for this, it's quite informative. Here's my issue with the way you do tax, that's not normal on a regular invoice. What should be there is the actual tax amount in currency. No one seems to be able to do that.

  • @indranilkarchowdhury9314
    @indranilkarchowdhury9314 4 года назад +1

    Thanks for such a nice video. I would like to know why u have not checked the option "calculate on exit" In the last two form fields, the total and subtotal? Also would like to know if excel functions and formulas are applicable here or not?
    Also please come up with some tutorials of linking or capturing data from excel file to ms Word.

  • @jciii5589
    @jciii5589 Год назад

    Great videos. Need your help creating a word doc that auto calculates. How can I send the form I created to you?

  • @mussieTil
    @mussieTil 4 года назад +1

    I was wandering if you can show how to do invoice number increments.? Thanks for this awesome video.

    • @SharonSmith
      @SharonSmith  4 года назад

      So glad you found my video helpful! Great suggestion - I will work on this. Thanks so much for watching!

  • @XiphiumGladiolus
    @XiphiumGladiolus 3 года назад +2

    Thanks, Sarah! I need to calculate age from [birthday] dropdown list. is it possible? if no, any alternatives? thank you so much!

    • @SharonSmith
      @SharonSmith  3 года назад

      Hi Gladys! You may want to consider designing your form in Excel so you can create this formula. Here is a video on how to create fillable forms in Excel, it will show you how to create a drop down: ruclips.net/video/_g7863PjNns/видео.html Then, here is a video that includes how to calculate number of years (age) from a date: ruclips.net/video/_3yGg_yfCzo/видео.html Hope these videos help you out. Thanks for watching!

  • @tausifrahman8928
    @tausifrahman8928 4 года назад +1

    Thank you. Excellent explanation. Watched as per your recommendation. You recommended in your reply to one of my queries to use Legacy tools for calculations as content controls do not have such provision. I will. But, I use content controls because they are aesthetically better ( no mandatory grey background !) and moreover, we can jump from one field to the other with the tab button, which is useful when filling a form. Please correct me if I am wrong. Thanks once again

    • @SharonSmith
      @SharonSmith  4 года назад +1

      Hi Tausif! You should be able to tab through the form fields using all legacy tools as well. There is a way to turn off the grey shading on the legacy tool form fields, you can see how to do this towards the end of this video: ruclips.net/video/vagwP5Jsv7k/видео.html I hope this helps! Thanks!

    • @tausifrahman8928
      @tausifrahman8928 4 года назад

      @@SharonSmith Thank you. Another problem solved. However, as far as that Tab jumping to next field is concerned, if you press tab in legacy tool controls you can jump to next field alright. But if you start typing in any text field of legacy tools and then press Tab then it keeps on moving forward in the active field and does not go to the next field. This is not the case in content controls

  • @bobgrandi1163
    @bobgrandi1163 3 месяца назад

    Sharon, I came across your video and like what I see. I have a more unique situation where prices are based on a specific Unit of Measure. Example: Black Wire price is 145.25 per every 1000 feet. The black wire comes on reels of 500 feet. The subtotal for this would be 145.25 divided by 1000 times 500. Can you help with the formula to do this calculation.. Thank you Bob

  • @yiacarter4780
    @yiacarter4780 4 года назад +1

    Thank you!!!

  • @danielius6448
    @danielius6448 3 года назад

    Hey Sharon, you helped me so much with your Videos. I hope you can awnser a specific question, I couldn´t find anything on google. I want to do a calculating form field but with one cell being a dropdown. Is it possible to have words in the dropdown like "big tax", "little tax" for your example with with a value in the background for the calculation. I would greatly apriciate it if you can tell me if this is even possible.

  • @mr.righttv9653
    @mr.righttv9653 2 года назад

    Hi Miss Sharon! i a big fan of yours! can you please teach me how to calculate the age via date? thank you very much!

  • @ladiemay0529
    @ladiemay0529 2 года назад

    Your video is very helpful, Sharon. Thanks a lot. I just wanted to ask how we enable the currency option? Unfortunately, it is not available at my end. Maybe I need to enable something or something to do with my language used? Please advise. I'll greatly appreciate it. Thanks again.

  • @kylebialick2012
    @kylebialick2012 4 года назад +1

    Can you do this with drop down form fields as well so that you can force a select few numbers or just text fields

    • @SharonSmith
      @SharonSmith  4 года назад

      Hi Kyle! You can use a drop-down form field with answer options that you enter (such as in a number or currency format) however drop-downs don't have the calculation options in their properties. Hope this helps! Thanks so much for watching!

  • @serriayers6662
    @serriayers6662 3 года назад +1

    Thank you for all your video's - very very helpful! After I put in the first name in the bookmark section it will not take any other. A box pops up and says the bookmark is not valid?? Please help!

    • @SharonSmith
      @SharonSmith  3 года назад +1

      Hi Serri! Thanks for watching my videos. When you create bookmarks in Word, here are a few things to note:
      1) Bookmark names need to begin with a letter.
      2) They can include both numbers and letters, but not spaces. So, if you need to separate words, you can use an underscore ( _ )-for example: First_Name.
      I hope this helps! Thanks again for watching!

  • @edwardmarkberino5106
    @edwardmarkberino5106 2 года назад

    Thank you.!

  • @dominikfingerle8124
    @dominikfingerle8124 2 года назад

    Love your videos. They’re super helpful! Is there a way to hide certain parts of a document via smth like a button? I have a document that is printed twice. One version is for the customer and the other has a bit more content (like "send to: accounting" etc.) I’d like to print the client version, press a button to reveal the additional info and then print that version. Is there a way to achieve that?

  • @lavita2011
    @lavita2011 2 года назад

    Hi, I love the calculation on MS Word. Can explain step by step how To Apply A Button To Clear Specific word in MS Word to be reused over and over again without saving it, same feature function on excel spreadsheet . Thanks

  • @TheBearNakedBull
    @TheBearNakedBull 3 года назад

    @sharon smith Nice explanation. I have a question. How do you create a form whereby if someone checks a box, that it assigns this a certain value (5% for example) as a discount to services being provided. Then I would like to sum the total of those services that have checks and summed a total discount

  • @vicg4178
    @vicg4178 Год назад

    Hi Sharon - thanks for this video! I have a question. I am trying to get the field to show precision to 4 decimals to show fractions of a cent for example: $0.4658 - However, Word is rounding to two decimals leaving the last two at zero - for example: $0.4700 is there a way to prevent the round and display 4 past the decimal?

  • @jkuntz667
    @jkuntz667 3 года назад +1

    Hi, Great video. Thank you. I also liked the video. I do have a question. I am trying to create a order form where the unit price is known, the quantity is not. I give the quantity field a bookmark. I set the unit price to Number, Default number 1085 and format to currency and I set a bookmark. In the subtotal field I choose calculation, set the format to currency. The equation is =aioqty*aioup and I have tried =aioqty*1085. The result is always $1.00 or nothing. Any thoughts on where I am going wrong? Thank you.

  • @julien6123
    @julien6123 3 года назад

    I have completed this on a form.
    It is giving me one issue and that is when I try to have my total field repeat in other areas of the form.
    I have used information from another one of your videos to do this. I have the form calculating 5 fields...adding them together. The total is reflected correctly in the Total field, but the areas where it is repeating is only showing calculations for the first 4 fields. So the total is incorrect. Oddly, when I enter the backstage view and then come back to the document, the total in the repeating areas has been corrected to show the complete total of all 5 areas. Why is it only updating after moving in and out of backstage. Is there some other way to refresh the document to show the correct total? This is for my boss and it is weird to have to convince him that the total will be correct after he goes back and forth to the backstage.
    By the way, your videos are the best. I enjoy them all.

  • @Aaron_Lesse
    @Aaron_Lesse Год назад +1

    How can I export this Word document to a PDF while preserving the fillable (and calculable) form fields?

    • @SharonSmith
      @SharonSmith  Год назад +1

      Hi Aaron, unfortunately you are not able to save a Word form as a PDF and preserve the form field functionality. You users would need to be able to open the form in Word. However, if you save it as a PDF, you can then import that into a PDF editor and create the PDF as a fillable form. If you have access to Adobe Acrobat, here is a video that shows how you can do this and how you can re-create calculating form fields: ruclips.net/video/-W9uFiKLXaE/видео.html If you don't have a license to Adobe Acrobat, there are other PDF editor options out there you may be able to use. I hope this helps! Thanks for watching!

    • @Aaron_Lesse
      @Aaron_Lesse Год назад

      @@SharonSmith thanks for your response, and the information!

  • @markdevine9371
    @markdevine9371 Год назад

    Hi, is there other way to trigger the calculation function other than Tab ?

  • @user-dn9vd9xg9p
    @user-dn9vd9xg9p 2 месяца назад

    I can not get into auto-calculate when I change a number in the data. I have to right l click and select 'update' field to change the total column each time.

  • @sdash1057
    @sdash1057 3 года назад

    Thank you

  • @raj2016
    @raj2016 2 года назад

    Hi could you please explain that filed in table are in sync do we have to select exact filed header??

    • @raj2016
      @raj2016 2 года назад

      I wanted to calculate tax over one line item and sum the same.

  • @farestahamohamed835
    @farestahamohamed835 4 года назад +2

    Nice Nice Nice

  • @manideepak6820
    @manideepak6820 4 года назад

    Mam can I maintain invoice register in excel (export word data to excel) when number of invoices are there in ms word

  • @alemendez3966
    @alemendez3966 3 года назад

    How can one make the word to calculate to the nearest tenth. Example $11,860.45 at 90% should equal $10,674.41, but it keeps give me $10,674.40. how can I fix these issues in a fillable form.

  • @marykearney4479
    @marykearney4479 3 года назад

    I'm trying to create a basic budget type form with multiple subtotals but cannot get any formula to work for the final total of all the subtitles. It's all addition. Please help.

    • @SharonSmith
      @SharonSmith  3 года назад

      Hi Mary! There is a limitation in MS Word that you can't create a calculated form field with an expression that has other calculated form fields in the equation. You have to create the equation in the grand total to add all the bookmarked fields you want to be included (and not the subtotaled fields that contain another calculation). I hope this fixes your issue. Thanks for watching!

  • @turtlebobprod
    @turtlebobprod 2 года назад +1

    Not sure why but this is not working for me. I've tried several times but nothing calculates. :-(

  • @ModernPindawale
    @ModernPindawale 4 года назад

    Mam one tutorial on customize capture various visitor details word form. How I customize

  • @ModernPindawale
    @ModernPindawale 4 года назад

    Mam I have request you for tutorial kdp formatting for children book. If you start tutorial on ebooks
    Like manuscript and children book formatting

  • @mdabdulkaium293
    @mdabdulkaium293 2 года назад

    sister i am a new in skill of computer knowledge

  • @ian-abq
    @ian-abq 2 года назад +1

    Help please!! If I want to subtract days to a date? How can I do it?

    • @SharonSmith
      @SharonSmith  2 года назад

      Hi Ian! Depending on what you need to do, you may want to consider creating your form in Excel instead of Word. You can easily set up formulas to subtract dates in excel (or number of days from a date) since Excel stores dates as sequential serial numbers. Here are two videos that may help. First, how to create forms in Excel: ruclips.net/video/_g7863PjNns/видео.html and then how to subtract dates in Excel: ruclips.net/video/9CY1mXy1MPY/видео.html Thanks for watching!

  • @anitanooknaidu9861
    @anitanooknaidu9861 3 года назад

    what if the text fill(static fields) is in list drop down? i tried but it is not calculating

  • @julien6123
    @julien6123 3 года назад +1

    Why do the fields remain grey after entering the information?

    • @SharonSmith
      @SharonSmith  3 года назад +1

      Hi Julie, you can turn off the gray shading of the form fields. The second part of this short video shows you how to do that. Hope this helps! ruclips.net/video/vagwP5Jsv7k/видео.html Thanks for watching!

  • @fotograf121
    @fotograf121 3 года назад

    Great thanks. Just verify that Word is anchient compared to pages in many aspects with forms. Yes including excel sheets is possible but it is just a terrible integration. Its a shame that they haven't made it better

  • @somewhereupthere
    @somewhereupthere 4 года назад +1

    💓

  • @سقوطالجدار
    @سقوطالجدار 4 года назад

    There is a problem in the subtraction process, (=Total - another field) How can it be?

  • @a007fan
    @a007fan 2 года назад

    Hi Sharon - great videos you offer.
    I tried creating a calculated field for the age of a patient based on today's date (which appears in the form as a named form field) and his/her birthday (another named form field). On the age field I typed formula: =Date_Today - Date_Birth.
    The result though is always 0.
    I can't figure what I did wrong...

    • @Michelle.Engstrom
      @Michelle.Engstrom 2 года назад

      Did you ever figure out the issue? I have had the same issue!

    • @a007fan
      @a007fan 2 года назад

      @@Michelle.Engstrom sorry but no. I tried many options and nothing worked. And got no reply whatsoever from Sharon which is kind of lame.
      If you ever figure it out I’d be happy if you could share that with me. Tnx.

  • @jonnyconnoro
    @jonnyconnoro Год назад +1

    How do I change the currency to GBP?

    • @SharonSmith
      @SharonSmith  Год назад

      I believe you may need to change your Windows default currency setting, and I'm not sure if you want to do that. You would start typing Currency in your Windows search field and select "Change the way currency is displayed" and this would only change the symbol available. Hope this helps! Thanks for watching!

  • @westernapache1700
    @westernapache1700 3 года назад +1

    Usually subtotal would be placed above tax.

    • @SharonSmith
      @SharonSmith  3 года назад

      Agreed! Thanks for watching!

  • @markk364
    @markk364 2 года назад

    DOES NOT WORK WITH WORD 365 - which now uses Content Controls --- which requires lots and lots of VBA to do what Legacy Controls once did via the "Properties" drop down. Progress hurts when you use MS.

  • @caifakorosr5720
    @caifakorosr5720 5 месяцев назад

    This is exactly what I want but you don't you start for the beginning

  • @espeterson522
    @espeterson522 Год назад

    This isn't working for me at all unfortunately. I can't even get one set of fields to sum despite following these instructions to the T.