How To Link Text or Images To A Drop-Down List Selection in MS Word - Create Fillable Forms

Поділитися
Вставка
  • Опубліковано 5 жов 2024
  • HOW TO LINK TEXT OR IMAGES TO A DROP-DOWN LIST SELECTION IN MS WORD - CREATE FILLABLE FORMS // Learn make text or an image appear in your document based off what a user selects from a drop-down list. This video will show you how to do this using a Time-Off Request Form where different instructions and time off reasons appear if a user selects the employment status of Full-Time vs. Part-time. This technique can be used to also insert a particular image file depending on the drop-down item selected. We review this using signature image files at the end of this form.
    You can purchase my form template at: www.etsy.com/l... in case you want to use the field code as an example or customize this template to fit your needs. This video will show you how to set up a form with similar functionality. Thank you for supporting my channel!
    Want to take your form-building skills to the next level? Consider taking my Course on Creating Fillable Forms in Microsoft Word:
    • Creating Fillable Form...
    __________
    RESOURCES & GEAR
    ✦ Screen Recording Software: techsmith.z6rj...
    ✦ Green Screen: amzn.to/2DnHsY2
    ✦ Camera: amzn.to/39KvpQA
    ✦ JotForm: www.jotform.co...
    ✦ PresenterMedia: shareasale.com...
    Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
    __________
    NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: www.paypal.com.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
    __________
    FREE DOWNLOADS:
    ✦ Visit mailchi.mp/6a0... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
    __________
    CONNECT WITH ME:
    Visit my website: www.sharonsmit... for more information, tools and resources.
    LinkedIn: / sharonsmithhr
    Twitter: / sharonsmithhr
    __________
    KEYWORDS: #MSWord, #M365, How To Link Text or Images To A Drop-Down List Selection in MS Word, How To Make Text Automatically Appear After User Selects From A Drop-Down List, Conditional Question Formatting in MS Word, How To Create Conditional Formatting in Word Forms, Create Fillable Forms in Word, Program Conditional Formatting in Word Forms, Insert Photo in a Drop-Down, MS Word Tutorial, MS Word Lesson, Creating Fillable Forms, Sharon Smith HR, @SharonSmithHR
    __________
    PLAYLISTS:
    ➤Creating Fillable Forms: • How To Create A Fillab...
    ➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
    ➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
    ➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
    ➤ Word Tutorials for HR: • Microsoft Word Tutorials
    ➤ Welcome | About Me: • Playlist

КОМЕНТАРІ • 386

  • @SharonSmith
    @SharonSmith  Рік тому +1

    Want to take your form-building skills to the next level? 🚀 Checkout my UA-cam Course on "Creating Fillable Forms in Microsoft Word: A Step-by-Step Guide," ua-cam.com/play/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs.html where your frequently asked questions on forms are answered, like how to insert a Submit form button that works with any email client and how to export completed form data to Excel quickly and easily.

    💡 The Course includes 15 video lessons, a handy PDF workbook with all lesson summaries and VB code tidbits, and two versions of the Word form template we build together (a behavior-based interview questionnaire form).

    You can still always access all the free content on my Channel (over 100+ video tutorials). Please note that the UA-cam Courses feature is in Beta and currently limited to a subset of Creators. Courses are only available in the United States, South Korea, and India. Viewers must use a computer or Android device to buy a Course. We hope UA-cam Courses will roll out to more Creators, devices, and regions in the future!

    Thank you for taking the time to checkout my Course! You may see some of your other favorite UA-cam Creators who have also launched Courses by going to their Channel page and clicking on the "Playlist" tab. Enjoy!

    • @hrk.videos
      @hrk.videos Рік тому

      Kindly, show how to add a watermark to the entire page easily. As I see that predefined templates provide only one word.

  • @drthanhtam
    @drthanhtam 3 роки тому +5

    Thanks for for teaching Sharon. Your kindness changes the world.

    • @SharonSmith
      @SharonSmith  3 роки тому

      You are very welcome, and thank you for your kind words! Thanks for watching my videos!

  • @wingame52
    @wingame52 3 роки тому +2

    after using MS Word for years, never had I imagined it could do so much. Or that users can insert codes into Word. The explanations were clear and easy to follow. thank you!

    • @SharonSmith
      @SharonSmith  3 роки тому

      So glad you found it helpful and easy to follow. Best of luck to you! Thanks for watching!

  • @migoram
    @migoram 4 роки тому +2

    hello Sharon i am french and you have no idea how happy i am o have found your channel.I learn a lot and love your voice thank you so much .I don't even understand how you don't have more follower

    • @SharonSmith
      @SharonSmith  4 роки тому

      Thank you Michelle! I am so happy you found my channel and I'm very glad to hear you find my videos helpful and that you are learning a lot. Yes, I hope to grow my channel with more followers! Thank you for watching!

  • @trentzajac4335
    @trentzajac4335 Рік тому +1

    We provide scripts to our managers during separations conversations. What we say depends on certain aspects of the separations. This will be a perfect way to create an automated script that varies depends on the circumstances of the separation! So thankful this popped up in my recommended!

    • @SharonSmith
      @SharonSmith  Рік тому

      That is great Trent! I'm so glad you found this helpful so you can automate your scripts. That sounds like a great tool/resource for your managers to assist them with those difficult conversations. Best of luck! Thanks for watching and for subscribing to my Channel!

  • @chilosopher
    @chilosopher 3 роки тому +2

    Saved me 3 hours googling online.... Thank you!!!!!!

    • @SharonSmith
      @SharonSmith  2 роки тому

      You are welcome! Glad you found this video and that it saved you some time!! Thanks for watching!

  • @angelahoward3001
    @angelahoward3001 3 роки тому +2

    Hi sharon. I am leaping with joy. I tried out the part for adding image signature and it worked. I'm so so excited. I really want to thank you for your video and how your tutorial is so straight forward and simple. Thumbs up and keep up the great work.

    • @SharonSmith
      @SharonSmith  3 роки тому

      Thanks so much Angela!! That is great feedback and I'm so glad this worked for you. Thanks for watching!

  • @keerthananratnajothy4094
    @keerthananratnajothy4094 Місяць тому +1

    Started watching your videos recently. They are quite helpful. Thanks and lots of love from Sri Lanka!

    • @SharonSmith
      @SharonSmith  Місяць тому

      Hello and thank you so much for watching my videos and for subscribing to my Channel! I'm so glad you found me and that you find my videos helpful. Take care!

  • @js4513
    @js4513 2 місяці тому +1

    Your videos are so well done. Very detailed but very easy to follow along to. Thank you so much!

    • @SharonSmith
      @SharonSmith  2 місяці тому

      I’m so glad you find my videos helpful! Thanks for the nice comment and for watching my videos!

  • @michaelwilcox1913
    @michaelwilcox1913 2 роки тому +1

    Thank you so much Sharon. I didn't realise that this was what i was looking for until I found it. Very helpful and extremely easy to follow.

    • @SharonSmith
      @SharonSmith  2 роки тому

      That is great to hear, Michael! Glad you found my videos! Thanks for watching!

  • @UniversalFlowTherapy
    @UniversalFlowTherapy 2 місяці тому +1

    Thank you finally I was able to work out how to this after watching this no other videos made sense! 🙏🏻

    • @SharonSmith
      @SharonSmith  2 місяці тому +2

      I'm glad to hear my video helped you! Thanks for watching!

  • @mgcservices7524
    @mgcservices7524 3 роки тому +1

    THANK YOU, Sharon! This has certainly helped with adding large amounts of text depending on the answer to the question. You're a star - Have a great New Year.

    • @SharonSmith
      @SharonSmith  3 роки тому

      You are very welcome Malcolm! Glad to help! Have a Happy New Year!

  • @lawrencereid
    @lawrencereid 2 роки тому +1

    Nice, clear and calm instructions. I actually enjoy listening to your instructions.....Can apply this today when I create a form for my boss. She wants some new automation when documenting work instructions

    • @SharonSmith
      @SharonSmith  2 роки тому

      Hi Lawrence! I'm so glad you like my videos and glad to hear you can use this to help you at work! That is my goal. Good luck and thanks for watching my videos!

  • @charlesball9522
    @charlesball9522 2 роки тому +6

    For everyone struggling to get their text to show up. You cannot use a "new controls" version of the text content control boxes, you must use a "legacy" text field (form control) to tab to.

    • @tanguerochas
      @tanguerochas Рік тому

      you can, it just takes some different methods

    • @SharonSmith
      @SharonSmith  Рік тому +1

      Thanks, Charles! Yes, this method requires using legacy tool form fields. Thanks for watching!

    • @davidtramsek3722
      @davidtramsek3722 Рік тому

      @@tanguerochas Where can i find the instructions - link please. Thanks.

    • @Naelnaz
      @Naelnaz 11 місяців тому +1

      I am using the "legacy controls" and my text still is not showing up. What am I doing wrong?

    • @aquarian50
      @aquarian50 10 місяців тому

      ​@@Naelnazsame with me it does not show

  • @terryguire1321
    @terryguire1321 Рік тому +1

    I'll definitely be looking to your channel to develop practical Power User skills. This was a great lesson!

    • @SharonSmith
      @SharonSmith  Рік тому

      Thank you so much, Terry, for the Super Thanks!! I really appreciate your support! I'm so glad you find my videos helpful. Thanks for subscribing to my Channel. Best of luck to you!

  • @ukeitaa
    @ukeitaa 2 роки тому +1

    This is such a thorough and detailed tutorial, thank you!

    • @SharonSmith
      @SharonSmith  2 роки тому

      So glad to hear you found it helpful! Thanks for watching!

  • @SharonSmith
    @SharonSmith  4 роки тому +10

    Be sure to watch this video NEXT on creating multiple levels of dependent drop-down lists: ua-cam.com/video/54dSJukbe3k/v-deo.html

    • @evdelrio
      @evdelrio 3 роки тому

      Do you provide services to create/customize Word documents?

    • @anupriyasaxena5930
      @anupriyasaxena5930 Рік тому

      Is there a way different fillable forms appear based on the selection from drop down option?
      Ex: when I select drop-down option 1, then fillable form 1 appears.
      When drop-down option 2 is selected, fillable form 2 appears.

    • @xiaohan3478
      @xiaohan3478 Рік тому

      Is there a way that I can share this Marco attached word with others?

  • @JoshCamson
    @JoshCamson Рік тому +1

    Terrific video. I had a different use case and used the IF functionality coupled with an ASK function for making letterhead that pre-populates different signatures. Worked like a charm.

    • @SharonSmith
      @SharonSmith  Рік тому +1

      That is awesome, Josh! So glad you found this helpful and that you were able to build on it to create what you needed. Thanks for watching my videos! Best of luck!

  • @suresighthomeinspectioninc6540
    @suresighthomeinspectioninc6540 4 роки тому +2

    This is the first of all the "how-to" videos out there that addresses this, thanks! I didn't know this was possible. Quick question. Is there a way to add text like in this tutorial if a legacy checkbox is selected? I tried using the same code you used for the drop-down list but it doesn't work. You would forever be my hero if you could let us know how to do this with a check box.

    • @SharonSmith
      @SharonSmith  4 роки тому

      This is a great question and several people have asked about this. I'm researching it now. Thanks so much for watching my videos!

  • @alexdelarge2095
    @alexdelarge2095 2 роки тому +1

    Very well done. Start with an example to show what this is about (unlike most videos where you have no clue if they are even doing what you want), and explain step-by-step.
    I just wish there was also a quick mention on creating text depending on whether a box was checked or not, since I needed that too. Hopefully google will help with that.

    • @SharonSmith
      @SharonSmith  2 роки тому

      Thanks Alex! Glad you found it helpful. I have not found a way to do the same with checkboxes yet, but if I do, I'll do a video. Thanks for watching!

    • @terryguire1321
      @terryguire1321 Рік тому

      @@SharonSmith Yes, I wondered the same. Thanks for paying attention to your user requests!

  • @westonmckain2690
    @westonmckain2690 Рік тому +1

    Thank you, Sharon. This video helped immensely. Is it also possible to include a plain text form field within the condition? So, the drop-down selection would essentially create another item for the user to fill out. It haven't had any luck doing this.

  • @efoster123
    @efoster123 4 роки тому +6

    Thanks so much, Sharon! Could you use the same methodology for linked text with checked boxes as well?

    • @SharonSmith
      @SharonSmith  4 роки тому +3

      Hi Emily! Great question - I'm researching how to do this. Thanks so much for watching my videos!

    • @kylebgc
      @kylebgc 3 роки тому

      This would be amazing if possible with check boxes too! Eg. Auto-filling drug doses and basically anything in a paragraph by quickly ticking through a bunch of check boxes :)

    • @esnyde4
      @esnyde4 3 роки тому

      Asking if there has been any sort of update on having the auto-text from a checkbox? That, along with using drop downs, would be incredible for updating my forms!

    • @ciarahoddenbach6866
      @ciarahoddenbach6866 8 місяців тому

      @@SharonSmith similar to @naelnaz_moosecraft I am using the "legacy controls" and my text still is not showing up. What am I doing wrong?

  • @BookFinch
    @BookFinch Рік тому +2

    No matter how many times I try, when I hit tab it jumps to the next drop down list on the page and the text does not appear. 😕

  • @simonmccormack605
    @simonmccormack605 3 роки тому +1

    Sharon, thank you so much for the forms videos. They are amazing!!!

    • @SharonSmith
      @SharonSmith  3 роки тому

      Thank you Simon! So glad you found my videos helpful! Thanks for watching!

  • @burgessinspectionsinc1847
    @burgessinspectionsinc1847 Рік тому +2

    Great video! Thank you for this. Is there a syntax that can be used when the drop down uses two words? I seem to get this to work only when the dropdown is a single word, or connected words.

  • @ProtoRaptor40
    @ProtoRaptor40 3 роки тому +1

    Thank you so much! I stumbled upon this tutorial, but it's one of the things I was wondering about. Definitely a well-done video. It also showed me that I want to be using the Legacy Tools instead of the newer standard ones.

    • @SharonSmith
      @SharonSmith  3 роки тому +1

      Hi Mike! So glad you found my videos helpful. Yes, you can do a lot with the legacy tool form fields. I have a playlist on my channel related to creating fillable forms you may find helpful: ua-cam.com/play/PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv.html Thanks so much for watching!

  • @Riodejenny
    @Riodejenny 2 роки тому +1

    Thank you! This was exactly what I needed! Now, once I test the document my coding goes away. How do I get it to show back up in case there is an error and I need to fix it? Again, fantastic videos!

  • @akulomnarayan6663
    @akulomnarayan6663 3 роки тому +1

    Mam ur One of the best presentational videos.

    • @SharonSmith
      @SharonSmith  3 роки тому

      Thank you so much, that is so nice of you. Thanks for watching my videos!

  • @SA-zx4qw
    @SA-zx4qw Рік тому +1

    Your videos are the best. Very easy to follow along. Perfect for a project that I am working on. Can you create a video on how to "fix" the coding if you make an error. For instance, I hit Ctrl+9 one too many times and then I was unable to remove the extra set of brackets. Each time I make this error, I have to re-creating the entire coding line from scratch. Thanks!!!

    • @SharonSmith
      @SharonSmith  Рік тому

      Thanks so much for your comment. I will try and recreate this issue and see if there is a better fix. Thanks for watching my videos!

  • @georgiostheodorou9946
    @georgiostheodorou9946 4 роки тому +2

    Very useful and very unique material

    • @SharonSmith
      @SharonSmith  4 роки тому

      Thank you Georgios! Glad you found this helpful. Thanks so much for watching and taking time to leave a comment!

  • @JasonLeeCookMusic
    @JasonLeeCookMusic 3 роки тому +3

    Thank you Sharon! You're a great instructor, I'm so glad I found your channel! Question - is it possible to have entire tables dependent on fillable forms? For example, I've created a set of dropdown selections in my form and I want a specific set of information to populate onto the form in a table format (e.g. 1x3 table as can be inserted from the Insert tab) for each different option the user chooses.
    I've tried googling this but perhaps I'm using the wrong terminology because I haven't found good information on it. Thanks again and I'll look forward to your response!

    • @SharonSmith
      @SharonSmith  3 роки тому

      Hi Jason, thanks so much for watching my videos. I'm glad you find them helpful! I will look into this for you. You can definitely structure your form with tables and have text appear in those tables based on drop down selections. I'll see if I can find some examples. Thanks again for watching!

    • @JasonLeeCookMusic
      @JasonLeeCookMusic 3 роки тому

      @@SharonSmith yes I've considered that solution and it may work for some applications but I was hoping to have the tables themselves show up or not depending on drop down selections to avoid having empty tables if certain options are not needed.
      Thanks for the response!

    • @mabel888
      @mabel888 2 роки тому

      @@SharonSmith Great videos Sharon! I'm wondering the same thing as Jason. I want to populate a pre-created table based on a drop down selection. Is this even possible? Thanks!

    • @chrisnaidoo4596
      @chrisnaidoo4596 2 роки тому

      @@SharonSmith Excellent tutorial videos Sharon! I'm wondering the same thing as Jason and Mabel. I want to invoke a pre-created table per drop down selection of which there can be multiple dropdown selections in my Word fillable form. I'm sure with your great talent, a solution is possible.

  • @shardagovender4465
    @shardagovender4465 3 роки тому +1

    Thank you, I am a new subscriber and finding the content extremely useful.

    • @SharonSmith
      @SharonSmith  3 роки тому

      Hello Sharda! Thank you so much for subscribing to my channel and watching my videos. I'm glad to hear you find them helpful! Take care!

  • @KateDiviney
    @KateDiviney Рік тому +1

    This video is great but I am having a few issues in my own application. When I select a drop down field with the intention of other areas being populated, as per the video, it works the first time but then when I try to test the other options to toggle between it either takes a long time or doesn't work and stays stuck on the first one. Any ideas why that may be?

  • @VijayendranRaghavendran
    @VijayendranRaghavendran 5 місяців тому +1

    Thank you very much for the video. Very useful.

    • @SharonSmith
      @SharonSmith  5 місяців тому

      Glad you found it helpful! Thanks for watching!

  • @bilsan21
    @bilsan21 2 роки тому +1

    Thankyou Sharon for the great Tutorial.
    I have a question how can we edit a field code later.

    • @SharonSmith
      @SharonSmith  Рік тому

      Hit Alt+F9 (or Alt+Fn+F9) and that will show your field codes if you need to edit them, and hit the same thing to hide them again. Hope this helps! Thanks for watching!

  • @arjavkumar
    @arjavkumar 3 роки тому +2

    Hi Sharon, nice tutorial. I have a question: What if we don't select the 'calculate on exit' checkmark at 10:16?

  • @shareitwithit7323
    @shareitwithit7323 2 роки тому +1

    Thank you Sharon it very professional explanation

    • @SharonSmith
      @SharonSmith  2 роки тому

      Glad you found it helpful! Thanks for watching!

  • @beaujuan1186
    @beaujuan1186 Рік тому +1

    This is exactly what I needed!
    Does anyone know how to get data entered from a form like this in word, automatically generated into an excel table?

    • @SharonSmith
      @SharonSmith  Рік тому

      Hello! Here is a video you may find helpful on how to export form data from legacy fields in Word into Excel: ua-cam.com/video/vuddH0Tke0M/v-deo.html You can build on this concept and set up for the Power Query to get all forms you place into a specified folder. I hope this helps! Thanks for watching!

  • @tomsopchak5736
    @tomsopchak5736 3 роки тому +1

    Super video. Made my life much easier. So after you start restrictions and the conditional text disappears, how do you restore (or see) that conditional text again?

    • @SharonSmith
      @SharonSmith  3 роки тому

      Hi Tom! You do have to have another form field for users to tab into as the conditional text fields will appear after the user fills in information in the form field and then hits tab (because it works by "calculating upon exit") from the form field. If you need to edit the form, you can stop protection on your document and then hit Alt+F9 (or Alt+Fn+F9 depending on your keyboard) to display the reference fields in your document. When you are done editing, hit Alt+F9 again to turn that view off and the reference fields will "disappear" again. Hope this helps! Thanks for watching!

    • @tomsopchak5736
      @tomsopchak5736 3 роки тому

      @@SharonSmith Yes, I do.

  • @christopherwilson4103
    @christopherwilson4103 4 роки тому +2

    This Video and all your others are fantastic - I've learned loads... thank you so much! Do you know how I could adapt the statement fro display set according to a check-box rather than a drop-down? I've tried to adapt the IF statement but I haven't had much success.

    • @SharonSmith
      @SharonSmith  4 роки тому +2

      Hi Christopher! Glad to hear you have learned a lot. I am researching this now, several people have this same question. Thanks so much for watching my videos!

  • @fredrickkuiper2988
    @fredrickkuiper2988 Рік тому

    Thank you. This was a great video. I wondered how we can do this on desktop Office 365. Thx.

    • @SharonSmith
      @SharonSmith  Рік тому

      Glad you found it helpful! Thanks for watching!

  • @alielsheikh8091
    @alielsheikh8091 3 роки тому +1

    Very useful and a lot of new info, tips and tricks here.. Keep it up

    • @SharonSmith
      @SharonSmith  3 роки тому

      Thank you so much Ali! So glad you found my videos helpful! Thank you for watching!

  • @johnwith-bold7328
    @johnwith-bold7328 3 роки тому +1

    Very Awesome! I am SO excited I found your videos. These seams to be Very Easy to follow. With that said ANY Chance you're available to build 3-4 very simple documents? Seriously, I'm so busy I do not have time. Or is there any chance you have documents for sale anywhere? If I had the keystrokes with a few working examples, I could work my way through it more quickly. Thank you for your consideration

    • @SharonSmith
      @SharonSmith  3 роки тому

      Hi John! So glad you found my videos helpful! I do have a few form templates available at: www.etsy.com/shop/SharonSmithHR?ref=seller-platform-mcnav that may help you get started. Feel free to email me at Sharon@SharonSmithHR.com if you want to share more details about the forms you are looking to create. Thanks so much for watching!

  • @angelparra1226
    @angelparra1226 3 роки тому +4

    Good Morning everyone!! I have a problem...
    I need the data to update automatically as it appears in the video,
    my problem is that when I select an option they are not updated and to see what changes I have to right click and select an option from "update fields"...
    I am not interested in this solution, is there a way to do it automatically? THANK YOU PEOPLE!!!!!

    • @marytellez5929
      @marytellez5929 3 роки тому +1

      I would love to know the answer to this as well.

  • @beckiclist3910
    @beckiclist3910 4 місяці тому

    Great video! Is there a way to link certain text to the selection from two different dropdowns as opposed to one like this video?

  • @polychronischouzanas
    @polychronischouzanas Рік тому +1

    Thank you very much for all useful videos!Could I do the same but with a check box?When I click the check box to show a message next to it for example?

    • @SharonSmith
      @SharonSmith  Рік тому

      Hello! Unfortunately the functionality doesn’t exist yet for checkboxes. Hoping Microsoft will enhance that sometime. Thanks for watching!

    • @polychronischouzanas
      @polychronischouzanas Рік тому

      Hi once again!
      I would like to know if I am able to show text,based on two or more drop down menus using "And" , "or" in my code...would that be possible?

  • @mariaglezildasoriano7259
    @mariaglezildasoriano7259 4 роки тому +1

    This is amazing! Thank you so much for sharing this!!!

    • @SharonSmith
      @SharonSmith  4 роки тому

      Thanks Meg! So glad you found my videos helpful. Thanks for watching and taking time to leave a comment!!

  • @OlivierKerkhofs
    @OlivierKerkhofs Рік тому +2

    Hi Sharon, great video! But I have one question. You mention that "a user" can fill in this form. But if a user wants to select an option (in your example eg. Full-time), that user must be in “Restrict Editing Mode”. Or is there a way that other users who don’t have “developers menu” and “Restriction mode” on, can use the form? I hope you can help!

    • @sylviamacatangay6945
      @sylviamacatangay6945 Рік тому

      This also my question. Have you found the answer already? Can you share?😊

    • @SharonSmith
      @SharonSmith  Рік тому

      Hi Olivier, when you create the form and restrict editing and then save it, you should be able to send to a user as a locked form and they would not need the developer tab enabled in their Word version in order to fill in the form. You can also save the form as a template file type if desired. I hope this helps!

  • @hermannvalsson4237
    @hermannvalsson4237 3 роки тому +1

    Great way to teach thank you.

    • @SharonSmith
      @SharonSmith  2 роки тому

      You are very welcome, Hermann! Thanks so much for watching!

  • @rogangranite
    @rogangranite 3 роки тому +1

    Thank you so much another great video.

    • @SharonSmith
      @SharonSmith  3 роки тому

      You are very welcome, Thomas! Thanks so much for watching!

  • @MissVirtue35
    @MissVirtue35 3 роки тому

    Hi Sharon, I have gone through the comments to try to find an answer to this question that I have... however... there's just to many to scroll through. lol and rightly so because your videos are a tremendous help so thank you again!
    My question is: Once I've created the drop down menu and have successfully linked it to the text, am I able to edit the "IF" statements without creating it all over again. I'm having a difficult time trying to figure this out. Thank you in advance!

  • @sidflashgaminggghacker9223
    @sidflashgaminggghacker9223 2 роки тому +1

    You are awesome Sharon

    • @SharonSmith
      @SharonSmith  2 роки тому

      Thanks so much, Abubakr! Thanks for watching my videos!

  • @toddwindsor8362
    @toddwindsor8362 Рік тому

    Hi Sharon. I've been trying to find this solution for months. This is EXACTLY what I need!! However... my document needs to have two image fields that will have more than the 25 options allowed in a legacy dropdown. Do you happen to have a video on how you would do the image fields with the ContentControl dropdown (that has an unlimited number of items)?

  • @luismauricio1277
    @luismauricio1277 2 роки тому +1

    Thank You it was very helpful.

    • @SharonSmith
      @SharonSmith  2 роки тому

      Glad you found it helpful! Thanks for watching!

  • @wnnproperties_1
    @wnnproperties_1 Рік тому +2

    Hey Sharon. I was trying to follow your video but my dropdown list settings doesn't have the option to bookmark. what do I do if I don't have that option?

    • @SharonSmith
      @SharonSmith  Рік тому

      Hello - are you using Legacy Tool drop-down field? If you selected the Content Control drop-down field then you won't see the same properties, like the option to bookmark. On the developer tab, select the Legacy Tools drop-down and then use the Legacy Form options. I hope this helps! Thanks for watching!

  • @michielsteurbaut9930
    @michielsteurbaut9930 3 роки тому +1

    For some reason the IF statements - although following your exact same logic- do not work for me.
    I select an item in the dropdown menu, clearly REF it into the formula field, but nothing happens.
    Any advice, please?

  • @sandrabrennan7411
    @sandrabrennan7411 2 роки тому

    Hi Sharon great videos thank you. I am new to this and have created a document following your instructions and it worked great. My question is how am I able to view and edit the different linked text if I have to do so.

  • @jamienimmo6935
    @jamienimmo6935 4 роки тому +1

    Excellent video and very informative as usual Sharon. What is the best format to save the document, as a Word Template or just a Word document?

    • @SharonSmith
      @SharonSmith  4 роки тому

      Thank you Jamie! Saving as a Word Template is helpful if you or your users will re-use the form and want to start with a fresh blank form template every time you open a new file. Basically, users can't "save" over a template file type with their filled in answers, they can only "save as" and name the document something new. Hope this helps! Thanks for watching!

  • @cindyklier103
    @cindyklier103 2 роки тому +1

    Hi Sharon, I have been watching your video's and have learned a great deal from you. Thank you for producing these. I was wondering if you could provide a tutorial on using a drop down that would produce multiple options within an editable text field that is mostly prefilled with text, but includes additional drop downs, form fields and date pickers. Thank you :)

    • @tanguerochas
      @tanguerochas Рік тому

      Cindy, for that you may want to be using Content Controls instead of legacy form fields together with AutoText/Building Blocks. Use the Building Blocks Gallery Content Control.

  • @emiliojones5983
    @emiliojones5983 2 роки тому +1

    Thanks a lot for this very helpful tutorial. But i have a question. I want to create a dropdown-list in de Visual Basic Script. i.e. When i select a job title from dropdown-list i want it to show a certain text with a drop-down-list. But when i select the drop-down list, it jump back up to the beginning of the page. Is there a way to fix this?

  • @josephcosgroveF4fl
    @josephcosgroveF4fl 4 роки тому +1

    Excellent video (as always). Just a quick one on protocol. I don't think it's a good idea to have the manager's signature popping up. Their name yes, but they should sign it themselves. I know I'm being finnikey.

    • @SharonSmith
      @SharonSmith  4 роки тому

      Hi Joseph - great feedback. Yes, you would only want to use that feature if you had permissions for signature files. The technique of inserting image files to appear with a drop-down selection can have many uses, so I wanted everyone to see how to do it. Thanks again for watching!

  • @lindseyhotz2327
    @lindseyhotz2327 2 роки тому +1

    Love this video - very helpful! Can this be done referring to whether a checkbox is marked or not? For instance, if someone checks "vacation", can we create an IF statement that shows certain additional text regarding using vacation time?

    • @SharonSmith
      @SharonSmith  2 роки тому

      Hi Lindsey, unfortunately the same technique does not seem to work with checkboxes. If I find a way, I'll certainly post a video on it 😉Thanks for watching!

  • @GabrielLG-o2y
    @GabrielLG-o2y Місяць тому

    Thank you for the video, the conditional is not saving in my word file, it needs to be Word with macro enable?

  • @steffanmarx5305
    @steffanmarx5305 3 роки тому +1

    Hi Sharon, when my formulas work perfectly, how can I use them without having to turn on limited editing on?
    fantastic video!

    • @SharonSmith
      @SharonSmith  3 роки тому +2

      Hi Steffan! This video might be helpful for you related to locking only part of your Word document (restricting only the sections that have form fields) but leaving the rest of the document open to editing: ua-cam.com/video/Xsh6Tk6xJB8/v-deo.html Hopefully this helps you out. Thanks for watching!

  • @humbertogalvez2458
    @humbertogalvez2458 Рік тому

    Thanks, Sharon for the video, is very useful, but, if I want to use a check box list instead of drop-down list, what do I have to do? Thanks

  • @alanpritchard3734
    @alanpritchard3734 3 роки тому +1

    Hi Sharon, sorry for jumping on an old video, but your videos have been really useful to me. Do you have a video similiar to this one but for nested IF statements. i.e. the output text is variable depending on the condition of two separate drop downs?
    Thank you.

    • @SharonSmith
      @SharonSmith  3 роки тому

      Hi Alan! Thanks so much for watching my videos! Glad you are finding Ethel helpful. I don’t have a video on this but hoping other videos in my playlist are helpful! Take cate!

    • @daniellelockhart511
      @daniellelockhart511 3 роки тому

      Hey Alan just wondering if you’ve figured out the answer to your question yet? (I’m trying to figure this out now!). Thanks!

    • @christinacerqueira4068
      @christinacerqueira4068 3 роки тому

      Hey Alan, I'm also trying to work this out now. Did you get it sorted out?

  • @sindibahshiyan7434
    @sindibahshiyan7434 7 місяців тому

    Great tutorial, however I have a question is it possible to edit text that was prepopulated based on drop down selection?

  • @julien6123
    @julien6123 3 роки тому +1

    I really want this to work. I cant even get the Legacy forms to work. (2016 document that is not saved in compatibility mode) I can place a field in the form, but when I try to see if it works...nothing. I have been able to use the content controls in general. I want to place a logo in a form that I can choose to swap out with another logo when needed.

    • @evetay7125
      @evetay7125 3 роки тому

      I have the same problem :(

  • @CarlaGrangerOlivares
    @CarlaGrangerOlivares Рік тому

    hello! excellent video thank you very much, it helped me a lot at work; and I was wondering if it is possible that from the selection of an element in the document the header changes. I tried to follow the same instructions, but it tells me that there is an error because the second part of the condition is missing. I would really appreciate it if you help me, thanks in advance. love your channel

  • @md2414
    @md2414 3 роки тому +1

    Thank you so much for all your video’s, Sharon!They are also very helpfull in The Netherlands ;) However, because of the editing restrictions it isn’t possible to fill in forms and make remarks at the same time. Do you have a solution for this?

    • @SharonSmith
      @SharonSmith  3 роки тому +1

      Hello! It is possible to only lock part of your Word document (so only the form section has to be restricted) and the rest of the document can be edited. I have a video on this: ua-cam.com/video/Xsh6Tk6xJB8/v-deo.html Hope this helps! Thanks so much for watching!

  • @mifabiansen1883
    @mifabiansen1883 Рік тому +1

    Thank you so much for posting this video - it helped me quite a lot. However, can you explain to me what I should write in those brackets IF I am dependent on two REF fields? I have tried so many combinations because I would like it to be {IF {REF XX}="abc" and {IF {REF YY}="def" then return "XXXX". I hope you have to time to answer and let me know "how easy I can solve this problem" :)

    • @SharonSmith
      @SharonSmith  Рік тому

      Hello! Please try this as your REF field code syntax:
      { IF { REF XX } = "abc" { IF { REF YY } = "def" "XXXX" "" } "" }
      I hope this helps! Thanks so much for watching my videos!

    • @mifabiansen1883
      @mifabiansen1883 Рік тому

      @@SharonSmith , Wow - thanks for responding so quickly! I will try this immediately ☺️

    • @mifabiansen1883
      @mifabiansen1883 Рік тому

      Unfortunately, it did not solve the problem. You are more than welcome to let me know, if you have more ideas ☺️

  • @neetusingh3595
    @neetusingh3595 5 місяців тому +1

    Hi Sharon, Could please create a video related to link creations

    • @SharonSmith
      @SharonSmith  5 місяців тому

      Great idea! Thanks for watching my videos!

  • @ordaudee
    @ordaudee 10 місяців тому

    Thanks for this video. The Word version I use is Office 365 and dropdowns don't have a "Bookmark" field setting. How do I do it with Word 365?

  • @tfv7809
    @tfv7809 3 роки тому +1

    Thank you for this easy-to-follow tutorial. Is there a way to edit the text that is auto-populated after making the selection in the drop-down? I have a list of tests that auto-populates a short description and a table to enter scores with test-specific columns/rows but, when I restrict editing, the user is not able to enter the scores into the table.

    • @SharonSmith
      @SharonSmith  3 роки тому

      Hello! Here is a video that may help you. This shows how you can restrict only parts of your document (so you can leave some sections open for editing): ua-cam.com/video/Xsh6Tk6xJB8/v-deo.html I hope this helps you out. Thanks for watching my videos!

  • @pjamesnorris6225
    @pjamesnorris6225 3 роки тому +1

    Thank you for the video--it was VERY informative. But you're doing something much more complicated than what I need to achieve. I simply need for a text field to echo the option chosen by the user. So the user chooses an option "A" from a drop-down menu, and somewhere else in the document, "A" appears in a sentence.
    I tried { REF bookmark_name }, but that didn't work. When I alt-F9, the form field disappears utterly.
    Thank you,
    P James Norris

    • @bilsan21
      @bilsan21 2 роки тому

      Sir, have you found the solution for you query.
      If yes, please share the details.

  • @KiranKumar-gb8ux
    @KiranKumar-gb8ux Рік тому

    Thankyou Sharon for posting such an useful video. But i am stuck at one place and need your help. After putting those programming and restricting the document i am able to edit as I have breaks but once i edit or fill related words in document and give print those additionally filed words don't appear..Can i have a solution for this

  • @MTB_Nephi
    @MTB_Nephi Рік тому +1

    Super video, thank you very much. Does this also work in WORD 365?
    I can't get it to work there!

    • @SharonSmith
      @SharonSmith  Рік тому +1

      Hi, yes, this works in Word 365, the desktop app version. If you are using the web version, it may not have the full functionality. I hope this helps! Thanks for watching!

    • @MTB_Nephi
      @MTB_Nephi Рік тому

      @@SharonSmith Thank you. I get an error message.

  • @jessicapoonsombat7205
    @jessicapoonsombat7205 10 місяців тому

    Helpful video. I’m struggling with adding a text box in the coding section. I need to have it so that if the user chooses “yes or no” from the drop down list, a blank text box shows up so that they can fill in *why* they selected that option. Is that possible?

  • @megathaziq2019
    @megathaziq2019 3 роки тому

    Thank you very much for teaching Sharon. Greatly appreciated it.
    I just one question, can we do this in header and footer because I want to link image when select drop down list in header.

  • @joshuabees
    @joshuabees 2 роки тому

    Sharon thank you so much for this! One question - Is there a way to be able to ctrl-C the output text created using this method? I'm using it to automatically build a document from just a few selections but the users need to be able to copy & paste out the results.
    Thank you again for your tutorials, I never knew Word could do so much!

  • @5ouvenir
    @5ouvenir 3 роки тому +1

    Thanks for your great videos! I managed to link some text to a drop-down list but unfortunately the text doesn't appear automatically, I have to "refresh" the page in order to get the updated text. Is that normal? Thanks

    • @SharonSmith
      @SharonSmith  3 роки тому

      Hello - if you have set up the properties of the form field to "calculate on exit" then I recommend having another form field and instruct users to hit tab after making their selection. That will take them to another form field and it should update after they hit tab or click to the next form field. Hope this helps! Thanks for watching!

  • @donaldzentmeyer2037
    @donaldzentmeyer2037 2 роки тому

    Fantastic Videos!! Is it possible to place the inserted picture behind or in front of the existing text? When I try this the picture moves out of the equation.

  • @kimviera85
    @kimviera85 Рік тому

    Great Sharon! Can you tell me how to edit my conditional verbiage after i have protected and unprotected if I need to add/change a formula I speant so much time creating? THANK YOU!

  • @KrzysztofKwiatkowski-d1k
    @KrzysztofKwiatkowski-d1k Місяць тому

    Thank you, this was very helpful. How do I prompt a checkbox check to show text somewhere else, similar to the dropdown? Normally, the reference would = the dropdown value, but for the checkbox would the reference = "Checked"?

    • @KrzysztofKwiatkowski-d1k
      @KrzysztofKwiatkowski-d1k Місяць тому

      Also, am I able to include Text Boxes inside of the dropdown referenced text?

  • @schapman5308
    @schapman5308 2 роки тому +1

    Is it possible to use multiple "if" conditions (for example 4) to show more options in the form.

    • @SharonSmith
      @SharonSmith  Рік тому

      Yes, you can use multiple IF conditions. I'm working on a course that will show how to do this. Thanks for watching!

  • @annazuo225
    @annazuo225 3 роки тому +1

    Hi Sharon, is there a word limit to the linked text? Is there also a way to edit the texts in the linked field after I've restricted the formatting? Thank you so much for this tutorial! :)

    • @SharonSmith
      @SharonSmith  3 роки тому

      Hi Anna! There may be a limitation to how many characters in your IF statement, but I recommend to test and see if it works for your needs. You would need to Stop Protection on your form and hit Alt+(Fn)+F9 to see your ref fields and edit them. Then you can re-protect your document. Hope this helps! Thanks for watching!

  • @danield.8615
    @danield.8615 5 місяців тому

    Is it possible to do this great tutorial with the new dropdown fields? I don't know how long MS will keep the legacy ones - just in case the function get's lost in a future update.

  • @jewelzkiwi9855
    @jewelzkiwi9855 16 днів тому +1

    My drop down lists shows ‘choose an item’ when using IF REF code. It does not show when converting to PDF. Do you know of a workaround?

  • @christinacerqueira4068
    @christinacerqueira4068 3 роки тому

    Thanks so much for this Sharon! I was hoping you may be able to help me with something please. I have two dependant dropdowns where I'd like the answer from both to result in text. How can I do this?

  • @abdelouahabelboukhari1078
    @abdelouahabelboukhari1078 4 роки тому +1

    Hi Sharon. Thank you for your videos! is it possible to force the user to check only one Check Box among multiple ones? Like for example, if the user must rate something based on a Likert scale from 1 to 5.

  • @reneino310
    @reneino310 2 роки тому +1

    this is so super helpful. Can this be done on a pdf document?

    • @SharonSmith
      @SharonSmith  2 роки тому

      Hi Rene! Glad you found it helpful! I would have to research if you can do this with Adobe Acrobat DC for a PDF fillable form. Thanks for watching!

  • @tansarayut3533
    @tansarayut3533 3 роки тому +1

    I love this tutorial

    • @SharonSmith
      @SharonSmith  3 роки тому

      Thanks so much for watching! Glad you found it helpful!

  • @jasutenliubo
    @jasutenliubo 3 роки тому

    Thanks for the video!
    My instructions aren't auto-populating after I press tab. I already have "calculate on exit" checked. Do you know how to solve this issue where the information can be auto-populated after selecting the drop down list options?
    Thanks again!

  • @yours.trustworthy
    @yours.trustworthy 4 роки тому +1

    Omg this is extremely good
    Thanks

    • @SharonSmith
      @SharonSmith  4 роки тому

      Thank you so much!! Thanks for watching my videos. Glad you find them helpful. Take care!

  • @peteradamka3137
    @peteradamka3137 3 роки тому +1

    Hi Sharon! Thank you so much for this incredible video. I have tried out it in some docs but the linked text did not change automatically. I always had to update fields when I put fields codes manually ( opening tab by right click on mouse and then I used "Update field"). Is there any hint to set out automatically? I mean that upon changing the value in drop-down lists, the linked text will be appeared automatically.

    • @SharonSmith
      @SharonSmith  3 роки тому

      Hi Peter! Do you have the "Calculate on Exit" checkbox in the drop-down form field properties checked? If so, as long as you have another form field for users to tab into, it should auto populate. You also have your form field protected for "filling in forms"? I hope this helps! Thanks for watching my videos!

  • @googleuser3737
    @googleuser3737 Рік тому

    Just discovered this mindblowing content because I had an idea of a Word doc that has drop down menu that is linked with option from the menu. ChatGPT says it is not possible or is to comlicated but can someone tell me: Can drop down menu be linked wit the whole table? And can a table have copy content button from specific table cell in Word? There is so many questions...

  • @gbrufau
    @gbrufau 2 роки тому

    Hi Sharon,
    Thanks for your video. When I insert a picture I only see part of it. Only when I make it very small I see the full picture. Do you know how I can insert a larger picture?

  • @lindseyforeman9993
    @lindseyforeman9993 2 роки тому

    Excellent video. Question though...how can I include a new or second drop down list WITHIN the text that is linked to the first drop down list? For example, my first drop down is a yes or no answer to Question A, and if yes, I have Question B that shows up and I want a new or second drop down list to show up with the linked text so the user can use it to answer Question B .

  • @Cassandrawills7076
    @Cassandrawills7076 2 роки тому +1

    What would you charge to create a fillable job application, or could you refer someone. It should be useable for desktop laptop, and app and iPad for online use.

    • @tiawalker3637
      @tiawalker3637 Рік тому +1

      Hi Cassandra, you just need Adobe to do this. :)

  • @chris-zu6sf
    @chris-zu6sf 3 роки тому

    Great video! How to make 'Employee Status' invisible, once you select the option? There will also be an 'Undo" button to re-select your options.