Solved

I built a small table and am accessing it via Airtable API. Any tip as to how I can randomize the results I’m getting? Meaning: for each API call, get the value of a different row. Cheers

Hello, What would be the easiest way to configure a formula that combines all of these? IF({Request Type}=‘New’, DATETIME_DIFF({DCML Issue Date Lookup},RequestDate,‘days’) IF({Request Type}=‘Major Update (Procedure Change)’, DATETIME_DIFF({DCML Rev Date Lookup},RequestDate,‘days’) IF({Request Type}=‘Minor Update (Formatting, Spelling, Grammar, etc.)’,DATETIME_DIFF({DCML NCC Date},RequestDate,‘days’) IF({Status}=‘Incomplete / Closed’, DATETIME_DIFF({Status Last Modified Date},RequestDate,‘days’) I tried a formula that combined the first two, and the system accepts it, but it doesn’t return anything. Thanks :slightly_smiling_face:

Slowly piecing together a Regex script in the Scripting App, but I’m stuck with table.updateRecordAsync not reading the field that’s active in the loop. If I hard-code the field name in with quotes it then works as I hoped, but if I use the field.name from the loop, it won’t parse. So the below works (but isn’t very useful as I’m trying to cycle through fields rather than hardcode a string); await table.updateRecordAsync(record, {"🔍Test_1": String("test1")}); “test1” will successfully write to each record for field “ :mag: Test_1”. But when I swap out the hardcoded Field name string with field.name it unfortunately fails to parse. await table.updateRecordAsync(record, {field.name: String("test2")}); Running Console log on field.name, it comes up as expected - so I’m not too sure what I’m doing wrong and will appreciate some help. Full code below - and keep in mind that I’m still learning Javascript - I’m finding it tricky to break my old coding method and habits to learn the new techn

I had an automation that when I created a new record of a participant’s information into a time point of our survey (ex. baseline, 3 month, 6 month, etc.) that it would find records with the same participant ID and link them together. I have separate tables for each time point, and the initial automation I had working was “when a record is created in “baseline”, find records in “Master” where participant screener ID is screening ID from baseline, update records in Master with Baseline”. This automation was working perfectly fine for two weeks. I tried to enter some data yesterday and all of a sudden it’s stopped working. I get a message of “invalid filters” for the “find records step” for some reason now. I haven’t changed anything about the automation itself or the tables involved in this automation. When I test the automation, it finds the records perfectly fine but when I run the automation in practice, it says invalid filters. I’m not sure what’s wrong or what to do. Pictures inclu

I’ve been trying to figure out a way to count records and increment the number in a field and found this great solution by @Kamille_Parks which does the trick. But I’ve run into a couple of issues which I’m hoping someone can help me with. In my case I’m tracking change orders related to a job and would like to make each new change order n+1, relative to the job. So my Change Orders are Job#-1, Job#-2,Job#-3,. This solution does what I’m looking for but breaks if the user duplicates the record, which we’d like to do. The trigger here looks for a blank value for the count # but if you duplicate then the count field value is not blank, so the trigger fails. I’ve tried a bunch of things but haven’t figured it out. Any suggestions out there? It doesn’t seem possible to test to see if one field is = to another field, which could have possibly helped here. Update counter when action is triggered Automations [Screen Shot 2021-07-13 at 12.17.11] [Screen Shot

Hi, I want to send a message to a Slack channel and notify the members with an @here or @channel. Currently, the automation message sends a plain text version of @here or @channel. Is there a way to make this function as it does in Slack normally?

Can I have a setting that when I add subtasks for them to automatically have the start and end date of the task they belong to?

Hello. I have a lookup field which lists the age groups that are related to all the linked records. I have a formula field which I’d like to show ‘Senior’ if the lookup field contains Senior, ‘Intermediate’ if it contains Intermediate (but not Senior) and ‘Junior’ if it only contains Junior. The formula I’m using is this: IF( FIND( ‘Senior’, {Lookup Correct Section} ), ‘Senior’, IF( FIND( ‘Intermediate’, {Lookup Correct Section} ), ‘Intermediate’, IF( FIND( ‘Junior’, {Lookup Correct Section} ), ‘Junior’ ) ) ) If it is listed “Intermediate, Senior” then the formula works perfectly however if it is “Senior, Intermediate” then it returns Intermediate (even though Senior is in there). I’m sure it’s something really simple that

I’m using Python API Wrapper. When I use get() method to retrieve a record that contains a ‘Link to Another Field’ Column, the method returns the linked record ID. I would like to get the linked record name instead. My next step will be to do a 2nd operation to look up each record (by id) and get the name. But I wonder if there is an easier way that I’m overlooking. If not, any recommendations about an efficient way to do this with Python / Pandas would be appreciated.

Hi, I’m trying to build an IF statement with an OR in it but I’m not getting the expected result. I have created a simple table for tracking hours worked and calculates overtime. Columns are as follows… Date - is just the date in question. Calculate Weekday - WEEKDAY(Date) So far so good. Because the standard work hours vary from day to day (7.5 for Mon, Tue, Wed, Thu / 7.25 for Fri / 0 for Sat, Sun), I wanted to create an IF query to return the correct hours for that day number. Rather than going overboard with nested IF, I tried to simplify to the following, but the OR in this doesn’t seem to be doing what I expected… IF(WEEKDAY(Date)=5,7.25,IF(WEEKDAY(Date)=OR(1,2,3,4),7.50,0)) From what I can see, the day 5, 0 & 6 work okay. But my problem comes with the OR as only day 1 works; the rest come back as 0 hours. Am I misusing this function? I was expecting the OR to then return 7.50 fo all of 1,2,3, and 4.

This question also exists in Integromat-Airtable integration: Create record with synced linked record -- record id not found - Stack Overflow I’ve created a scenario where a customer submits an order form jotform. In airtable, I have an “Order Line Item” table in my “Sales” base that links to a record from the “Inventory” table from the “Inventory” base. This linked record column is called “Inventory ID”. It also has a linked record to my “Order” table in the “Sales” base. –order line item table– In integromat, I have a “Create Record” airbase tool. When I manually put in the Order ID, that creates the new order line item record no problem. But when I manually put in the Inventory ID record, it says it doesn’t exist. And, I’ve tried both the POST API and the Create Record tool. –synced inventory table– –integromat scenario excerpt– Is this a bug in the airtable API?

Hi all, Please see the screenshot below - I’d like to display a message in the Is Absent Today column if today’s date is among the dates in Absences. Currently I’m using the following formula but it only works if there’s a single date: IF(DATETIME_DIFF({Absences}, TODAY(), 'days') < 1, "Yes", BLANK()) Any help is much appreciated!

Hello! Here is the situation: I have a free plan and have created an Airtable base that I plan to embed on a website that is public facing. I noticed, when I look at the embedded view preview, that if you hover over the views on the left hand side (e.g. gallery view or grid view) you can see my name and email. Is there a way to anonymize this so that users of the Airtable can not see my email address? Thanks for your help!

Hi, Sorry in advance for the long post, but I think it may be important for context. I’m creating a base for HR and figuring out the best way to structure the base. Here’s what I’m trying to accomplish and my dilemma. I have two entities (still figuring out if these should be separate tables or within the same table, which is why I’m referring to them as entities). (1) Employees and (2) Onboarding tasks. Employees will have their own properties so fields like name, position, date of joining, and a ton of other fields. Onboarding tasks also have a bunch of properties such as task description, applicable to (FTE/PTE), responsible for task (HR or Employee since HR has to perform some of the tasks and there are other tasks that the employee must perform) and a bunch of other onboarding task fields. Also, there are about 60 onboarding tasks, so that number is a factor in my design approach. My approaches are: Approach 1 Employees in one table. Onboarding tasks in another table (listing out

Hi there, We use email automation to send emails include a grid with records in the email body. How do I include a link to those records in the grid so that email recipients with Airtable accounts can click the referenced record and immediately be taken to the correct record to update? thanks!

Hi everyone, Right now I have following options to share: Using “Share” button: This only allows to share entire Workspace or entire Base. Using “Share View”: This option creates a view where I can’t provide the ability to accept comments. But what I want is to share a view with the ability to get comments on the records I shared. How can I achieve this? Looking forward for some guidance.

Just added the Scripting app and am trying to write my first script: to create a new field of hyper-linked text (“Opportunity”) from existing text (“Program”) and url (“Website URL”) fields in my table. I found this suggested solution and adapted it to my table like this: The problem: it works on only about 10 percent of my records: I’d appreciate any suggestions for how to make this work for all records, or an alternate method. What is the significance of “selectRecordsAsync” showing as struck through after I run the script? Is this a problem with the script not waiting for calculations? This is my first experience with Javascript.

I am trying to create a booking tool for oral examination. I managed to create a form where the student can select a hour of his/her choice (in a list) and when submitted, that time slot is no longer available for other students. So far so good. But I noticed that students can add+ multiple slots; I would like this to be limited to 1. How can I fix this? Additionally is there a way that students can only submit the form once?

Our organization has several different bases for the different functional areas (sales, marketing, operations, product etc). Each of these bases has linked tables for projects and tasks. I am looking to create a master base with tables that merge all of the tasks, and all of the projects from the other bases. I can see how to sync tables separately from other bases but I’d like to be able to merge them into a single table. Any help would be appreciated.

Hello! I am trying to troubleshoot a formula field. Currently I have this in the formula field: CONCATENATE({Part}," | “,{Objective},” ",{#}) to create the following: Looking at the first record, the result reads: Part 1: Competent Leader | Heart 1 However, I would like create a search that allows the final formula to read as such: Part 1 | Heart 1 I want it to be able to search the {Part} field, but not list the entire title - if that makes sense. Seems simple enough, but I had problems using the Find or Search field.

Hi Everyone, I have been trying to accomplish an error check and I have syntax issue on the below formula. May I please know what is the issue with my formula? Thank you so much in advance. IF(AND({est_filing_date_range_start},{est_filing_date_range_end},{actual_or_estimated}!=BLANK())AND({review_type}=BLANK()),“ :stop_sign: ERROR…review_type CANNOT BE BLANK when est_filing_date_range_start, est_filing_date_range_end,actual_or_estimated fields are populated”, ",“ :white_check_mark: GOOD”)

I am attempting to create a Form to standardize intake parameters for a receiving team. I would like to know which user is responsible for submitting each record. Currently i am unable to find a way utilizing the Form view to have the user ID auto populated when that user accesses the form. Is this something that is possible. The only work around we have found for this is to create unique prefill URLs for each user, which is not ideal and still allows the user to manually modify that info.

Hello all Here is my situation: I have collaborators working on TableFoo on a certain amount of items. When they are done on an item, they change the status and other collaborators take over on it. This other team is working on TableBar To ease the process, I need to add an Automation action that looks for this status change and creates a record in TableBar whenever it’s triggered. Problem is, one of the field I need to transfer over is a MultiSelect Field and when I use the createRecordAsync() function as follow, I receive an error let newRecordID = await TableBar.createRecordAsync({ "Tags":TableFooRecord.getCellValue("Tags"), }); The error is obviously that the “Tags” field of TableBar does not have the same choices as TableFoo. I read that the Automation is not able to use ‘typecast = true’. So I thought “fine, I’ll just add step that updates the option of this field in TableBar to have all from TableFoo and I’ll be good”. Turns out that the methods to do this

I have a script that has been in production for months and just recently the script is failing on the selectRecordsAsync() function… let config = input.config(); let tbl = base.getTable('Status'); let qry = await tbl.selectRecordsAsync(); for (let rs of qry.records.filter(id => id.getCellValue('Status ID') === config['Status ID'])) { <snip> break; } In the text editor the function selectRecordsAsync() the text is formatted as strikeout and I’m seeing this error message… ERROR TypeError: Cannot read property '0' of null at <anonymous> on line 4 at main on line 4 Can anyone shed some light on what’s going on?

Hi, everyone! I’m sure this has a simple answer, but as a non-developer - I could use some help! I currently have a few webhooks for Zapier and Integromat programmed into button fields in my base. Their function is working just fine; however, each time the webhook is sent, I get a success message in a new window. I appreciate the confirmation, but when I am processing hundreds of records in one sitting, this becomes extremely annoying. Is there any way to get my webhook to run without the success message? Or any recommendations for alternate solutions? I know it’s possible to have a button or an automation run a script, but I don’t know how to create a script to send a webhook. Thanks in advance! :slightly_smiling_face: