Here’s a simple yet powerful base I built to manage a community books library.
You can use it to manage the borrowing of any physical items - books, wheelchairs, tools, etc.
It includes:
Automatic reminder emails a week before the designated return d...
If you’re using a rollup field to summarize linked records with ARRAYJOIN(), the array’s order is determined by the order of the linked records.
I created this script to automatically sort linked records in a cell.
My use-case is to summarize interac...
Have a look at the base here.
We are a growing movement of volunteers who have been mobilized due to the current crisis to help the most vulnerable among us - the elderly, the refugees, the domestic abuse survivors, sex workers, single mothers, and o...
@luke247 My pleasure!The field to sort by doesn't have to be the linked record's key, it can be another field.Have a look at this snippet from the code:if (linkedRecordsArray) {
// Add the date field to each linked record object
for (var linkedRe...
Here’s an updated script.
It shows some errors in the editor but it looks like it works.
// Set a trigger: when a record is updated -> watch the linked records field
// Set an action: run a script
// You should set the record ID of the triggering rec...
Hi Luis!
Try this modification of the script.
It assumes your linked records’ key is a date, as it seems from your screenshots.
In the script, you should replace “tableName” and “linkedRecordsField” with values according to your base.
Good luck!
// S...
