Hi everyone - excited to announce that I’m running a 1-day Airtable Scripting Bootcamp on Wed 16th June.
Info and booking here: http://bit.ly/airtable-bootcamp
This is going to be a live bootcamp, hosted on Zoom and it is targeted at any Airtable use...
For the Airtable scripters out there, here’s a few recent posts that you might be interested in :slightly_smiling_face:
Scripts and AutomationsImport a CSV fileA nice way to find duplicate values/unique values
Hi everyone - announcing the upcoming launch of my new project - Airguides
Airguides offers step-by-step guides to building Airtable bases for common use cases - a CRM/sales pipeline base or a holiday/vacation “request and approval” base for your bus...
For Airtablers interested in the scripting block, I’ve added a few new example walk-throughs to my blog:
Setting attachments from URLs
Converting scores to ratings
Using reduce to sum data
Creating records in batches
I’m using the CollaboratorToken component:
Airtable
Airtable | Everyone's app platform
Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outc...
@jsargent- the way to do this is to have another table where you can count or rollup values from the invites table, e.g an events table (see screenshot attached)
@Scott_Gardner1 - If I’ve got the logic of your formula correct, I think you can do a little simplification:
IF(
{DC Arrival Date},
IF(
OR({Production Type} = 'Puzzles', {Production Type} = 'Domestic'),
DATEADD({DC Arrival Date}, -56, 'd...
@Team1 - you are on the right lines. I’m guessing each record has an expiration date, so what I would do is create a view that contains the records that have expired (filter: expired date < TODAY, for e.g.). Then your automation can be:
“when record ...
Hi @Luiz_Gustavo_de_Alme - this post contains a solution to a similar problem:
Create multiple records based on a quantity field with a Script Scripting extension
I would like to create a script that creates a number of re...
Hi @Wendy_Yelsik - do you mean the 1st of the next month? If so, you can do this:
DATETIME_FORMAT(DATEADD(Date, 1, 'month'), 'MM/01/YYYY')
(You don’t need the middle field, I just displayed this to show how it was derived)
