Maybe I am missing a setting, but my calculated columns in one table, which are performing a select() function of the main data of the app, are not updated for my report. I have to go open each record of that reporting table for the calculated columns to save and then be ready for the report.
Hi @Kolbi_C What is triggering your report?
@Lynn It is a daily trigger that happens at 7:00 PM. The same delay seems to happen when I run the report manually using the builder.
Are you calculating something with the normal column (with app formula) where you could do that with a virtual column so you don’t need to open every record?
1 Like
If a virtual column can be displayed on the report, that would be fine. Does a virtual column update right away as compared to a normal column?
Yes, virtual columns are displayed on your report. In generally… all virtual columns are calculated when you sync the app. Virtual columns in your existing record (form view opened) and it’s parent record’s virtual columns are recalcluated before sync.