Scott_Mullin - profile

Scott_Mullin · Dec 26, 2023

Hi folks,I'm looking for ideas on base design(s) for chemical formulations. I've taken one stab at this where I hardcoded some columns, but that fell apart pretty fast. I'm hoping some Airtable creatives have ideas. Here's the general problem:An ingr...

Scott_Mullin · Dec 01, 2023

Hello,I'm working on an automation that, when triggered by a new record being created, runs a script. The script should take that record, parse a comma-delimited list, then create new records in a separate table. The new records are include the uniqu...

Scott_Mullin · Nov 03, 2023

Hello,I am designing a base that needs URLs with markdown in this format:[text to display](https://my.url.com)However, when I try that... that's exactly what it looks like. I'm using long text fields with rich text enabled. I've tried a bunch of vari...

Scott_Mullin · Sep 19, 2022

Hello, I have a table with about 1700 records. I’m pulling a couple of records and doing some math on all the rows, then updating the result in a new record. The bulk update code I’m using is waaaay faster than a single row update, but it’s still tak...

Scott_Mullin · Sep 08, 2022

Hello, The dropdown for “Choose a View” has a narrower width than the max char size of view names. When users name a bunch of views the same initial way, it’s impossible to tell what you’re copying.

Scott_Mullin · Dec 27, 2023

Kuovonne,That worked well for the case without recursion. Thank you again! I'll have to think further on the recursive case to see if it's worth messing with. That could get pretty wild.Regards,Scott

Scott_Mullin · Dec 27, 2023

Thanks Kuovonne! I'll give that a try and let you know how it goes. I appreciate the advice.

Scott_Mullin · Dec 01, 2023

yay thank you so much! In my messing around with it I ended up testing the code without those [] brackets recordsToCreate.push( {fields : { "Geometry" : oneGeometry, "Part Count" : partCount, ...

Scott_Mullin · Dec 01, 2023

2 more things:1) Does the recordID need to be the actual recordID? I have tried both the actual record ID e.g. "recDtpSLcblG1fE4a" vs the name I'd type in to do the link, e.g. "ScottPrint2" and neither have worked, but I'll have to sort that out.2) H...

Scott_Mullin · Dec 01, 2023

Thank you, that is very helpful. I got further along - I tested that the rest of the code works properly, but I'm still having trouble with the record linking bit. Here's what I have at the moment: recordsToCreate.push( {fields : { ...

User Statistics

User Activity

Base design for chemical formulation

Mapping fields syntax in a script

URL markdown not working as expected

Bulk update - can I speed this up?

UI change request - dropdown for "Choose a View" when copying filter settings

Re: Base design for chemical formulation

Re: Base design for chemical formulation

Re: Mapping fields syntax in a script

Re: Mapping fields syntax in a script

Re: Mapping fields syntax in a script