Write to sheet based on form selected

Ask for Help
1

Hello All! I would like to have three from buttons on one screen and have a value written to my sheet based on the form selected. So If I have Forms X, Y and Z, if the user selects form Y then Y is written to a cell in my sheet on the same row that the data in the form will be submitted. Is there a way to do this?

Thanks!

2

Create 3 single value columns in your data editor having values X, Y and Z.
Then in each form button, push this single value column data in your required cell using the “columns” component in forms.

2 Likes