I am looking to enter a custom text into a column when a form is submitted. This is hidden from the user. I tried “Set columns” and adding a custom text in Custom but that didn’t work.
Any tips?
Two options. Either create a template column with the text in the sheet where the form button is located, or create a template column with the text in the user profile sheet. Then just add a Screen Column component or a User Profile Column component to the form with that template.
1 Like
Thank you. Could you rephrase though? I didn’t get that…
Do you mean create a NEW column which is a template column in the same sheet where the form will enter info? Or have that column I need to change be the template column?
You would create a new template column with your text in the user profile or the sheet of the details screen where the form button is located. You wouldn’t place it in the form destination sheet…well, you could if the text will never change…then you could just put a template column in the form destination sheet. But if the user could change the text later, then adding the template column in the user profile or source sheet will allow you to add the Screen Column or User Profile Column components to the form, which will pass that value through the form to the destination sheet without the user seeing it.
1 Like