Solved

I have two tables: “Widgets”, “Sales”. A Sale record can reference one or more Widgets. When I create a new Sale record, I want the the “sold” field in the corresponding widget record(s) to be toggled. Sounds like this might be an Automation, but I’m new and not sure. Can someone please point me in the right direction? Thanks.

I am new to Scripting and need assistance with modifying the following Airtable Script, which is working well with the Base that I am creating. Unfortunately, I do not want the script to request user input for the number records to create; instead, I want it to use the number that is contained with in a field in the GOODS IN table. Can anyone help please? let settings = input.config({ title: 'Create child linked records', description: `For a record in a "parent" table, this script will create some number of “child” records in another table, where each “child” references the “parent” through a Linked Record field.`, items: [ input.config.table('parentTable', { label: 'GOODS IN' }), input.config.table('childTable', { label: 'LOTS IN' }), input.config.field('linkField', { parentTable: 'childTable', label: 'Linked record field', }), ], }); async function createChildrenLinkedRecords() { let { parentTable, childTable, linkField } = settings; if (

I’m prefilling a link in a button field to an adobe webform. It works perfectly if I click the button on desktop, but on mobile it encodes the # that adobes requires as is and doesnt fill the form. Is there something I change in the button? Its useless if mobile users can’t use it since most of the team uses their phones vs desktop. My button: CONCATENATE("https://na1.documents.adobe.com/public/esignWidget?xxxxxxxxxxxx*#”,”L-Number=",{L#s...},"&Name=",{ID.},"&Microchip=",{Microchip Number},"&Age=",{Years/Months},"&Breed=",Breed,"&Sex=",Sex,"&Fee=",Fee) iOS link that opens the right form but doesnt prefill: https://na1.documents.adobe.com/public/esignWidget?XXXXXXXXXXX*%23L-Number=CP21-069&Name=Cassie&Microchip=990000005808221&Age=1%20year&Breed=Border%20Collie&Sex=Female&Fee=175 Link that opens and works on desktop: https://na1.documents.adobe.com/public/esignWidget?XXXXXXXXXXXXXXX*#L-Number=CP21-069&Name=Cassie&Microchip=99000000

Sorry for the newbie question. I imported an excel file into Airtable. My main column (far left column in image) I would like to convert it to Single Select. In the second screenshot you will see that it does not allow me to do so. I tried then to create a new column from scratch and create each value with the color coding, with the intention of deleting or hiding the original column on the far left, but it doesn´t allow me to do that either. How can I make this work? Thanks! Airtable reddit 1|411x269

Hi, my code is working locally just fine but not on the server. The code’s purpose is to create a new record is created in Airtable. When I push this code to IBM Cloud Functions, which is equivalent to AWS Lambda if folks are more familiar with AWS, the code seems to finish before Airtable’s “create record in base” function executes. A little about the code: it’s an analytics function. It will take a search term, like “dog food”, figure out all of the products tied to that search (say there are 64 products) and for each of those 64 return five different scenarios based on whether our main Airtable has that data: relevant result (in this case, 50% or 32 relevant results) not found in database (in this case 28% or 18 not found) found, but missing country (in this case 8% or 5 missing country) found, but missing manufacturer (in this case 14% or 9 missing manufacturer) edge case (in this case 0% or 0 edge cases) All code samples are below. The code is two pieces, one is a “createRecor

Hello All, I created a table in my base called notes. Customized the field type to Long Text then turned on the Enable rich text formatting. Copied and pasted a bunch of town names into one of the cells. Clicked on expand cell blue button so I could see the whole list. When it opened it had a red zig-zag underline under most of the names. I was right clicking on them all one by one and selecting add to dictionary when I realized I had added one of them to the dictionary that was spelled incorrectly. NOTE: Undo from adding to dictionary only seems to work on the LAST word added. Q: How do I find this dictionary and remove the misspelled word so it is caught again in the future! Thank you Jonathan

Hi all, Is there a way to run Run the first Datetime formula and if an error automatically run the second date time formula to pull the information in? DATETIME_FORMAT({Date Paid}, ‘MMMM-YYYY’) DATETIME_FORMAT({Order Date}, ‘MMMM-YYYY’))

I’ve written an automation script that I’d like to migrate over to the scripting app. I know that there are some differences between the two, but I’m having a lot more trouble than I thought. The script connects to an external API and pulls data from the API into my base. I seem to be running into issues with the async functions I’ve written to connect to the API and pull the data in. The code works when it’s not wrapped up in a function, but fails when it looks like the example below: async function testFunction(){ let response = await fetch('https://api.github.com/orgs/Airtable'); console.log(await response.json()); } testFunction(); This code above works as an automation script, but not in the scripting app.

Is the fact that the Scripting app linter recognizes this method a bug, or a sign of things to come? The capital B seems to imply React shenanigans. I know there have been calls for table creation to be added to the app, but I didn’t think it would actually happen. I still don’t, but I guess that’s one way to place it behind a paywall in style come September (assuming Airtable actually comes through with it this time around lol). Either way, I’m afraid that trying to run this yields a full stack’s worth of a debugging mess instead of a new table: Edit: or have I just broken the app by running it on an iOS version of Safari? :grinning_face_with_sweat:

Hello, First challenge…I am trying to show when a number is input to the RECEIVED column, that it subtracts itself from the ORDERED column and puts the result in the BACKORDERED column (however if the RECEIVED column is blank, I need the BACKORDERED column to be ‘0’ or blank as well). Second challenge…If the RECEIVED number equals the ORDERED column then the STATUS column should show ‘complete’. If the RECEIVED number is less than the ORDERED column, the STATUS column should show ‘in progress’. If I was to say this in one sentence it would be “If received is not 0 or blank, subtract it from ordered and show result in backordered AND if received equals ordered change status to complete OR if received is less than ordered change status to in progress” Any help would be much appreciated! :grinning:

I don’t remember my new password. I have the old password. I didn’t register via email because contains special characters " _ ". How can I log in again? Thanks

Hi, would it be possible to define a custom formula? For instance I want to make one that generates a UUID that can be used across a variety of platforms. Thanks in advance

Hi All - I would appreciate any support In one base, I have two tables (Master and Prices). I have a list of products on the master table with a field (column) named costs, and in Prices, I have Product and new Price fields. I need assistance (not sure if this is possible) with a formula that will help me update the costs in the Master table if the product in the Master table is also available in the Prices table. Example: In this example, the Master table will only update products A and C’s Cost fields because it has not picked up a product on the Price table. This means that in Table 1, product A will change automatically to 150 and C to 250. Nothing will happen to B because there is not a unit for it in Table 2. Any help will be much appreciated. Thanks

I had searched through the community and seen a post stating about the date difference of a period showing data like 2 months and 31 days or 3 months 30 days. It is worse if it involves February as it will be calculated as 1 month 30 days. Example as below. I’m making all the months defaulted to have 30 days, as per below formula. DATETIME_DIFF(end,start,‘months’ ) & ’ M ’ & ( DATETIME_DIFF(end,start,‘days’ ) -DATETIME_DIFF(end,start,‘months’ ) *30 ) & ‘D’ I would like to know if there is any way to make the difference to be more accurate like those in Excel? I saw that there is a post regarding Switch() formula but I have no idea how to include that into this formula. The Switch() formula is as below. SWITCH(MONTH({start Date}), 1, 31, 2, IF(MOD(YEAR({start Date}), 400) = 0, 29, IF(MOD(YEAR({start Date}), 100) = 0, 28, IF(MOD(YEAR({start Date}), 4) = 0, 29, 28 ) ) ), 3, 31, 4, 30, 5, 31, 6, 30, 7, 31, 8, 31, 9, 30, 10, 31, 11, 30, 12, 31) Is there a way to calculate the

Hi I’m playing around with scripting (not a programmer) and I’ve run into a situation where I can’t update assign the collaborator object. I’ve modified my code to represent what I’m looking for Collaborator is the collaborator field on my base. I’m trying to assign a collaborator (through a previous function) named ‘assignCollaborator’ await table.updateRecordAsync(record, { "Collaborator": { "name": assignCollaborator} }) The errors I’m getting say that the fields don’t exist but I can create references like this let collabName = record.getCellValue("Collaborator").name Some explanation here would be super helpful. Thank you

I’m just needing a hand with the Automation Scripting Syntax - I can push it to Console.Log, but just struggling to pull/assign the input values to variables. I’m trying to get local time date stamping into fields, really struggling to get my head around the timezones, when I think I’ve got the problem solved, it’s not. So I figure that if I pull the time of when the script actually executes, surely that will reflect the correct date.

Hi! I am using Zapier to autofull documents based on airtable inputs, I am struggling with checkboxes and trying to use formula fields to provide me with a “true” or “false” based on the input of a single select field. Has anyone used single select to provide a true or false outpouts, I am stuck!

Hi there! I’m looking to create a formula that will set a trigger for a reminder in 30 days time from an activity, when it will display “Trigger Reminder” after 30 days have passed from that live date field. I thought this formula would work: IF(AND(DATETIME_DIFF(TODAY(), {Live Date}, ‘days’ > 30)), “Trigger Reminder”) But that just comes up with Trigger Reminder for pretty much everything in my base. Any help welcomed! Thanks! J

I’m trying to write formula for a field that would check the {CHECKBOX} field for a check (=1), and also check another {FINAL AMOUNT} field for a range, to then return a corresponding value. If the {CHECKBOX} is empty (=0), I’d like the field to just return a “0”. I’ve tried tons of different ways to nest IF and AND statements, and the only formula I tried that will not trigger a syntax error will not display the values if both the checkbox and range criteria are met: IF(AND({CHECKBOX}=1,{FINAL AMOUNT}<20000,500,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=20000,{FINAL AMOUNT}<40000,750,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=40000,1000)))))) If I try to add one more IF statement (either at the beginning or the end) to yield the “0” if {CHECKBOX}=0, Airtable tells me it’s invalid: IF({CHECKBOX}=0,0,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}<20000,500,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=20000,{FINAL AMOUNT}<40000,750,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=40000,1000))))))) I’ve read ton

I have the following formula that spits out a number of days since the last event for an entry and if no event is found, it returns 9999 instead: IF({Days Since}=0,‘9999’,DATETIME_DIFF(TODAY(),{Days Since},‘days’)) My issue is that the formula field doesn’t recognize this result as a number and won’t let me format and filter as such. Is there any way I can return a result that allows formatting as a number? I tried using BLANK() in place of 9999, but the issue is that I need to filter results that return a number greater than say 90 or 180. So blank results get filtered out when I would want them to be filtered in. And this is part of a longer filter so I can’t use an OR statement in the filter.

I’m trying to import data from an API. I’m able to authenticate via my terminal, but I’m trying to write a script to automate that process (the access token is only good for 24 hours, so they recommend refreshing the authentication before every request or once per day). As I understand it, fetch() is the way to do an HTTP POST. I’ve written a function to do this, and I keep getting a 401 Unauthorized error. It looks like nothing after the url is getting passed on. I’m sure this is some kind of syntax error on my part, but I’m not familiar enough with JavaScript or API’s to know what it is. Any help would be appreciated. Code is below: async function authenticate() { let authentication = await fetch(authenticate_url, { method: 'POST', header: 'content-type: application/x-www-form-urlencoded', data: `grant_type=refresh_token&client_id=${clientID}&client_secret=${client_secret}&refresh_token=${refresh_token}&username=${username}&password=$

I’ve got a rollup field tied to connected records with dates, and I’m not 100% sure how it works. My goal is to have this rollup field only show the most recent date. So if it is rolling up from two entries, lets say: 1/1/2020, and 10/10/2020, I only want to see 10/10/2020. I’m assuming I use the MAX() attribute for that…but I’m not sure. Can anyone confirm what the appropriate aggregation formula is to display the most recent date of several in a rollup field?

Hi all, I came up with the following design for the internal BI system. The first table is used to store the payments. (Payments table) I also need to calculate the monthly sales statistics for each sales representative along with their quota (a predefined value that differed from month to month and added manually each time) For that purpose, I have an additional table. (AM table) The combination of (sales_rep, month, year) creates the unique id for the AM table and the linkage between two tables works very smoothly. However, I believe there is room for improvement since I have to Link unique-id-am field to AM Quota manually every time. I just drag the cell to AM Quota as you usually do when copying the column. I want to automate this process and write a script that will perform this action for me in the add new row event. I thought of doing something like that, but obviously AM Quota doesn’t allow me to do that due to the conflicts of type. let table = base.getTable("Payments"); le

What is the syntax for an IF statement that only generates output if two conditions, in two fields, are met? Thanks for your help!

I want to hit an API much like the currency conversion example. However, the example updates all the records in one go. Instead, I would like to fetch the API result for just the one record that was either created or updated. The record ID is available in the input, so that should work fine. But what about the table name? I happen to be partitioning this data into multiple tables (each with the exact same schema). The table ID or name doesn’t appear to be available from the trigger/input. And every example I’ve seen hard-codes the table name in the script. Since the automation is triggered on a record which exists within a table, I believe a reference to the table should be available, but I can’t seem to find it. Is there any way to get the name or ID of the table within which the record was created or updated?