DataEditor: "column =" synchronized with GSheet

[AyS_0908]

Hi, to avoid lag, it is recommended to build a maximum functions within the DataEditor.
Sometimes nonetheless, the resulting data of these functions are necessary in GSheet to perform functions which do not exist within DataEditor.
In case there is no workaround, it migth be interesting to have a “basic”-like column (ie. synching with GSheet) which would be a simple “=” of the resulting data of a DataEditor built-in function.

When adding column to Data Editor it doesn't add that column to the underlying spreadsheet?

You are correct. Columns added through the Data Editor are “virtual” columns. The Data Editor does not actually modify the sheet in any way. I see their purpose as an easier way to add special column values without having to create complicated formulas in the sheet. All the new column options use the existing data in one way or another. It also allows for values in those columns to be updated instantly in the app. Otherwise there can be a lag when data is updated in the app, transferred to…

[S_C]

Thanks for sharing this post.