Devon_Moore - profile

Devon_Moore · Oct 18, 2024

We have a base where users go to print documentation from specific records.Nobody is supposed to be changing the Page Designer instance at all, but I think people are accidentally adding or moving fields when they access the extension.1) Is there any...

Devon_Moore · Oct 31, 2022

Hi all, I am using the Spreadsheet Importer in the Scripting Extension to upload an XLSX file to create new records in my table (“Report Data”). One of the fields in this XLSX report is a Customer ID. That should be a linked field to a table called “...

Devon_Moore · Sep 20, 2022

Hi team, I am using the scripting block to add a new single select option to a bunch of fields at once. Is there any way to specify the color of the item? Currently they all seem to be adding as grey by default. Thanks!

Devon_Moore · Oct 21, 2020

Hi there, Hoping someone out there can help me with a weird automation issue. First, some context: I have 2 tables in my base. Table #1 is the order table - This is used for tracking individual orders (every line order is quantity 1), and the record ...

Devon_Moore · Jun 12, 2020

I find this feature invaluable in Excel, and I would love to see it implemented for Airtable.Currently the only conditional format coloring option just sticks a little colored box next to the main record name. For my team’s purposes, that’s not parti...

Devon_Moore · Oct 18, 2024

You’ll have to use a nested if to check if the date exists first:IF({date}, IF( NOW() >= DATEADD({date}, -30, "days"), "ending time" ) )

Devon_Moore · Nov 01, 2022

Thank you Justin! I’ve been messing with this for a while but I’m definitely not fluent in JS… When I try the code below I am getting a blank array as a result: let filteredRecords = IDQuery.records.filter(ID => { return ID.getCellValue('Customer...

Devon_Moore · Sep 21, 2022

Okay I had to modify this a bit, and it only takes certain color inputs, but it works! Thank you! Dropping the code below if anybody else is looking for this in the future: const table = base.getTable("Your Table Name"); const field = table.getField(...

Devon_Moore · Oct 26, 2020

Very true, thanks for clarifying! Like in this case, if I knew for sure that the shipping record did not yet exist in Table #2, I would just have the automation fill the Link Field only. But since I need it to append itself to a record that already e...

Devon_Moore · Oct 23, 2020

Hi Ryan, No script was necessary. I can’t share screenshots due to sensitive info in the base, but I will explain it in a way that hopefully makes sense. Initially, the primary field in Table #2 was a formula of lookup fields from Table #1: ({Custome...

User Statistics

User Activity

Page Designer - permissions and edit history

XLSX uploader script - update linked record or create record if it doesn't exist

Add single select option & change color via script

Script to check if a record exists in another table?

Conditional formatting - coloring individual cells

Re: Hiding #ERROR! Message from field

Re: XLSX uploader script - update linked record or create record if it doesn't exist

Re: Add single select option & change color via script

Re: Script to check if a record exists in another table?

Re: Script to check if a record exists in another table?