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...
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 “...
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!
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 ...
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...
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...
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(...
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...
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...
