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.
Hi
I have a lookup field that is displaying values from a multiple select field, which I have converted into a comma-separated format.
Let’s say the values in that field (field A) are:
Cat, Dog, Antelope, Lion
I have another field (field B) that has ...
I feel like I’m close with this one, but it’s not quite working.
I want to show quarters of the year, so if a column equals “January 2021”,“February 2021”, “March 2021”, I want it to show “January - April 2021”, and so on for each quarter. I’ve attem...
I am using Airtable to send data through to another platform (Formstack Docs aka Webmerge). My base has a main record with a number of linked records per main record.
The use case is that each item from the linked records will be a new row on a docum...
I need to create a customer number that includes the year, and an accruing customer number.
E.g. 2020-0001, 2020-0002, etc.
The thing is, every year, the year has to change in the customer number, and the four numbers after it have to reset.
So if t...
I’ve tinkered with a few ways of doing this, but wanted to get some ideas about the most efficient way.
I have this full address string:
Street address: 1600 Pennsylvania Ave NW # 15 City: Washington State: DC ZIP Code: 20500-0003
I want to extract t...
@kuovonne I did the formula like this to create the JSON. It works, but I’m wondering if I went a long way about it…let me know if you would have done it differently?
CONCATENATE("{","\"","Full_Name","\""," ",":"," ","\"",Mem_Full_Name,"\"",",","\"",...
Thanks Jason, that’s awesome.
To expand on that, if I want to pull out the city portion (which has a variable number of characters vs the state which is always 2), what would be the method for that? Can I define boundaries around a string (like find ...