Help

Update subsequent fields based on initial field selection

Topic Labels: Scripting extentions
Solved
Jump to Solution
899 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ky_Van_der_Hoef
4 - Data Explorer
4 - Data Explorer

I have a table that tracks the steps and results in a process. Sometimes we modulate the steps, but often the steps remain the same over multiple submissions/rows.

For example, we have molds that need to be cleaned using a variety of different tools, solvents, and methods. I have a column titled Mold Cleaning with options “Standard” and “R&D”. I would like to be able to have subsequent columns autofill based on the selection in this column. If “Standard” is selected, then I would like the tools/solvents/methods to input our standard selections for that. If “R&D” is selected then I would like for the tools/solvents/methods to remain blank for input.
image

Can this be done through scripting or some other means?

1 Solution

Accepted Solutions
JonathanBowen
13 - Mars
13 - Mars

Hi @Ky_Van_der_Hoeff - you can do this with a script, but you can also do it with a non-script automation. Something like this (simplified):

Screenshot 2020-11-05 at 17.32.44

Screenshot 2020-11-05 at 17.32.55

See Solution in Thread

2 Replies 2
JonathanBowen
13 - Mars
13 - Mars

Hi @Ky_Van_der_Hoeff - you can do this with a script, but you can also do it with a non-script automation. Something like this (simplified):

Screenshot 2020-11-05 at 17.32.44

Screenshot 2020-11-05 at 17.32.55

Ah! The beauty of simplicity. Thank you. And now I have a somewhat better grasp on using Automations!