Melagence - profile

Melagence · Aug 18, 2023

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...

Melagence · May 27, 2023

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...

Melagence · Apr 07, 2023

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...

Melagence · Feb 07, 2024

+1 this is indeed ridiculous!

Melagence · May 27, 2023

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)...

Melagence · May 27, 2023

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!

Melagence · Apr 13, 2023

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...

Melagence · Apr 08, 2023

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. 

User Statistics

User Activity

Need scripting help to extract a text piece

get # of unique values within automations

Automation (does this need a script?)

Re: Make interfaces available on the iPad

Re: get # of unique values within automations

Re: get # of unique values within automations

Re: Name of the month by date [Formula]

Re: Automation (does this need a script?)