I have a Virtual Column that I only need in the CSV export. It should not be calculated on sync. Only when I download the data via action "app: export this view to a csv file".
Is this possible? I tried different IF() and IFS() with CONTEXT() but with no luck.
Solved! Go to Solution.
Hi @Fabian_Weller ,
Thank you for more details. I am sure other colleagues will add more. Please explore if below testing and observations help.
1) I created a User Settings column called ExportCSV of Y/N type.
2) I had 2 multirow expressions VCs with SELECT() expressions in a table with 5000 rows ( table called "SWCPlayers5K")
3) For those VCs, I modified the expression as
IFS(USERSETTINGS(ExportCSV), SELECT(..............),
NOT( USERSETTINGS(ExportCSV)), LIST()
)
Which essentially means the VCs are calculated with expensive SELECT() statements only when user settings column is set to Yes or else they just calculate an empty list.
4) I also implemented this user settings column in Export CSV action condition as below
USERSETTINGS(ExportCSV)
which means the action will show only when the ExportCSV usersetting is set to Yes.
5) My results showed that when the usersettings column is set to Yes, which shows the Export CSV action in the view, the VCs also calculate and add significantly to sync time as shown in the screenshot below
6) When the usersettings ExportCSV column was set to No and when the app was synced, the performance profile did not show VCs time for that table, hinting the VC time was negligible as practically it was empty list , LIST()
So you could try to enable VCs to calculate during the Export CSV action only. Please test well. I too will test more for more conclusive results.
User | Count |
---|---|
34 | |
11 | |
3 | |
3 | |
2 |