I was able to use this discussion to add a submission date and submission ID to row data using Special Values (thanks!!!) when form is submitted following this discussion BUT, I am still unclear in an additional “default” value to add to one column in the new row submitted. I need to set the Status column to a pre-defined value = 1. New Applicant.
I thought Set Column On Submit would work but as the discussion states this doesn’t work. How would I set that column value for the current row for new submissions? Or will I need to have the App Script that does some other things on the google sheet on new row adjusted to handle it?
You could create a Template column in your User Profile table that contains the value 1. New Applicant, and then pass that as a User Profile Value with your Form submission.
I wouldn’t say it doesn’t work, it’s more than it can’t be relied on to work consistently. The problem is that there is a bit of a race condition happening. That is, if the Set Column Values action fires before the new row is added, it will fail.
Works perfectly. Thanks Darren!!!
An alternative is to use a text entry component pointing to your status column, set the default to “1. New Applicant”, and then hide that text entry with a condition that will never be true (i.e “Status is empty”, since that would always be filled with the default value).
1 Like
I use this form to create products in the system. When created, the product has a default status of
Active. I am unable to set column value to This item On submit. It creates the row but does NOT set the value for the column Product status as directed in the action in the On submit event.
I am thoroughly confused. I am hoping there is a better solution in January 2024.
There is.
Don’t use an onSubmit action to try and Set Column Values in the row just added.
Instead, pass the extra values as “Column Values” with the form.
There are several ways to do this. For your use case, one option would be to have a Template column in your User Profile Row with the word “Active”, then pass that as a User Profile value with the form.
2 Likes
An alternative is having a text entry column pointing to the status column in the destination table.
Have a default value of “Active” for that entry, and then use a conditional visibility for that component that will never be true (say “Status” is empty, because it will always be not empty thanks to your default value).
1 Like
This is why we need the ability to add custom values as special values. Please upvote!
https://community.glideapps.com/t/pass-a-custom-value-when-completing-a-form
1 Like