momentsgoneby80 - profile

momentsgoneby80 · May 23, 2023

I have a long text field where I copy source material. I have seen mentiononed ways to extract URLs with REGEX when they are written out in a text field, but occationaly links are copied in hyperlink form. Is there a way to extract the URL from the h...

momentsgoneby80 · Feb 24, 2023

I have an automation that finds matching records for me and I, in the next step, need to update these records by checking a checkbox (true). As there are two or more records found each time I presume that I need to run a script to achieve this. I'm a...

momentsgoneby80 · Jul 21, 2022

Hi! I’ ve encountered a possible Airtable quirk and was wondering if anyone has a hint how to work around it. I have a Long Text Field with RTF enabled. In this field I have RTF formated text / Markdown text. In a formula field I’m trying to search t...

momentsgoneby80 · Jul 21, 2022

Hi! I have a base with quite a bit of Korean names in it. As the names often have a few different ways of romanization I have a field for alternative romanized spellings; {Alternative Spelling(-s)}. What complicates it further is that each romaizatio...

momentsgoneby80 · Mar 22, 2021

Hi! I have a base for fanfic that imports data and chapters via Airtables Webclipper. Some fanfics have 100+ chapters, so my base is set up to accomodate up to 125 chapters, one per field. After a fanfic is imported I want to tagg it for the characte...

momentsgoneby80 · May 23, 2023

@kuovonne Thank you so much for taking the time to answer .Well, though dissapointing that makes me feel a lot better about myself. I knew that the field type formats with Markdown, so the first thing I did was to just call up the field in a formula...

momentsgoneby80 · Feb 24, 2023

Thank you @TheTimeSavingCo!The things you miss when you're away for a little bit. Great to see that feature added and thank you so much for pointing it out to me. Works perfectly.

momentsgoneby80 · Jul 21, 2022

Hi @Adam_TheTimeSavingCo! Nope, not the Korean messing it up. I copied your base and added the Korean and it works just fine. But in my base it just doesn’t. If I copy straight from my base to yours, yours doesn’t work for that new record either. The...

momentsgoneby80 · Jun 12, 2022

Hi and welcome @TF_UNOC! You’re on the right track. The issue is that DATETIME_DIFF() formula returns whole integers for any unit specifier, so simply trying to use a round up or similar won’t work. What we can do is use the time difference in a calc...

momentsgoneby80 · Jun 11, 2022

Hi and welcome @Joan_Born! This should work for you IF( {Date field}, DATEADD(DATEADD({Date field},-2,'weeks'),4-WEEKDAY({Date field}),'days') )

User Statistics

User Activity

Is it possible to extract URL from a hyperlink in a long text field?

Script help to set checkbox to true for Automation » Find Records » Run Scipt

How do you FIND() or REGEX_MATCH() in a RTF Long text field?

Formula for alternative spellings and formating of names

Is it possible to condense this huge and clunky formula in any way?

Re: Is it possible to extract URL from a hyperlink in a long text field?

Re: Script help to set checkbox to true for Automation » Find Records » Run Scipt

Re: How do you FIND() or REGEX_MATCH() in a RTF Long text field?

Re: Calculation difference between dates ignoring the time of day

Re: Assign a due date of Thursday for all items due in a certain week