I have a few forms on my app sheet app that are repetitive like there is a column for the name but that same person will fill out many of these forms is there a way for the form to remember the last column entry so the user is not having to fill out their name or other repetitive actions I would greatly appreciate any help with this.
Quickest is to save the USEREMAIL() on the row of the form. So would need a new column called “User Email” or whatever you would like.
This initial value for this new column [User Email] will be USEREMAIL().
Now for the [Name] column we need to make the initial value LOOKUP(MAXROW(“Form Table”, “_ROWNUMBER”, [User Email] = USEREMAIL()), “Form Table”, “Key Column”, “Name”)
This can work for other column types as well if needed such as phone number, email, suffix, and etc.
1 Like