Hi there,I would need some help. I have entries with a field "Description" this field contains a lot of text (coming from calendar entries). Part of the text is the name of a store. it's the words after "Name des Stores: ". I need to extract these wo...
Hi,I'm struggling a bit with a slack automation. the idea: we have a list where all new customer appointments go in. Every day at a certain time the automation pushes the total number of appointments into a slack message. Now we have customers that m...
Hi there,i have an automation question that I can't get around. Using Airtable as a CRM system, I have a table DEALS, a a table CLIENTS and a table BRANDS. I would like to build an automation that checks on a new DEAL if a CLIENT has placed a DEAL wi...
ok. I asked chatGPT to alter the script and it works perfectly now!const table = base.getTable("Table Name");
const view = table.getView("View Name");
const records = await view.selectRecordsAsync({ fields: ['Title'] }).then(result => result.records)...
thanks a lot! that's clearly the right direction. unfortunately I have no clue of scripts. I would need to get the number from the view SS24 in the table appointments. could you help me getting the view into the script?thanks again for your help!
I'm struggling with a similar issue. I have the below formula. everything works, except, air table will not interpret the outcome as a date and will not sort logically (by month) but by alphabet. DATETIME_FORMAT(IF(AND(
MONTH({Due Date}) < MONTH(TODA...
Great! both worked. I struggled a bit with the "find records" as it only works if i chose brand and client "id" instead of "name" in the conditions. But now it works as expected.
