Is autofill possible in this scenario? and how

renogawj

I am working on a calendar form and I would like if I entered a specific name of an event, that the next column would autofill a number. For example, if in the "event Name" column I type "Marathon", I would like the next column to autofill with 18000 for the expected participants. Is there a way to do this?

Thanks

Paul Newcome

Would it always be 18000 for "Marathon"? Are there other values?

Andrée Starå

Hi @renogawj

I hope you're well and safe!

Yes, but how many options can you have? Does it have to be shown in the form?

I hope that helps!

Have a fantastic week & Happy Holidays!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

renogawj

https://community.smartsheet.com/discussion/comment/313682#Comment_313682

Yes, it would typically be the same number each time we hosted a marathon

renogawj

https://community.smartsheet.com/discussion/comment/313689#Comment_313689

I would like it to show in the form just to make entering events a little faster

Andrée Starå

@renogawj

You could use the Conditional Logic in forms.

More info:

https://help.smartsheet.com/articles/2481701-use-conditional-logic-to-streamline-form-submissions

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

renogawj

https://community.smartsheet.com/discussion/comment/313699#Comment_313699

I quickly scanned that article. Am I understanding that I would create a different form just for the attendance and using logic link them?

Andrée Starå

@renogawj

No, you'd configure the logic in the form setup sp if they select the Marathon option, a field would show with the 18000.

Make sense?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!