Formula to copy values from column to column

I don’t think you need a script for this.
You should be able to do it with Glide, using an ‘Add Row’ action.

Is there a way to trigger the Add Row action (or any action for that matter) when user hits the Submit button on the top right? Or can actions only be triggered with a separate button. I am trying to create the first row (already works with Submit) and the second row (using the Add Row action) with the same click. Thank you.

I’m not 100% sure, but I don’t think so.
To be honest, since the release of compound actions, I no longer bother with the default form.
I just create my own forms, and use a Submit button with a compound action attached - it provides much more flexibility, and will definitely deal with this use case.

It is possible yes. Inside your form, navigate to the “features” section.

From there you could set a custom action to include add row. :+1:

Note: What @Darren_Murphy says is true and designing our own forms (from a details screen) provides a lot more flexibility. One thing to consider is the UX in desktop mode. In desktop mode, the native form pops up in a new floating window but a form designed in a details screen would not.

1 Like

Success. Add Row action added to the form submit. Thank you.

2 Likes