Mitchell_Wells1 - profile

Mitchell_Wells1 · Mar 02, 2020

Hi guys. Trying to figure out the best way to overcome the limitations of the Page Designer and hoping a formula might be the answer. I’m collecting a lot of data in a table called “Rooms”. Each room record has linked products, materials, and concept...

Mitchell_Wells1 · Feb 16, 2019

Hello, I’m printing records in a grid to a non-standard page size. I’d like to be able to then open this PDF in Illustrator and edit the pages further as necessary. However, there’s a bunch of annoying things I’m running into. First and foremost, I c...

Mitchell_Wells1 · Feb 06, 2019

Hey, I have some data that I want to arrange in-line on my page designer like so: {Retailer}, {Manufacturer} Simple, right? I can type it into a static text object in the page designer as exactly the text above and it will get me what I want. HOWEV...

Mitchell_Wells1 · Jan 29, 2019

Hi, I’m a little frustrated with how Airtable has decided how Tables are meant to work. I have 2 types of data sets that need to be treated significantly differently from one another, so it makes perfect sense to me that they should have their own ta...

Mitchell_Wells1 · Jan 04, 2019

I’m wanting to convert one of my fields into characters that Windows doesn’t throw a fit over using. That means if someone types in “30” Refrigerator", I would like to convert that quotation mark after the 30 to “inch”, because Windows doesn’t allow ...

Mitchell_Wells1 · Mar 03, 2020

Yeah haha, it showed that you were typing up a reply - I tried to save you the trouble by @ing you in the other thread but I guess I was a little too late! Thanks though for taking the time to help me.

Mitchell_Wells1 · Mar 02, 2020

Thanks for this @kuovonne, just what I was looking for. I do wish there was a cleaner function to do this though!

Mitchell_Wells1 · Mar 02, 2020

Just noticing that this was recently answered over here: Separate a Look Up field (separated by commas) into separate cells

Mitchell_Wells1 · Feb 17, 2019

Hmmm, maybe I’m missing something, but that small difference actually makes it a much more complicated formula. The question becomes how to make a formula that only accepts whole numbers. Looking through the functions, I can’t see anything that would...

Mitchell_Wells1 · Feb 17, 2019

IF(RIGHT(Weights,1)=0,{Total Price},BLANK()) The first thing in the RIGHT function is the field you’re wanting to look at - Weights. The second thing is how many characters from the right you want it to look at - one from the right. So we’re retrie...

User Statistics

User Activity

Separating Lookup Field Back into Individual Fields

Page Designer to Illustrator Workflow

Page Designer Text Formatting

Aggregating Data between Tables

Funny Error in Substitute Function

Re: Separating Lookup Field Back into Individual Fields

Re: Separate a Look Up field (separated by commas) into separate cells

Re: Separating Lookup Field Back into Individual Fields

Re: Basic Formula Help using RIGHT()

Re: Basic Formula Help using RIGHT()