Is there a way to add an action when filling ...

(Alexander Bentley) #1

Is there a way to add an action when filling in a form that when selected it shows the next column and allows the user to complete the next column? Maybe a “+” logo or something to indicate adding an additional comment.

For example, I need a form that a user can edit and add comments to at different times of the day. Selecting the “+” would add an extra column and they can add the new comment for that time of the day.

(Aleksi Alkio) #2

One way is an additional related table… like a parent & child tables. With that structure you can add as many comments as you need but they all belong to your parent record. Check this article… - References Between Tables References Between Tables

(Alexander Bentley) #3

One other was is to make each column only show when the other column has been completed… Is there a way of completing the Time column automatically based on when the previous column was filled in? TIMENOW() inputs the time field as soon as you open the form but is there a way to automatically fill in the time based on when a previous column is completed?

(Aleksi Alkio) #4

You could use ChangeTimestamp field for that purpose.