Shaun_Hughston - profile

Shaun_Hughston · Nov 22, 2021

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

Shaun_Hughston · May 29, 2021

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

Shaun_Hughston · Apr 22, 2021

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

Shaun_Hughston · May 10, 2020

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

Shaun_Hughston · Feb 26, 2020

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

Shaun_Hughston · May 30, 2021

That’s awesome thanks :grinning:

Shaun_Hughston · May 02, 2021

@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,"\"",",","\"",...

Shaun_Hughston · May 11, 2020

I hadn’t thought of that approach…thanks! :grinning:

Shaun_Hughston · Feb 27, 2020

Jason: LEFT( MID( {Address}, FIND( “City:”, {Address} ) + 6, 50 ), FIND( “State:”, MID( {Address}, FIND( “City:”, {Address} ) + 6, 50 ) ) -1 ) That’s absolutely awesome, thanks Jason!

Shaun_Hughston · Feb 27, 2020

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

User Statistics

User Activity

Find any part of a string/array within a string/array

IF with multiple conditions

Produce JSON for linked records

Rolling Customer Number Based On Year

Extract Value From String

Re: IF with multiple conditions

Re: Produce JSON for linked records

Re: Rolling Customer Number Based On Year

Re: Extract Value From String

Re: Extract Value From String