Other Questions

I am trying to use a script in order to identify duplicate records in a table Description: Duplicate record field = Participant Name Desired outcome: When a duplicate record (repeated Participant Name) is created in the table labeled “Ops: Program Hub” Add a CHECK in the field “Duplicate” THIS IS THE SCRIPT I HAVE - and it is currently not working. I am VERY new to scripts and would appreciate any help! // the table to check let table = base.getTable(“Ops: Program Hub”); // the record we’re searching for duplicates of // we need to create a ‘recordId’ input variable connected to a record trigger let config = input.config(); let recordId = config.recordId // the field to save duplicates in. this should be a self-linked record field let duplicatesField = table.getField(“Duplicate”) // query the table and find our record according to its id: let query = await table.selectRecordsAsync({fields: }); let record = query.getRecord(recordId); // search for duplicates let foundDuplicates = q

Hi there, I’m learning scripting to help my company parse its Airtable rich-text fields to HTML. It’s a big ask and I’m looking for guidance (my boss can’t afford this solution). I installed the Script extension and am watching the official help videos, but the output from either a console.log or output.text doesn’t match the example values from the API help page. I.E. From Output.text(fieldString): (from the preview window in the scripting editor) The SO will: Set up delegated Google Account to support the SO with delegation of ongoing security tasks From API Example page: “The SO will:\n1. Set up delegated Google Account to support the SO with delegation of ongoing security tasks \n” I read this official Airtable Markdown article, but found little help in how I can work with the contents, so that I can eventually learn the Regex expressions to parse them into HTML. Any help on how I can accomplish this within the Scripting extension? I feel working with the API on some local develo

So in search extensions say I search up like “walmart” and all the Walmart tabs come up how can I print that?

Hello Dear, I using Airtable pro plan for nearly 4 years, paying at once, so after a long time, I miss the mail to pay the amount overdue 5.65 USD. When i realize the pro plan had already been downgraded to the free plan, I can not pay the 5.65 USD overdue, i have to pay the annual fee, ( lost all creadit remaining). So someone please help me to pay that overdue or do i can get back creadit remaing . Thank you

I am building a CRM. I have one table that is all leads. I then want to use zapier to send over interactions from my phone services to another table for interactions points. I have it set up as a linked record look up, but Zapier isn’t liking this. I do want these records to be linked. Thanks!

Hi, We have previously had a “form” from within the base as an “Extension” - however as of last week the message we are now getting is " This website does not allow embedding". Just wondering what has changed? And are we still able to use our created forms (view) as an extension? Cheers, Jenna

Hi - So we are a camp and I’m trying to tally the amount of children attending a certain week. In AT they have 1-8 or Full listed as their enrolled sessions all as a multiple select choice. How and where can I have tally’s as so how many in that specific group are coming weeks 1, 2 and so on?

When linking tasks to predecessors/successors in the gantt view, it will show up in table view. But when I add from the table view, it will not show up in the gantt view at all. The field type in the table is “link to another record”. How can I fix this?

I have a pre-existing order number in the format of “LS003456” that I would like to auto-generate. I’m using a second field with autonumber and then a formula like this: CONCATENATE(“LS00”, AutoID) which gives a result of: LS00185 LS00186 LS00187 Is it possible to modify the formula so that there are always 6 digits after the “LS” and any leading zeros are maintained? My end goal is to have a sequence like: LS000001 LS000002 LS000003 … LS999999

I have one table with a list of products and their delivery date. I have another table with a list of marketing campaigns and a “Go Live Date” and a “End Date”. I simply want to have this information together in one view so it’s easy to tell what products are getting marketing love and which are not. But, I can’t seem to find a way. The point is to on any given week to see what marketing activities are occurring and what products are arriving in store. Any suggestions? Thanks in advance!

Hi all – I am simply trying to calculate the average of a column containing numbers produced by a formula. It is a “Formula” column, but the output of the formula is a number. The database contains all of my projects, and the column in question calculates the number of “days to complete a project” by subtracting the date I was assigned the project from the date I completed the project. I have about 50 rows in the database (one for each of my projects), and I simply want to calculate the average of the column so I can keep track of how many days I am taking on average to complete projects. This is something that would be very simple to do in Excel, but something that I’m really struggling to figure out how to do in Airtable. I see that it’s fairly easy to find the average of a column formatted as “Number” by using a grouping and then selecting Average from the dropdown menu. However, this does not appear to be an option for columns formatted as Formula, and I fear that that is the probl

Hello, I’m using a template for tracking multiple projects across different teams and workstreams. In my Gantt view, I cannot get a critical path to show to save my life. I understand that the path will only show related tasks that dont overlap, but I have some pretty straightforward waterfall dependencies and still no path. Here’s a screenshot: I know the show critical path option is on. Not sure if this is because of multiple projects or the view being by quarter. Thanks for your help.

I want to parse text date entries from a single record into calendar date entries so that a calendar view can be used to visualize the dates. We have our sales records entered by product, so each individual product gets a separate entry, with multiple “dates”. For example: Email Ad | 1/1, 1/2, 1/3 (etc). The “dates” are referencing another table with text records created for each day of the week that product can be sold. I want to be able visualize all of the dates that product is sold on, and see which record it is. So on a calendar I would see 1/1: COMPANY A, COMPANY B 1/2: COMPANY B, COMPANY C (etc) an example of a sales entry: I am trying to set up an automation whereby as soon as a product is entered with the dates added, new records for each date are created on another table (so first entry is 1 product with 5 dates, then the automation creates 5 matching records for the 5 dates as individual calendar dates, so the calendar view can be used). So, what I need is a way to parse

Hi Airtable A few of the projects I really want to take on using Airtable are at a blocking point because they involve in-app scanning of our company ID badges which are encoded with CODABAR. CODARBAR, as far as I can tell, is an unsupported barcode type (using iOS app FWIW). Is there a way for me to add compatibility for this barcode on my end or is this only solvable in your development stack? Thanks ever for any thoughts and for such a great product overall!

Hello, I can not solve these steps, to see if you can help me. I am making the rules with Make. Fill out and send form (1) from Arengu Return a “thank you” email using gmail, a PDF will be attached From the mail sent, there will be a link to complete another form (2) in Arengu Once the form (2) is completed, a new email will be sent with the content of the form (2) generated in a doc in gdrive, which will have a link to modify the answers in word and another to schedule a meeting in gmeet. The form information (1) and (2) have to be unified, and I think this part is where Airtable comes in. Any suggestion? Thank you in advance!

I’m trying to initialize the Sendgrid block. I get an API key from the Sendgrid site. When copied to airtable, it’s invalid. On the API key page, sendgrid mentions I need to “verify sender details” before using the email API. I verified an email, but the popup still occurs. Maybe this is a reason. Unfortunately, Airtable posts won’t allow supplementary images. Thoughts on why this happens?

I used to be able to use my bases, but over the last few weeks the next steps/ready to use your base? pop-up has become impossible to move. It pops up when I open a base and covers half of the base, but the top of it goes under the toolbar and I can’t move it. So I can’t close it. I basically can only see a few columns of my base at a time. I’ve tried different browsers and it’s the same. I had to get out of the base to even see the help options. Also trying to paste an image showing what’s happening but having unusual problems with that too. Maybe you’ll see it below? Thanks!

Hello, I know Airtable recently did an update were they are addressing a security issue by making the share links expire but come to find out its making my profile link images not show to my users because the share link is expiring does any one know a work around this, this is really effecting the functionality of my apps can i just keep is the way it was or make it were it does not expire?

Is there a way to view estimated and actual start / end dates for a plan in Gantt view?

Trying to create an automation that will send an email on a specific date when a field in the base is blank. I start the automation as “at a scheduled time” and when creating the conditional group, the only option I have is use data from “at a scheduled time”. I need it to be able to access the base and set the condition to the particular field.

I am a freelance designer that uses the free Airtable account with my clients. My clients have access to the Airtables I have created as an editor, so they can add text and images to projects I am working on for them. I want to do more automation and integrate some apps, so I can see I need to pay for Airtable. My question is, what happens to my clients once I move to a paid account? Do I have to pay for a seat for them to be able to edit my Airtables? Are they only able to view my Airtables with a free account?

Hello, I have a table where I track contractors for attendance within an SLA. I have SLA Due date and time and Site Attendance date & Time. I have then have a formula column which tells me if the job is pending, Missed or Met. What I now need is to calculate % of SLA being met for each contractor, Can someone advise a good method for achieving this? Jason…

Hi there, I noticed that the HTML attachment preview seems to be unable to render Unicode characters. Characters like typographic apostrophes or em-dashes turn into garbage character sequences. (See attached screenshots.) Is this a known bug? Is there a workaround available?

Hi there, I’m trying to setup a data base for a Webflow project and I need the following to happen. As you can see on the image above, I have a column for cities, and another for city ID. Both are dropdowns including different options where only 1 can be selected. The city column includes things like London, New York, etc. and the columns City ID has an ID that is associated with a city. Is there a way to link both columns so that when I select London from the City column, automatically selects the ID in the City ID that is associated with London? Thanks

I have a base with all our members and there details in. In one field we have numbers, in the other field we have a field with a Formula that works out the membership number. Our membership changes and sometimes people leave. When they leave we delete them from the Base. When we delete the row they are in, the numbers all change again, and this changes all the existing member numbers. Is it possible to delete a row but not change the other rows numbers.