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