Jun 10, 2021 02:07 AM
I can’t find the right one 。
btw，how to use the filter（like above image） by the [airtable.js ] [select api][ filterByFormula ].（I can’t find a suitable document）
Jun 10, 2021 07:31 AM
Try a formula like …
DATETIME_DIFF(TODAY(), CREATED_TIME(), 'days') <= 2
You may need to play around with the number of days, and you may have issues with timezones. If you want more granular control, you could use something like …
DATETIME_DIFF(NOW(), CREATED_TIME(), 'hours') <= 48
Jun 14, 2021 07:25 PM
thanks a lot!
Can you please tell me how to use it in airtable.js or is there a documentation for it, I tried to find it but couldn’t.
sorry for any inconvenince caused
Jun 14, 2021 09:00 PM
You can see the documentation here. You need to be logged into your Airtable account in the web browser, and the documentation will reflect your actual base.
Build the formula as a text string, and then pass the formula as the
filterByFormula parameter when you select records.