The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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...