I have an issue I thought was simple, but is anything but, that I was wondering if the community is able to assist me with.
I’m integrating an airtable with Deputy to display information specifically relevant to me. So Deputy generates ‘notes’ which I can bring into an airtable, but I would like to grab specific information from the notes and use this specific information to populate different fields of my airtable.
For example :
I am importing this from Deputy -
Title: RXXXXXX Webcast 27 March;
Live: 16:00 - 18:00;
Client: RXXXXX Conferencing;
User: ChXXX GoXXz;
Transcript: yes, 120 mins;
So, I am trying to search for the particular strings, such as ‘Title’, ‘ID’, ‘User’, etc etc and then use the information that comes after these tags and before the ‘;’ to populate different fields of an airtable.
I’ve had varying success using different methods, but only been able to return the first tag, being ‘Title’.
My process has been to import the information from Deputy into the primary field, then attempt to use that information to populate the different fields I need.
From my understanding, I feel like I should be able to search for the particular string, then pull everything from that until the next semicolon, but I am unable to make it work.
Any help would be hugely appreciated.