Skip to main content
Solved

Update subsequent fields based on initial field selection


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.

Can this be done through scripting or some other means?

Best answer by JonathanBowen

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):

View original
Did this topic help you find an answer to your question?

2 replies

JonathanBowen
Forum|alt.badge.img+18
  • Inspiring
  • 1110 replies
  • Answer
  • November 5, 2020

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):


JonathanBowen wrote:

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):


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


Reply