This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
My app formula in the parent table sums the order prices of the nested child table. When filling out the nested form, you can see that the computed sum in the parent form is accurate. But after sync, the value ends up being switched to zero ! I checked the Revision History of the particular cell in the spreadsheet (as suggested here) and I can see that the first value is correctly added but then immediately changed to zero. I have no formula in the spreadsheet. When I Preview the table data, it is also at zero, while the exact same formula in a virtual column gives the correct value...
If you add child records st the same time than patent yes it's a normal behavior that the Bot is triggered before child records are saved. To avoid this, you need to change the Bot to Updates_Only and add an event action that is triggered when the parent is saved.
So it looks like this is linked to my bot. I first generate a pdf and then I have a step to run a data action with "Set row values" for another column (file name).
I don't believe there is an issue with the expression: it is working fine in a virtual column that I created as a test. There is some weird behavior going on with my bot. It is triggered by a "Adds only" data change on the parent table, and I wonder if it doesn't mess up because it starts before the child table is updated??
And I forgot to mention that I found out that the bug doesn't happen when I disable the bot...
If you add child records st the same time than patent yes it's a normal behavior that the Bot is triggered before child records are saved. To avoid this, you need to change the Bot to Updates_Only and add an event action that is triggered when the parent is saved.
LinkedIn
Twitter
