Skip to main content
Aug 10, 2021 2:43 PM UTC

Question: Do you have an example of a Table View Business Rule which allows a user to edit the table and save the changes back to the database?

Answer

The example in the Table Views documentation does work.  However, any references to tables and columns will need to be updated to suit your own needs.

 

Source:  Office Hours 2021-04-29 - Partner Enablement  

1 reply

OneStream Employee
Jun 3, 2022 10:16 AM UTC

The code on the Table View documentation will allow for updating existing rows/data.

You can now find (and download) an example of a sample rule that supports all three actions (Update existing data; Delete rows; Insert new rows/data) on the Partner forum - Table Views - May 2022.

This rule works on the assumption that the table has a primary key column but can be updated to suit different cases.
In case you have any questions on this topic (including the sample rule), do please make sure to watch the recording.