My goal: create an app that has a calculation engine behind, kind of Anaplan grid where you can copy paste multiple cells etc..
I need to build a simple table that allows users to edit rows easily, duplicate a row with a button at the end, or add a new row directly within the table. Additionally, I would like to include a feature that updates the last year's value using a CAGR formula with the click of a button.
Hi @Marco_nowine,
I believe all those features are buildable in Retool.
The only one that may be a little complex would be duplicating rows. Would the duplicate have its own unique ID but then all the rest of the columns be the same?
You can follow our docs on setting up a table that can be edited and saved as well as setting up some input fields for adding in new rows as well.
For the CAGR formula, as long as you can write out the math logic in a JavaScript code you can add that in to run on button click and to extract data from the table.
Hi @Marco_nowine,
Wanted to check in on how your project is going!