Hello,
I have bunch of computed fields in Glide. I’d like to get them back in Google sheet, mainly because I’m running reports on Google sheet side (Export to others Tools, daily summary email report, event email alert etc…) based either on event or schedule.
Currently I’m able to get some of them, by setting ‘Columns Value’ based on an user ‘Action’ in Glide, so I can get part of it. I have basically two fields ‘Glide’ doing calculation and ‘Gsheet’ where the value is copied and then available for reporting.
The issue I have is that most of computed field values change without a user manual action. In that case the ‘Glide’, in thta case the ‘Gsheet’ field is not synchronized with the ‘Glide’ one.
Is there a way to copy the value of computed field to ‘standard’ G sheet field, without manual action in the tool? Like running a script twice a day?
I have seen something with the API but not sure how it works.
Thank for the help.
Julien