I can only use column values when there is a record already selected. But when I want to use the form to create a new record because there is none yet (due to my filtering), Templates and Single Value type columns to pass on as column value won’t work since there is no record, no value to pass on.
Simple example: Take the Instagram template
Your Profile Tab
Sign up form
How would you create a new user with this form and set the ‘user_type’ (my newly introduced constant for this form) without user imput. This form has no way of receiving column values.
Let’s say I have 3 types of user accounts/roles, and whichever app I use (all 3 of my apps use same sheets) creates users same way as Instagram template but the the user type will be different. I can’t set the user type without user interaction.