Solved

Not related to Airtable, but I wonder if anybody came across a service where I can push clickable URL address to. I created a dynamic URL formula to Airtable form with help of kuovonne’s Prefilled Forms. That URL changes and new URL is generated after the previous form was submitted. So now I am looking to upload upload that URL somewhere online where I can click it in a web browser. I am thinking Zapier or Integromat would watch changes in the field containing kuovonne’s changing URL and it would pick up the new URL and push it somewhere. Where … that I don’t know. I could setup twitter account for example and click the URL in the twitter feed. RSS could also work but I don’t want to display old URLs in the feed. I just want to show the latest version of the URL. However, I am looking for something simple, without need to open an app, something that would work without login, for example web-page and Zapier / Integromat would update that link there. Anybody knows anything like that? M

Hi folks, I am fairly new to the formula game and I’m working on a formula where I have 3 columns with dates {LOI Target}, {ETA to AMZ}, {Content Delivery Date} and i’ll need to calculate the latest date out of the three of these Add 7 days to the latest date Calculate to the next Tuesday input date correctly into column It’s a bit of a monster. Any help even in little pieces would be great. I’ve been wandering the forums looking for help and this one was the closest formula to one of my needs (latest date out of the 3 dates). So, is the following formula on the right track for what I want? I know that the MAX function doesn’t really bode well with dates but that’s about all I know. IF( OR( {LOI Target}, {ETA TO AMZ}, {Content Delivery Date} ), DATETIME_PARSE( MAX( IF({LOI Target}, VALUE(DATETIME_FORMAT({LOI Target},’MM/DD/YYYY’)), 999999999999999), IF({ETA to AMZ}, VALUE(DATETIME_FORMAT({ETA to AMZ},’MM/DD/YYYY’)), 999999999999999) ) , IF({Content Delivery Date}, VALUE(DATETIME_FORM

Hi, In my table I have a field where I want the expiration date of a contract be automátically calculated based on another date field (when the contract was signed) + 36 months duration period. The formula is as follows: DATEADD({signed}, 36, “months”) Most of our contracts are for 3 year periods, but because, we actually have some that are for one year, I thought I could create another number field where I could set as default the value “36” but eventually could change the number of months to “12”, for example. Now the new formula is: DATEADD({signed}, {contract duration}, “months”) PROBLEM: The date appearing in the signed field is June 20, 2015. In the first formula, the date that resulted was June 20, 2018 (signed date, 36 months later) The second formula however came June 19, 2018, a day earlier. I’ve tried with different month values. it always comes one day earlier. Any tips, suggestions, etc would be appreciated.

I’m on the free plan and when setting up an automation to send an email I get this error message: “On your billing plan, you may only email collaborators with verified emails. Contact your workspace administrator to upgrade.” However, the email address I’m putting in is my Airtable username and it has been verified. Any ideas on how to fix this?

Hi, I’m using the following formula in the column “is absent today”, but for some reason it isn’t correctly finding August 16th. I suspect this is because the linked “Absent” field is an array, which is why I included the &"" in my formula, but that didn’t fix it… IF(FIND({Today's Date},{Absent} & ""), 'Y', 'N')

Hey there I have a synced base that is pulling a “percentage” field from another base of mine. I am running a formula field on the lookup field, however it is giving me an #ERROR! as a result. I have tried using Value(), but nothing works…

Hi, Is there a way to ‘freeze’ a view so any newly created records don’t enter it. I’ve got to download a load of data from the table and run them through another software and then re-upload the results. I’m hoping i can just paste in the results but i new records enter the view that weren’t included in the original download then there might be a race condition. Thanks in advance

Hey everyone, Sorry if this has been asked before, I couldn’t find anything. I am still a beginner. My Problem is the following: IF({Laufzeit (Monate)}= BLANK(),"", DATEADD(Vertragsbeginn,{Laufzeit (Monate)},“Month”)) It works, but the result it is no longer shown as a date. I guess because it could either be a date or a text, it doesn’t recognize it. So what I want is to have an empty cell in case “Laufzeit (Monate)” ist empty and the calculated date as a date in case “Laufzeit (Monate)” is filled. Could anyone help?

Hi, I’m trying to set up a sheet to manage attendance for a preschool center. Kids have a different “weight” depending on their age, which I successfully set up. The weighting is used to determine how many kids we can have at once. What I now need to do is show a daily breakdown of those weights, because some children don’t attend preschool every day. I need a calendar where I can look at any given day and see how many total kids will be there. I’m trying to combine the weight formula with START and END date fields, but can’t make it work… Any advice is much appreciated!

I’ve got my PEOPLE and COMPANIES in separate sheets in one base. Cool. (Love it if we could link multiple bases!) I finally figured out I should link all their social media spheres into one sheet, too (so those entries don’t go on forevah!) Q: But how do I keep straight (i.e.: link) the many TITLES one person who wears a lot of hats may have with their variety of entitles? Example: A gal who’s the CEO of her own company but ALSO the VP of a joint venture/partnership, on the Board of a charity and maybe the President of a trade organization? Sure: I can reciprocally link her - as a person - to a variety of companies/entities (and of course, lots of peeps with one company) - I get that - but how do I keep all her various TITLES straight? So I know which title goes to which company - for the same person? A whole 'nuther “Titles” sheet? Like the Social Media sheet? Ugh. Better way? Beuller?

Record ID is not being detected by the automation tool. I need to change a status of a record when another record is created. But when I link them together it does not detect the ID and the error says the field is invalid. I have other automations done the same way. I am using “copy” tables so I don’t mess with my current data Flow wanted: The table that is going to be updated is “Control Modulos” When record is created in Cosecha → Change status of linked record to “Disponible” and then When record is created in Paso Modulo → Change status of linked record to “En operacion”

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