"Out of line" edits of an RG (for lack of a better term)

[wardey0513]

Hi all - is there any good way to be able to edit the contents including adding/removing lines without actually hitting the database?

In other words can I take RG1, copy it into RG2 (data source is a custom state) to make edits. Then when finished, take what was in RG2 and overwrite what was in RG1 to the DB?

The intention is to let a user edit multiple rows in an RG and then when done choose to either commit them to the DB or rollback. Currently it seems that I have no choice but to commit those changes immediately.

It seems that copying the contents of RG1 to RG2 is easy but any edits that were made to RG2 items don’t actually show up in the list of rows for the RG

[maheshkasindi]

Create another database table “Cache” to hold temporary data of edited RG rows. Create an API Workflow to create Cache things. On page load, Schedule API on a list with source as RG list of things. This will replicate the RG list of things in the Cache table. Use that Cache table as data source of RG2. Once committed, use values from this Cache data to update RG1 data.
Don’t forget to delete Cache data once commit is done.

[wardey0513]

Thanks thats kind of what I’m doing now but I’m trying to not use a DB as an intermediate step.