Hi I have an automation script, and run into a problem, it is not fetching the right recordId in the script, but it does in the previous step. Anybody with a larger brain that can se what I have done wrong here?All the BestJesper
Hey EveryoneI have a problem when collecting data thru API, in this example records of a foodmeny in Airtable. Every dish and the different infos (ID, Day & Date, Swedish, English, Allergens) is formated in a formula field in Airtable. One per dish. ...
Hey everyone, have a question about a formula I can't get working correctly.I only have a date field (Date) and a formula field, with the formula Date=TODAY()The formula returns a 1 for today and 0 if it's another date. So far so good.What I want is ...
Hey GuysI have a dynamic datefield (updates thru automations) that begins from todays date and records 10 days ahead. Is there a way to write a formulafield that ranks the date with numbers 1-10, i.e so todays date is 1 and tomorrow 2 and so on? I co...
Hey guysIm stuck with a problem with some formulas, I got some real good help from @Andrey_Kovalev in December but now I'm stuck, so please if someone could advise. Long story short, I have 10 records (Mon-Fri odd and even weeks)and I want the date t...
Thanks @Richard_Quintan I solved it like this, the problem was it didn't pic the right recordID, but now it works on 1 automation But I have now a problem when the variable is a "list of AirtableIDs" since its going to be a scheduled automation, but ...
Yeah I have tried that one with specifying which fields but it still returns the data in another order, I'm not using Javascript, its just a url api call.
Hi again @Andy_Lin1 , do you know if there is a way to get the data from the API in the same order as its shown in Airtable, the only thing I found is sorting by a field? For example If I have fields in the order in Airtable, Name, adress, Phone, but...
Do you now how to set up that filtering in the API query? Now we just send the filter by formula filterByFormula=Date=TODAY()How do I write the query that it should only read "0" or "1"?
