I was looking into the Airtable API, and I looked into the section “list records”, I can see the sample code in Javascript, and some of the fields I have looked into, it only works on the ‘text’ or string field type.
eachPage(function page(records, f...
Is there a formula for checking a image file size? Using a IF statement, when a image size is over 5MB (I put 4MB for the sake for example), then the formula will return as a text “ERROR 5”. I tried something like IF(LEN(Image) > 5, "ERROR 5") to no ...
I am trying to find a formula to search records for the next 7 days (or 1 week). I tried the formula DATEADD(TONOW({Birthday}), 1, 'week') or even IS_BEFORE( DATEADD(TODAY(), 1, 'weeks'), {Birthday}) to no avail as my records came out from starting t...
I love the idea to finally have Airtable have it’s own automation system. What I would wish for is to have a webhook to send to IFTTT, Zapier, or Integromat. I know there is a developer section, but because you have to painstakingly search a particul...
Though there is already a button feature that I like. But what if…IF you want to use a button to ‘change the field value’. For instance, when I press a button, it puts a checkbox in the checkbox field. Unfortunately, there is no way to do that, excep...
Kris:
Is the ‘Birthday’ date field in the future, or the past?
In the future. For instance, what birthdays are coming in the next 7 days (or in 1 week when you think about it). Would either filters be the same thing? I tried the filter IS_AFTE...
Ok, but I’m looking at a search formula, especially for a automation API (like Zapier, IFTTT, Integromat etc) that does not use a <TriggerValue>. What I tried is using the formula DATEADD({Birthday},-7,'days', but unfortunately formula is not valid. ...
