I’ve been trying to figure out how to make this crazy formula happen, but I’ve hit a wall. Can it even be done? Check out below and let me know how you’d accomplish such a thing…
In the base, users select from a list of deliverables via a linked reco...
Hi, everyone -
I could seriously use some assistance with a script I’m trying to figure out. Please note, I always thought of myself as efficient with computes and I like to think I’m pretty good with Airtable formulas, but the scripting stuff is so ...
Hi, everyone!
I need to devise a formula that can extract the date from large numbers of text strings that look (more or less) like this:
Purchase authorized on 02/08 Starbucks Card Rel 800-782-7282 WA S466038798107217 Card XXX
Purchase with Cash Ba...
Gotcha. Well, in that case you could just do a Formula field. Something like this:
SWITCH(
{Producer},
"Carlos Gonzalez", "@SLACKID1",
"Ashley Posluns","@SLACKID2",
"none"
)
So the {Producer} field is the field that you use to assign peo...
Hi, Ashley -
Do you have a Table that contains all of the people that the project can possibly be assigned to? If you do, you can create a field for the individual’s slack ID.
Then in the table where you assign things to people, you can create a fie...
So awesome! I’m so thankful for your help. Thank you, Justin. This code works well. I did run into some trouble with the umlaut u - ü - and period after the numbered date for German, but I did some googling an came up with the following for language...
I’m trying to build a formula that extracts the text between [en-multi] in the following string:
[en-multi]THIS SPRING
12 JANUARY[en-multi][de-DE]DIESES FRÜHJAHR
AB 12. JANUAR[de-DE]ESTA PRIMAVERA
12 DE ENEROESTA PRIMAVERA
12 DE ENEROCE PRINTEMPS
LE...
Hi, Justin -
I tried the line of code you suggested and no-dice :confused: I’m getting the same exact error on line 15.
I’ve spent the last 30 minutes try to create a paired down version of the Base that I feel comfortable sharing, there’s just way...
