Solved

Hello, I'm trying to merge records in my table when 3 criteria match. I've been able to identify which records are duplicates, but I am having trouble merging them. Logically I believe my code should do what I want it do, I am not super familiar with asynch and I think that is what is messing me up. When I run this code it throws: Syntax error: await is only valid in async functions and the top level bodies of modules [script.js:33:9] I've been reading through documentation and discussion posts, but I'm not sure what is happening to cause it to throw an exception. Any help would be appreciated.   var table = base.getTable('Testing_500'); var query = await table.selectRecordsAsync(); //let records = query.records; let upPN; let upEM; let upID; //identify duplicates let duplicates = query.records.filter((record) => { return query.records.find((potentialDupe) => { let fName = record.getCellValue("First Names") === potentialD

I am new to Airtable. I have create a Form to capture Emergency Contact Information. When I shared the link, the end user must register to complete this form. Is there a way to have the employee complete form without having to create an account or register?Note - I am currently using the Free version of Airtable. I don't know if this make a difference.

Hi. I have a very basic password system that uses letters to denote numbers. The numbers come from a client's DOB.I have a date (DOB) field and another field using DATETIME_FORMAT to only show the numbers (DDMMYY). That's all fine.I would like to have a new field that displays a particular letter for each number - to create a very simple password. Lets say: 1=a, 2=b, 3=c, 4=d, 5=e, 6=f, 7=g, 8=h, 9=i, 0=jIs there a formula that would do this please? 

Great session today! I really enjoyed it! I wanted to follow-up to clarify my question and see if others have ran into the same situation and if anyone knew the solution! So, I have an interface form with the new form builder. Within that form, I have separate groups based on what a user selects initially -    1 - User puts in base info2 - User selects the option3 - This group displays when a specific option is selected in 2 (So it's conditional) My question is.. when I added a field in the group 3) (In this example "Hit Time"), I can't seem to be able to "re-add" it to another group. So say that user selects a different option for 2), but I use that one field "Hit Time" for multiple options in 2. When it is in the group, I can't use it in another group.Is there a way to do that? Or is the current solution to only group specific fields that are not required for different conditional options. Thanks all in advance for the help!  

Dear all,I'm using the calendar in the interface; in the month view, if there are more items, accondingly to the zoom setting, only some items are visible, while others are not visible, even though the label "+ x more" is present.Even by clicking in the day the other items appear only for less than 1 sec, after the click.Are there some ways in order to see the title of the items withuot open the right summarize column? Thank you. Best regards. A. Borriero

Hi,Every time I try to convert the multiple select field (automatic field from import) to Date (with time included), I get this message that some cell data may be cleared. And indeed, most of the cell data were cleared. I don't understand this as my data is clean it is a standard 03/05/2023 7:00:00, 10/05/2023 7:00:00, 17/05/2023 7:00:00, etc As you can see, the three rows show up blank after I try to convert to Date (with time) field.This is the original data after importing from Excel sheet. Would appreciate any advise on how I could convert all data successfully. Thanks!  

Hi there, I am trying to create an If/or formula and got it to work but I can't get the formula to be blank if there's no data in a field. I'm sure that makes no sense. Here's an example: Let's say I have a small list of produce in a column. I want to create a formula in a new column to give me the category of produce either as a fruit or as a vegetable. I got the formula to work but if no produce has been selected I'm still seeing "Vegetable" in the formula column and I want it to return a blank value. Any ideas? Here's the example formula. Thanks in advance!IF(OR({Produce}="Grape",{Produce}="Apple"),"Fruit","Vegetable") 

In the Airtable interface it came to my attention today that Read Only users can see all other users who have access to the same interface. I simply assumed they couldn't share or see this information.Does anyone know how I disable sharing for read only users, or the ability to see who it is shared with?This is totally work stopping for me on my current project. In fact this is preventing me from wanting to use Airtable interfaces for any public facing work, even for people who have paid Airtable accounts. 

I made an automation to create reminders in my Google Cal. They’re all-day events, which by default don’t show you as busy, but when they’re made through Airtable they’re ticked to show as busy. I couldn’t find a field to change this in my automation. Can I make it so my all-day events made from automation don’t show as busy?

I have a large multi-select that I then need to turn into a list format. I did the usual substitute the comma for a line break but unfortunately the items in this multi-select (that I can not edit) also use commas so now it's adding commas where I don't want them. Is there a way to get the formula to avoid those commas but not the others?  SUBSTITUTE({Plot Themes},", ","\n")

Please see screenshot below. I have domain names in one field and want a clickable "click here" text in another field that hyperlinks to the domain name, how can I do this? Thank you 

Hi all!I've been scratching my head and couldn't solve the problem quickly, so I'm asking for your help.I need to display a progress bar with the percentage of completion of a specific task, under which there are subtasks. In order to understand the percentage of task completion, we take the subtask as the source. If out of 10 subtasks only one is completed, then we get 10% of the main task completed, a certain run rate.It looks like a similar task can be implemented through a formula, but I was unable to write a correct formula using if, counting and division.How can this case be solved?

I'm running into race conditions some report summaries automations, and am wondering if anyone has come up with a better solution than I have in placeI have a table that is automatically updated when a user adds values from a csv report. I need to summarize that report with an automation. I have a multi-step automation that does the followingTriggers when a record enters a viewChecks to see if the date of the report is already listed in my summary table with a "Find Records" stepIf "Find Records" length is 0, it runs a few scripts to do math on the raw data enteredHowever, I've found that the automation runs for all records in the view simultaneously, rather than one at a time, so I'm running into race conditions where multiple lines are created for the same report. I know there are other solutions such as running the automation from a button click or at a scheduled time, but those are not options for me at this point. Any advice?

Is there a way to share a script between a record-create automation and a record-update automation?

Hi- are there any updates about this topic?We want to share only some tabs with different people. Thanks

Looking for a solution for a public view where I would like to share information partly. To be exact - I'd like to hide the last characters of the text string by replacing the last letters with stars ***Tried to look up for ready solutions but had no luck.Would appreciate any help.

Hi. I'm sorry if this sounds a bit vague, but what I'm trying to do is this:I conduct sessions with students and each session is a record. At the end of a month I have a table with multiple students and their sessions. Some students will have 4 or 5 sessions per month.What I want to do is find all sessions for each student, then extract the 'date' and 'duration' fields data to make a list of all the sessions the student has had in that month. I will then use an automation to email this information.I'm not sure where to start with this one. Is there a nice, elegant way to do this? 🙂

I'm trying to move attachments from AT to Google Drive using Make. For some reason when the scenario runs, the files that get created in Drive are invalid. These are small png logo images and when I try to open them in Drive I get an unrecognized file format error. Here is my Make setup:Is the AT attachment URL field the correct one to be using?

Hello! I'm trying to avoid using Google Forms to keep everything in Airtable, but have some trouble creating the matrix-like question in Airtable Forms (check attached image). Is there a way to create this or is it impossible? Thank you!

Extremely frustrated with the lack of communication from Airtable.  I've spent 6 weeks trying to get several questions answered.  We had the same experience when trying to onboard with Airtable.  Unfortunately we stuck it out and continued with Airtable instead of going in another direction. 

Hello, I have a question that I am having trouble finding an exact answer for; my company manages week-long events at a large scale and I'm trying to determine how much it would cost to allow several temporary collaborators on a specific base for a week.I know that Airtable bills per user prorated by day, so does that mean if I bring in 5 users for 5 days and the monthly cost is $24/month, would the answer be $0.80/day per user*5 users*5 days= $20 total added to the invoice? I hope this makes sense, let me know if you need any more context! 

I'm pasting a single-line text field ("Whisky Name") into a linked field ("Link to Summary Page"), and it used to paste all the names across into the linked field. The action was that if a name matched with an existing one, it linked it to the existing one and if it didn't, it created a new line in the summary table.When I pasted all the single-line texts across, it matched the existing ones and left all the ones that would be 'new' items blank. I know this because if I manually select the link cell, type in the name (nothing shows up), and 'click create a new record' it works. In that case, if I have a duplicate further down and I try the copy-and-paste method, it works because it now has a match.Has something changed?

I am creating a form for our website that I will need external users to fill out. I want to minimize user input error so I have created a table with state names/abbreviations to link to the form. When they start to fill out the state it populates options they can pick, but is there a way to make this look better by eliminaing showing where the data is going (it shows 'Leads' the table where it is going and I don't want customers to see that). Or is there a way to easily upload the state abbreviations that I have in the table without manually entering them all as a single select drop down option?Last question, I love the look of the interface form but from what I can tell this is not something you can share with outside airtable users via our website? Other than having them creative an airtable login, is this correct?

I'd like to send an email to a user when a Linked field is updated, but ONLY send the new updates, not the entire contents of the field.I'm working on a job board. I want to email the organization that posted the job every time a new applicant applies to their posting.I have two Tables – Users and Job Postings. The two fields are linked so that each Job record shows the Users that have applied to the job, and each User record shows the Jobs they have applied to.It seems like I can only email the ENTIRE "Users" field to the job poster through the automations creator. Ideally, I would send a daily email to the job poster with only the NEW profiles that have applied to the job.Any help here is appreciated!

Hi,I have a currency column that is being auto-calculated, and the way Airtable is summing the numbers is sometimes incorrect - off by a few cents.I suspect this is because the auto-calucations sometimes come from .00 or .000 fractional ownership of certain goods, so when Airtable sums a bunch of those at once it's somehow dropping or carrying over fractions of cents...If I copy and paste the whole list of numbers in Excel, for instance, it gives me the correct total. So I'm searching for a way to somehow convert the auto-calculated field to a plain number field which will hopefully only give me the sum of the numbers as they are.Any suggestions for how to to this? Thanks!