Happy Monday, dear Gliders!
We’re excited to tell you about three features we just shipped:
Lookup for multi-relations
Until now the Lookup computed column would produce the value of a column in a single relation. You can now use lookup to produce all the values of a column in a multi relation. As an example of how this might be useful, say you wanted to show a photo carousel of all the employees working in an office. You can now lookup the
Photo column in the
Employees multi relation, and bind the resulting column to an Image component. Another use case is to get emails to filter by.
So far, Glide would refresh your app data from the spreadsheet whenever the spreadsheet was manually edited. If you used formulas that produced different values at different times without requiring manual edits, such as
GOOGLEFINANCE, your app data would not stay up-to-date. With Background Refresh, you can tell Glide to periodically refresh your data from the spreadsheet, no matter whether there was a manual edit or not, so those formulas will now stay up-to-date, too. This is Pro feature.
Note that due to the way Google Sheets works, if you use an
IMPORTRANGE, and the spreadsheet that is imported used something like
GOOGLEFINANCE, that imported data can still be out of date.
G Suite Shared Drives
You can now create an app from a spreadsheet that’s in a G Suite Shared Drive. This is a Pro feature, so to publish the app you’ll have to upgrade.