Dear Gliders.. is there a way to add a row to a table where some fields take the value just above (that is, from the previous row) without using single value (because I dont want to add more columns to the table)?
You can’t do this directly without having somewhere to pull those “previous row” values from.
If you don’t want to add any helper columns and this is only an occasional need, the simplest option is to open the Data Editor and manually copy the row into a new one.
If you want to automate it a bit more, you can:
- Create a “Duplicate” button that opens a form writing to the same table.
- Set the form fields’ default values to the values from the current row.
- Submit the form to create a new row with those prefilled values, and tweak anything you need before saving.
Alternatively, instead of a form, you can use an Add Row action that writes a new row to the same table using values from the current row as the inputs for each column.
Curious about your use case here - are you wanting to create a running total?