It’s odd that some of the columns are shown as name (name/email) and others by an id (JfvSi etc). Is there a way to force the names to show? The order doesn’t match dataview either so I am resorting to guessing - not easy with things like date columns.
Also, If I wanted to pull a subset of rows (example where user_status = activated) I can’t see a way to select just those. I am currently getting all rows then using FlowControl to decide which to act on. Doesn’t seem too efficient. Is anyone doing this in a smarter way?
You can check those IDs in your data view. Right click on the table > Show API > Add rows/Edit rows.
The API does allow you to do that with Big Tables using queries, the module doesn’t seem to allow you to do that as of now, and I don’t know if it’s feasible for normal Glide Tables.
That showAPI is really handy, thanks! Unfortunately it highlights that the issue I really have is that I can’t use the computed fields (as you mentioned in the other thread). That is very annoying.
I really don’t want to repeat the logic in Make as I can see those getting out of sync.
I was trying to use the computed columns to filter out the rows I don’t need. Maybe I am going about it backwards.Am I missing a way to add a “where” to the get Rows?
The following is the approach that I have taken, which works for me:
My App is 100% Glide Native tables
I created a Google Sheet that is not directly connected to the App.
The sole purpose of the Google Sheet is for managing email reminders
The way it works is:
– On a daily basis, I fetch the table data that I need via the API using Apps Script
– I then process the data, figure out which users need reminders, and trigger a notification email via a webhook to Make
It’s a little convoluted, but it gets the job done.