Dynamic Form Entry...

PB_PerfectPatterns

Hi there -

I'm curious if there's a way to have the data entered via a form added to a specified sheet that's selected from a field... All the sheets would be created from a template.

Example)

--Select Job#--

^(Drop-down menu that dynamically updates with all Sheet names contained inside a folder)

--Select Part#--

^(Drop-down menu that dynamically updates with selected Sheet's left-most column's contents)

--Modify Fields--

^(All fields w/ existing data are locked, blank fields are editable)

Andrée Starå

Hi @PB_PerfectPatterns

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could use the premium add-on, Data Uploader to update the lists, but it wouldn't automate the Sheet Selection part.

Is that an option?

More info: 

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

There might be another possible workaround.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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

Andrée Starå

Hi @PB_PerfectPatterns

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could use the premium add-on, Data Uploader to update the lists, but it wouldn't automate the Sheet Selection part.

Is that an option?

More info: 

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

There might be another possible workaround.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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