If a checkbox is clicked on a form, can a field populate from previous data?
Hello,
I have a form where the user would enter a Contact 1 name and Contact 1 email. Then a bit later there are fields for Person A name and Person A email. Often Contact 1 and Person A would be the same information (but not always).
Currently in an Acrobat form, there's an option for "Person A (check box if same as Contact 1)" then Person A's name and email autofill. Is there a way to do the same thing on the Smartsheet form? Logic seems to only work for hiding and showing fields.
Answers
-
Hi @AKunce
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Here's a possible workaround or workarounds
- We could add it after submission in the sheet instead
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @AKunce
I think you might need to setup an additional column to make this work although someone else may have a better idea.
Option 1: presume that if the checkbox is checked and Person A is blank, then use Contact 1. I don't know how you are ultimately using your data so you may need to go to option two.
Option 2: use add a helper column to combine the data. In your helper column you would have a formula that would look at the checkbox and if it is checked, get Contact 1 name, otherwise get Person A name.
Hope this helps!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives