I created a form to make it easier for my colleagues to share their new hiring needs, and I need to record when a form is submitted. I tried multiple ways:
Adding a date and time field to the form
Adding a date created column to the table
And much more, none of which are working. Any suggestions?
I am afraid I miss out on something obvious : when a table (form) is filled out, the user create a new row and thus the outcome of Modified(thisRow) changes as well. Then you have the creation data. What is it I do not see?
in short for those interested. the Modified(thisRow) works well when you are in Coda and you modify or create a row. However when you have a form embedded and the data comes in, the Modified(thisRow) remains blank, does not work. That surprises me.
In your Timestamp column you might try to use the Value for new rows option to Now() (and obviously hide it in the form view).
This should value the column as it is computed once the row is actually created.