Solved

Using a script, what is the syntax for clearing a value from an existing record in a single select field?

How would I go about adding a field to an existing table that already has 25,000 records and filling all 25,0000 cells in that new field with the same value, say, “Cookbooks?” If you’re curious, it’s because my dear old dad put both general subject location data in the same cell with specific location information (i.e., Cookbooks - garage wire rack, top shelf). And before you go suggesting that I use a formula which divvies up the data before and after the dash, I should say that he’s totally inconsistent in the way he orders this information and the way he separates it.

How do I remove the timestamp from this? IF({Appt Date},DATEADD({Appt Date},-2,‘days’), BLANK())

I need to copy a record from one table to another table (or from one base to another base). The records I need to copy are the ones I label as “Expired”. The act of copying them will be done manually, that’s not an issue. What I am looking for is how to preserve the date in the Create Date field when copying the record. Right now copying the record would trigger the Create Date field to be updated with a new date (=now date). What I want is the new copied record to cary over the original create date. One solution I came with is to: In Table 1 (the record has Create Date field with the date) In Table 1 add another field called “Original Date” Set up Automation in AirTable or Integromat. It would trigger when this “Original Date” date field is empty. When copying the record into Table 2, this Original Date will be carried over (although the Create Date will have a new date =now date). I haven’t tested Airtable Automations if it will work but I assume it should (another option is to

I have a script that’s currently working to create one record on my Project/Yarn junction table, but I need it to create multiple records, one per linked cell value in Yarn (from stash), if there are multiple of these. I’ve had a looked on the forums but am struggling to find the solution, can anyone help? This is my current script: let table = base.getTable(“Projects”); let record = await input.recordAsync(‘Select a record to use’, table); let populateTable = base.getTable(‘Project/Yarn’); if (record) { await populateTable.createRecordAsync({ “Project”: [{id: record.id}], “Yarn used”: record.getCellValue(‘Yarn (from stash)’), }) output.text(Record created: ${record.name}) } else { output.text(‘No record was selected’); }

I’m trying to add more intelligent time support to one of my bases, so I went looking for a free time API that I could query, and I found this: worldtimeapi.org World Time API: Simple JSON/plain-text API to obtain the current time in,... It looked like it would fit the bill, so I built a quick test in the Scripting app. However, I hit a CORS-related error, so I shifted testing to a script action in an automation. While I’m no longer getting an error, I’m also not getting the response I’m expecting based on the examples on the above site. Here’s my simple test based on the first example shown on the homepage: let result = await fetch("http://worldtimeapi.org/api/timezone") console.log(result) This is supposed to return a full list of timezones, but this is what the console shows: I’m still relatively new to calling APIs, so it’s possible I’m missing something basic, but I’m not sure what it is.

I got an issue with these two characters… The issue is with: ’ and ’ When I copy a formula from AirTable into textpad on MacOS and start editing the formula there, the ’ character gets eventually somehow replaced with ’ and when I copy the formula back into AirTable, the formula is broken because some of the ’ got replaced with '. It’s strange. I don’t have any text-expander or text correction software so not sure why it happens. Wondering if anybody else has the problem. The issue doesn’t happen when editing the formula in Airtable box, it only happens when I copy the formula outside to edit it and then copy it back to Airtable. The editing box for formulas is way too tiny to be useful when editing long formulas. Interesting thing is also when I am editing the forum post here, the difference in characters shows when I am editing the title of the post here, but once I save the post, the characters look same in the title.

How can I implement such a formula in Airtable? // all fields in an Airtable table const allFields = [ { key: 'type', value: 'TypeOne', } { key: 'name', value: 'Some name', }, { key: 'description', value: '', }, ] // set in a field of the table const requiredFields = [ { type: 'TypeOne', requiredFields: ['name', 'description'], }, { type: 'TypeTwo', requiredFields: ['name'], }, ] let invalid = 0 for (let i in requiredFields) { if (!allFields[requiredFields[i]]) invalid += 1 } if (invalid) return '⚠️ Some fields are not filled out!' For now, I have to do something like: IF(type = 'TypeOne', IF(OR(name = 0, description = 0), '⚠️ Some fields are not filled out!')) & IF(type = 'TypeTwo', IF(OR(name = 0), '⚠️ Some fields are not filled out!')) But I would like to set just an array of required fields but I don’t know how to dynamically set a variable like at this point allFields[requiredFields[i]] (not a value of some pr

Hi there, I just need a little help to finish my workflow ! I want to put a status from the automatic field “Last modified time”. Formula is : IF(DATETIME_DIFF({Update URL}, TODAY(),‘days’) >= 13, “ :exclamation: ”, IF(DATETIME_DIFF({Update URL}, TODAY(),‘days’) >= 7, " :alarm_clock: ", IF(DATETIME_DIFF({Update URL}, TODAY(),‘days’) >= 1, “ :repeat: ”, IF(IS_SAME(TODAY(), {Update URL}), “New :rocket: ”))))) It works pretty fine when the field is “date” but won’t work when field is modified in “Last modified time”. Anyone can help please ?

I have a link field called Sale and a formula field called Status. What I want is for Status to say “For Sale” when the Sale field is empty, and for Status to say “Sold” when the Sale field is not empty. I swear I do try to search for answers in docs and previous forum discussions before asking here, and I’m so grateful for those of you who come through. From a previous discussion, I used this formula which helped part of the way… IF({Sale},{Sale}, “For Sale”) I just don’t know how to add the “Sold”

Hi, How can I color individual cells in a table? Thanks in advance!

When I enter this formula… IF({Book Type Entry},{Book Type Entry}, “Book”, IF({Book Type Entry},“Advance Reading Copy”,“Advance Reading Copy”)) …the formula field accepts it and all seems well until I go to add more to the formula and see it’s been trimmed down to just this… IF({Book Type Entry},{Book Type Entry}, “Book”) …and when I close the customize cell popup I see that the information it was supposed to render for the second part of the formula is also missing. How can I solve this problem?

Or better yet, a daily report of all the records that were deleted yesterday?

Hi, I work for a public television station and I’m creating a content database to store records of our productions, improve workflow and communication, etc. We have to submit descriptions for tv listings and the character limits have to fall in the range of 101-250 characters. I’m trying to create a formula that displays the number of characters and let’s the user know if the characters are below 101, between 101-250, or above 250. I find people need the visual warning since I can’t set a X amount of characters or character cut off. This is the best I can figure out so far, but it’s a little odd: LEN({Episodic Description}) & IF(LEN({Episodic Description})>250, " ❌ Too Long", " ✅ Good") & IF(LEN({Episodic Description})<101, " ❌ Too Short", " ✅ Good") For example, if some is under the 250 limit the Good pops up. If there isn’t a better formula I can definitely change the tag from " :white_check_mark: Good" to “Over 101” & “Under 250”. Any ideas? Thanks!

Hi Community, I have a table ORDER of n orders with the {fields} : order-id, product, quantity, delivery-date Airtable SHOP - Airtable Explore the "SHOP" base on Airtable. I am trying to use a script to group_by (product, delivery-date) in order to sum the field {quantity} of a group (total-quantity) Then: with Automation, create a record in a table GROUP-ORDER with the fields: order-group-id, delivery-date, product, total-quantity Example on how the results should look like, is shared in the link above. I’m a little knew to the Scripting App (and my skills in javascript are medium). Is this approach feasible? and how should I get started? I managed to group the fields with a script as in : I need help for solving a problem on the script block However, I am struggling to create a new group-order record in a separate table. Thanks!

Hi all, I have been searching for this answer and haven’t came up with anything that is clear enough thus guides me in writing this formula. Let me try to set it up… I have a multi-select column (call it column A), which is a list of months. I have another column (call it column B) that uses a datetime_format formula to show the current month. I want to write a formula in a third column that returns a value (nothing specific, whether it is yes/no, a number, etc.) if the current month (column B) is selected in column A. Is this possible?

I can get records sorted by some field like below const records = useRecords(table, { sorts: [{ direction: 'desc', field: actionField }], }); but how can I get records sorted by manual order?

Hi there, I am using a look up field in a formula (on another field). The formula is just CONCATENATING the look up field, but I receive an #ERROR! when I try this. Is there a way around this. Cheers! Sam

IF(Paid>0,({Profit}/{Paid}*100),"") This is my current formula after playing with it for some time. I am calculating ROI, with many of my records containing no initial investment, which left the result of {profit/paid} as infinity on those lines. I want to easily calculate my average ROI, so I can’t have the infinity records. Initially, I thought I could add to the formula IF({profit/paid}=“infinity”,""), but that formula failed, so I ended up with the above. The problem is, because of that formatting, I now cannot format the formula to show results as a %. Any ideas?

I’m trying to batch update records using the Scripting app. I’m able to update one-by-one using this script: // set the table let productsTbl = base.getTable('PRODUCTS') // get the table records let products = await productsTbl.selectRecordsAsync() // loop through the records for (let record of products.records) { // set variables to the record values let recordID = record.getCellValue('ID') let option1Name = record.getCellValue('Option1 Name') let option1Value = record.getCellValue('Option1 Value') let tags = record.getCellValue('Tags') if (option1Name === 'Pattern') { let id_pattern = '[pattern:' + option1Value + ']' + 'id_pattern:' + recordID + '_' + slugify(option1Value) let newTags = id_pattern + ', ' + tags await productsTbl.updateRecordAsync(record, { Tags: newTags, }) } } function slugify(string) { const a =

Hi There. I’d appreciate getting my Emailed Prefilled Airtable Forms Link to sync up with my AirTable Data. I have 4 Fields being prefilled into an Airtable Form. First Name Last Name Email Address Mobile Phone # I wrote a formula (with the help of the amazing Airtable Community) to pre-populate filled fields into an Airtable form. The link for the form with the pre-populated section works perfectly in my AirTable Base. The problem arises when I use Airtable Automation to email the link. The emailed link is different from the link that was created in the Airtable Base. I’d appreciate any help to get the emailed link to match the formulaic link shown in my Airtable. Thank you. Result in AirTable: https://airtable.com/XXXX?prefill_First%20Name=Mickey&prefill_Last%20Name=Mouse&prefill_Email%20Address=111%40111.com&prefill_Mobile%20Phone%20%23=(111)%20111-1111 Result when Emailed: https://airtable.com/XXXX?prefillFirst%20Name=Mickey&prefillLast%20Name=Mouse&prefillEmail

Hello! I’m an Airtable novice. I’m building a membership database for a therapy dog nonprofit. We send dogs (with their human handlers) to visit with people in hospitals, jails, nursing homes, etc. I’ve created a dogs table and a humans table. I’ve linked the dogs and their humans. How do I assign attributes to a team (consisting of a specific dog and a specific handler)? For example, we evaluate a dog-handler pair, or team, to make sure we can send them out safely. I’d like to record the date on which this team completed their evaluation. Thank you!

Hey good afternoon, I wanted to create a view that gives me all the records from the Current Month and Current Day in history. So today being October 28, 2020, I want to be able to dynamically pull all the previous years for October 28th. I am sure I could add a month field and a day field and manually change them everyday as a filter in my view but wasn’t sure if there was anyway to dynamically pull the current date to get the historical values for the current date. Thanks in advance for any suggestions.

I am looking at attempting to combine the two functions into a single input. The second is to catch jobs that go overdue earlier. Original Question: Formula to track days past a set date, multiple outputs Justin Barret provided this code: IF( AND( NOT({Work Completed}), TODAY() >= {Due Date} ), IF( {Days Elapsed} >= 84, "12", IF( {Days Elapsed} >= 56, "8", IF( {Days Elapsed} >= 28, "4" ) ) ) & " weeks+" ) and I was able to use that to create this: IF( AND( TRUE({maintenance job}), TODAY() >= {Due Date} ), IF( {Days Elapsed} >= 14, "2 weeks+" ) ) )

Hi Everyone My question is can you use Page Designer to design different page layouts for Use within the same base? Eg. I want to issue invoices direct from AirTable. I have sorted that ok and everything is going well so far. Is there a way I can use Page Designer to be able to use the same table as I use for my invoice design to print Say a list of clients overdue invoices or something similar while using the same set of data that my invoices page design is based on?