Solved

I’m new to Airtable (and databases generally) so I apologize that I can’t articulate my problem better than this. But here goes: Through Zapier, every day I send an Airtable form to my clients. When they complete the form, a new record appears in the base. So far so good. Ideally, they would complete the form every day of the week so there would be one record per client per day. But they sometimes forget… Is there a way to automatically create a blank record (with null values) for the days when they forget to complete the form? I need to track these no-response days and don’t want to create the records with null values manually. I’ll be (extremely) grateful for any help. -Jason

This is my first post to the community, so please be patient if I haven’t gotten this formatted right on the first go. Also please be patient if I don’t provide enough info right off. I can update as necessary :slightly_smiling_face: Also please not that due to project limitations I am unable to use Node.JS, so I am prepping all my queries “manually” and sending them out via XMLHttpRequest(); once I have them built. I am also not using any other frameworks or services like Adalo or anything. I am working on a small web app using Airtable, and I’ve come across a couple oddities when getting records. I’ve tried searching for info on this but haven’t had much luck. 1: When i send a request like this: https://api.airtable.com/v0/[BASE ID]/Studies?maxRecords=5 I get back five records, but my expectation would be to get either the first five records or the last five records of the table. Instead I get what seem like five arbitrary records. The table I’m testing with has records with a Uniq

I currently have a formula that calculates the cost of a child attending a class over a number of weeks. Extrachildren*({Weeks FM}+{WeeksSR})*5 This works well until I was told if they book for 11 weeks then the 11th week is free (they never book for more than 11). So I need the formula to multiply by 10 if 11 weeks are booked. Can somebody please tell me how that should be expressed in the formula. Thanks in advance Phil

Hello – I have two tables and have an automation running from conditions met on the first table to create new records on another table. I have several automations running between these tables with no issues for some reason, one of them keeps creating two extra records. I’ve even tried deleting it and recreating it. Any ideas? You can see here that it is only meant to create 5 records but it’s creating 7.

Sorry in advance - I am a very green user to Airtable and Databases in general. I would like to make a formula that can scan a record for a word and then automatically make the value 0. Example: Line Item ------------Unit ----------- Rate---------Total Cost Invoice - 0011-------1.00------------$100----------$100 Bid - 0100------------2.00------------$500----------$0 In this case I am using: Rate*Unit to reach the total cost. This will mean that the “Line Item” Bid-0100 will pop up with a total cost of $500, but I need it to show 0 as it hasn’t actually cost me anything. Is this possible?

HELLO! What fx do I have to build in “copy”, so that the value of the cell below is the summation with the value above? [quote=“Serge_Lacasse, post:1, topic:29840, full:true”]

I have a formula that correctly shows the cost of having 1 child in a class. When the parent has 2 or more children the cost is £5 per extra child per week. They could be in either Weeks FM or WeeksSR. So far I have a column showing “extraChildren” / number of weeks /class fm/ class sr/ but my formula is wrong and I have no idea what it should be. Once I have the correct total I will need to add that to the combined Total Amount The Amount formula is already very complex so how would I add it.IF({No of weeks FM}, VALUE(RIGHT({No of weeks FM}, LEN({No of weeks FM})- FIND(“£”, {No of weeks FM}))), 0)+IF({Zoom}, VALUE(RIGHT({Zoom}, LEN({Zoom})- FIND(“£”, {Zoom}))),0)+IF({Party}, VALUE(RIGHT({Party}, LEN({Party})- FIND(“£”, {Party}))), 0)+IF({No of weeks S&R}, VALUE(RIGHT({No of weeks S&R}, LEN({No of weeks S&R})- FIND(“£”, {No of weeks S&R}))), 0) Any help you can give me on this would be greatly appreciated as no matter what I read about formula, I am afraid I can’t see

Is it possible to put the Enter key in the formula? I tried the Enter key code (^p, it is Enter key code in the Word) , but it didn’t work. I want to implement the following display: EU Community Legislation: RED 2014/53/EU, RoHS Directive 2011/65/EU (10), RoHS Directive (EU) 2015/863; Product Standards: EN 301 489-1 V2.2.3, EN 301 489-17 V3.2.4, EN 300 328 V2.2.2, EN 301 893 V2.1.1, EN 62311:2008, EN 62368-1:2014/A11:2017; Adapter Standars: NA

So I wanted to get the API key so I could integrate some zaps, navigated to the API ‘mode’ of the desktop app and now its stuck there. There’s a big blue button that says “Open Base” that does nothing when I click it. I’ve uninstalled the app and redownloaded the latest version, and every time I open it its still stuck. Help!

Can you create a Base within a Base?

Hey all! I have a brand new base with some data that I imported in a CSV. It created a table called Classic Rock Songs (which is as awesome as it sounds) and populated records into 3 fields: Song + Artist Song Artist Each artist can have multiple songs (or at least the ones that were’t one-hit-wonders!), and I want to create a second table that: Lists all unique artists from the Classic Rock Songs table into the Artists table Links the records so that all songs for each artists show up in the Artists table I’m basically struggling with the first step above, and how to create a new table with unique artists. Appreciate any ideas… rock on! :guitar:

Hi there! I’m setting up an editing task list for a wedding photo + video business. I have a lookup field set up for the wedding date, and would like to have one field that returns the deadline for each deliverable (various films, galleries, etc.), based on differing #s of days from the wedding date. E.g. preview photo gallery due in 21 days, versus a film due in 60 days, etc. If I use the formula shown below, it seems like I have to have separate fields for each of my different delivery timings (+21 days for some, +60 days for others, etc.), which really muddies up my table. This also doesn’t work well in cases where my deadline needs to deviate from the rule (for example, a scenario where we need to deliver in 14 days rather than our usual 21 days) I’d like to be able to enter the number of days post-wedding that the item is to be delivered into one field (e.g. 21, 60, 90, etc.), then use a formula in another field to spit out the deadline based on that specific number of days after

How do we get this formula right? Now it always returns 0

Hi, I have a base where we key in the ID numbers of each person in a column - Males have odd numbers and females have even numbers. Would like to create a column that automatically tags them as either Male or female based on this data but I cant seem to figure our what formula to use. Could someone help me? It would be of great help. Examples: XXXXXX-XX-5557 = Male XXXXXX-XX-5556 = Female.

Hey AT Users. Has anyone come across a good solution for either timestamping an updated element in a field or generating a timestamp for when a computed field contains a value vs when it is empty? For context: In our base there is a rich text field which includes a check list of about 10 items (done to eliminate the need of 10 separate fields, as there is already a LOT of data to process in this base). Using the following formula I can only return a timestamp for when the entire field was modified, not the particular element in that field: IF(FIND(" Milestone “,{Milestones Checklist}),DATETIME_FORMAT(SET_TIMEZONE(LAST_MODIFIED_TIME(), ‘America/Toronto’), ‘M/D/YYYY LT’,”")) If anyone has a work around for either timestamping when each of the 10 elements is marked with an x OR knows a workaround for timestamping a computed field - then I could add an IF(FIND(" Milestone",{Milestones Checklist}),“Yes”,"") field and then timestamp WHEN that yes appears. Any thoughts???

Hey Guys, I have used a formula that I copied from an answer here to create an end of month field. I have transaction dates for sales and i want to get the end of month date for each transaction date. It works for all months except when a transaction takes place in any december for some reason, in any year. For any other months, it works fine. This is the formula that I am using: DATEADD( DATETIME_PARSE( DATETIME_FORMAT( {TX DATE}, ‘YYYY’ ) & ‘-’ & (VALUE( DATETIME_FORMAT( {TX DATE}, ‘MM’ ) ) + 1) & ‘-01’, ‘YYYY-MM-DD’ ) , -1, ‘day’ ) Can anyone try to pinpoint what’s wrong with it please? Thank you Hady

Hello! My goal would be to automatically add photos from Table 2 (where they are imported in bulk) to Table 1 (with the right item order). The only link between the items in the two tables is a code/name column. I tried my best experimenting with formulas in Airtable and GSheet, but I couldn’t find any solution. I copied a script from an older community topic: Programmatically copy images from one table to another , but it doesn’t seem to work. Can someone please help figure out what the problem might be, or offer another solution? Here’s a simple version of my base (Restaurant): https://airtable.com/invite/l?inviteId=invyOwrzT6i00qbss&inviteToken=1c708dfb92651fb230f375f758d4d172ad56602b0347fccf8ac86f495d5a8522 , where the pasta dishes (Menu Item Name) should get the photos in the Attachments column from the Image column in Table 2, connected by the Name and Code columns. Thank you!

Thanks for taking a look in this thread. I am looking to create a zapier step that checks for a row in a table which contains 1) a certain ID (exists as string), and 2) to see if a certain string exists as part of a rollup. How would I write the formula for this? This is what I have so far… it’s good for finding rows that have only one item in the rollup, but if I need to find a certain item within a rollup, it says none exist. AND({ID}=‘abcdefg123’, {Rollup}=‘xyz999999’) Thanks again! Happy holidays!

Hi I’m looking for a formula to convert a field from First Name Last Name to Last, First. “Steve Smith” to Smith, Steve". I see a lot of people have ways to go the other way… thanks!

Hi all, I’m diving into the wonderful world of Airtable scripting with a custom CSV import script that does some data interpretation and creates links to other tables. Starting point was the CSV import example. I managed to get that working and added more functionality. Now, I keep getting an error that I cannot seem to solve: But the editor shows no red markings, and the first line of my script is a comment! Here are the first few lines of my script: // Timesheet CSV importer by Emar Vegt output.text("Note: this script does not handle duplicates yet. You'll have to sort them out yourself."); // Ask the user to import a CSV file containing a header row let csvFileResult = await input.fileAsync( 'Upload a timesheet CSV file', {allowedFileTypes: ['.csv'], hasHeaderRow: true} ); // The file importer will automatically parse contents for many file types, including CSV files let csv_rows = csvFileResult.parsedContents; // Edit this to the name of a table in your base let timeshe

Hello, I use this script for move record from table 1 to table 2, All data is moved except data of type dropdown list (Ville). I show this error: Can’t create records: invalid cell value for field ‘Ville’. Could not find a choice with that ID or name let table1 = base.getTable("DATA"); let table2 = base.getTable("Con"); let result = await table1.selectRecordsAsync(); for (let record of result.records) { if (record.getCellValue("Prét")) { await table2.createRecordsAsync([ { fields: { 'ID': record.getCellValue("ID"), 'Source': record.getCellValue("Source"), 'Agent': record.getCellValue("Agent"), 'Nom complet': record.getCellValue("Nom complet"), 'Téléphone': record.getCellValue("Téléphone"), 'Ville': record.getCellValue("Ville"), 'Prét': record.getCellValue("Prét") }, } ]);

Is there a way to reset an input field? Say someone pulls up a record selection input and then they click off so nothing is selected the user is no longer able to go back and select something different. As far as I know you can’t reset the input, remove the element and re-add it to let the user try again. I tried using a do while loop so that it could do the input instruction again if the variable is null. If it isn’t possible to reset the input or remove the element and re-add another input, is there a way to re-run the script with a button or some other event?

I have a table with 290 records and 10 fields that need to be updated yearly and I am struggling knowing if a record has been updated or not. Essentially I need help creating a system to track if records have been updated and if they need to be. My table consists of fields that either update all the records at once yearly, or get updates spontaneously throughout the year (sort of like a company yearly earnings). You know it is coming but they don’t release them all at the same time. Any suggestions of what it could look like? or how to think about this?

Hi all, I have a couple fields in my base where the values are reviewed every few months (i.e. risk score increases or decreases according to mitigation measures). I would be interested in plotting how for example the risk score for a particular risk has changed over the course of the project. I know I can expand view and see how that record has been edited over time but I was wondering if there is a way to monitor changes to a particular field so that the data can be extracted automatically for graphs and tables etc… The only other thing I can think of is creating a new field every time the values are reviewed and then hiding them from view but that would just create so many fields over time. Thanks in advance for your help, Camilla

Is there was a script I can use to erase all attachments in an attachment field with the click of a button or even with an automation?