I want to incorporate multiple buttons that lead to a different “edit form” screen.
But I just can not make 2 different layouts for those edit forms screens. If I adjust the one, the other is also adjusted.
The reason why I need this is that there a formula that is calculated in google sheets. The result of that formula is used in match multiple relationship column to another tab in my google sheet.
Since there is no action available that “updates” the google sheet. This formula is not recalculated.
I need it to because the next step is to make a choice. That choice is filtered based on the relationship. (otherwise there would be way too many choices)
So I need to find a solution:
- different edit form screens
- update the information in google sheets not on form submission but real time.
Or maybe something else.
Who can help me out?