Other Questions

I have a table with a linked field to another table. The linked field refers back to the primary key of the table I am linking back to (eg a unique project number) but that is just numbers and it doesn’t mean anything to most users when searching. Is there any way I can have the linked field search for the name of the project rather than typing in the unique primary key to the record I want to link back to? I have added a lookup field but this only pulls in the project name field once I have linked back using the link field by entering the corresponding unique job number,

Hey all, I've created a form to solicit website feedback.I will place it in our CMS on *every* article we run - thousands and thousands of pieces of content. I want to auto fill in one field ('sourceurl') with my own javascript snippet, which works, but the problem is I can't target the field - every time you load the form, it dynamically generates a new ID for the input field. We have enterprise support (and I've even spoken to our rep and put in tech requests). I've also posted here and was told my solution should work, but at that time, I didn't realize the IDs generate fresh, so I am still trying to get this working.I've even used the 'field manager' which lists a static ID for the field, but this static ID is not used in the embedded iframe as far as I can tell.

I have a script, creating records from an API. The API data works fine. Instead, I'm having trouble entering a Linked Field value. I understand it needs to an array, but I can't get it to work.I have one table of Schools. The script loops through the schools, does an API call using the school ID, then creates records in the Courses table."school.id" returns the Airtable record ID correctly in the console log. I need that to be entered in the School Link field at the end. Please let me know what I'm missing.  let schoolsTable = base.getTable('Schools'); let schoolsView = schoolsTable.getView("Schools View"); let schoolsList = await schoolsView.selectRecordsAsync({fields: ['Account ID']}) //get school IDs for (let school of schoolsList.records) { console.log(school.id) let currentCourses = await remoteFetchAsync("https://XXXX", requestOptions); const currentCoursesData = await currentCourses.json(); console.log(currentCoursesData); //create records for c

Ive tried doing this and when I do it loops through and keep updating the one and only record, doesn't add the record if the Client_no doesnt match // @ts-nocheck var sourceTableName = base.getTable("1_Import"); var destinationTable = base.getTable("2_Enroll"); let createdDateTime; // Calculate the date range for last month var currentDate = new Date(); var lastMonthStartDate = new Date(currentDate); lastMonthStartDate.setMonth(currentDate.getMonth() - 1); lastMonthStartDate.setDate(1); // Starting on the 1st day of the previous month var lastMonthEndDate = new Date(currentDate); lastMonthEndDate.setDate(0); // Ending on the last day of the previous month console.log("Last Month Start Date:", lastMonthStartDate.toISOString()); console.log("Last Month End Date:", lastMonthEndDate.toISOString()); var qry = await sourceTableName.selectRecordsAsync({ fields: [ "Wholesale_Partner_Name", "AFF_Agents", "Client_Name", "Client_No", "Affiliate_or_CNI", "Status", "Termination_Dat

Hi all!I'm currently encountering a problem when I run a script (it is a script that was already made in another base that I tried to adjust to a new base). The script allows me to import data from a third-party excel sheet into my base. I mapped all the fields I needed from the excel sheet into my base (I don't need them all). Here is the info from the excel sheet that is supposed to be created into my base :And here is the error I am receiving while running the script :Here is my script at lines 91 and 114 :I created the field -NBxajiiiCAqstlW9O7- just to see what the script what doing. It is putting ''Création du donateur'', which appears at line 91, into the field. What I need is for the id numbers that are shown in the excel sheet to appear in the corresponding fields in my base (idContact and idFundraisingDonation).Thanks for the help!David 

Hi all,I'm using Airtable for a recruitment company. I have a table for candidates and for job listings. I want to be able to enter a new job with a salary, location and function and then have candidates who match the 3 criteria highlighted.So far I've created tables for salary, location and function then put linked fields for each in my job listing table and candidate table. So I can now tag the roles and candidates with each criteria and then using look-up fields show the candidates who have matched each criteria individually against the role.It would be great if there was a way to show candidates who match each of the 3 criteria. So a way of comparing the data across 3 lookup fields and highlighting any matches. Or is there an easier way to achieve this?Many thanks

Quick functionality question. Is there a way to highlight a set of records and make quickly assign them the same value in a given field? I.e. instead of assigning them the same value for X field independently, just highlight the records and do it with a couple of clicks?I know about the fill handle, but that isn't always practical

Is there any way to allow a collaborator to EDIT records, but NOT DELETE any records?

Hey guys,I'm creating a competency framework.I've these tables :- Jobs (lookup to "Competencies" table)- Competencies (6000 rows) with macro-competencies in column 2 (multiselect)- Macro-Competencies (600 rows) (isolated from but not linked to "Competencies")I'd like to re-create the link/lookup between "Competencies" and "Macro-Competencies" tables. I tried to replace the multiselect field "Macro-Competencies" in "Competencies" table by a LookUp field and the replacement looks good EXCEPT when Macro-Competencies fields contains a COMMA. Then, there is an (unwanted) "auto-split".Is there a way to AVOID this split when there is a comma into the datas ? Thanks in advance !

Hi, I recently ran a script to pull updated changes to our airtable into our application and all the urls to attachments changed. I looked it up and saw that this was to make them invalid after 2 hours. We were using them to point to images on our site so this means a big change in our workflow as we will now have to download the images from the API rather than pointing to them in airtable. We wanted to opt out of the change for now and schedule the work closer to Feb. We opted out in settings and I ran the script to pull the data and get the non-expiring urls. They are still showing in the browser as expired. I have re-run the script and the urls don't change. Does anyone know what is going on?

The top right corner of a record's expanded view doesn't have a toggle to show revision history, as it used to - just a comment option, a link option, and the 3 "more" dots, which don't bring it up - see screenshot attached. The revision history option IS turned on (see screenshot attached of that too). How do I get that toggle switch back to see a record's revision history? Thank you!!

I need users to be able to input data via mobile. Forms hasn't worked for some things for reasons I won't quite get into right now.Some records need to be input off a plan, which is in another table. On desktop, this works fine - I limit the linked record selection to a relevant view (otherwise I get all plans, irrelevant and past, etc). However this filter doesn't seem to work on the android mobile app... But I could have sworn in my earlier testing, that it did.It still works fine on desktop.Is this a known bug? Or have I upset something?

Hello Airtable Community,I greatly respect your expertise and would appreciate your guidance.I'm integrating the "Email Table" extension by Kuovonne into our database for improved contact communication.We're working on enhancing our database's communication capabilities. One task is creating a user-friendly button for visitors to request more information about a specific record.Here's the plan: Visitors click the button, generating an automated message to collect additional record info. The message enters a "pending reply" state and is marked "ready to send."Problem: When using a button via "open custom extension" in shared Airtable views/links, external users can't access it as internal users can. Any reason for this? Can external access be enabled?Conversely, buttons via "run script or open URL" in shared views/links are accessible to external users. Any advice on establishing this linkage and addressing challenges is highly appreciated.Thank you for your time and expertise. Eagerly

Hello Airtable Team.I am trying to run the following script, but it show me this error:ERRORTypeError: trackerSsot.watch is not a function at main on line 7Script:// Define the table and field namesconst tagsPods = base.getTable('TAGS TSM PODS');const trackerSsot = base.getTable('Team Tracker SSOT');const fieldToFill = tagsPods.getField('FULL NAME')// Listen for new records created in the trackerSsottrackerSsot.watch('recordCreated', async (event) => {    const newRecord = event.record;// Get the value from the new record in the trackerSsot const valueToFill = newRecord.getCellValue('FULL NAME')  // Create a new record in tagsPods and fill in the desi

I’m loving the idea of the SendGrid block, but from my experimentation, it appears emails can be sent only as plain text, which is virtually useless. SendGrid’s API makes it very easy to specify emails as HTML. Am I missing an option to send as HTML? This is the difference between a wildly useful tool and one that offers minimal utility.

Hi all,The links to shared views (password protected) are not working as they used to; it seems users need to previously sign in or sign up for free if they want to open the URL.  Is anyone experiencing the same issue? Thanks.

I have a company planner in airtable that I want to print in a year view colour coded with the project name printed.  How do I do that?  It doesn't have a year view option so I added the calendar to my google calendar but year view in that doesn't work either!  What do other people do??  

Hello All, I have a question about creating a custom synced calendar for each user.  I own an RV van rental management company and am trying to figure out how to have a unique calendar link for each customer that we can sync up with our user interface.  Currently, I am creating a new view for every user, but I don't see this as a scalable option as we expand. I would like a unique calendar showing each user's reservations created automatically rather than manually creating it every time we onboard a user.  I hope this makes sense.  I also don't want hundreds of views in airtable so each user can have a unique calendar.  I am using stacker as my user interface and would also like to figure out how to embed the calendar there so customers don't have to rely on a link.

Hello, I recently added a field to my calendar view and it appears at the top of each new entry rather than at the bottom where I would like it. Is there a way to change this order?

Hi! I am using SendGrid to send emails to everyone. When I send the email, it is a success, it was sent however recipients do not receive it all. How to fix this one?

Is it possible to set a rule for a (checkbox) column?Lets say i have 20 records, 1 column is a checkbox, I want to select 5 records at a time.If i try to select 6 records, maybe a popup or something letting me know i've selected 5 already.Is that possible?

I have a “Links” table. The primary field is a friendly name and the second column is a URL. When I view this record from a linked table, the URL is the 3rd entry down. There is another field above it. How can I reorder these? And here is the column order in the links table: Name | URL | Namespace | Type | Server | Participants

I have two tables: one called companies and one called candidates.  I'm creating a form for candidates to fill out which will add them to the candidate table.  One of the questions on the form is "where do you live?".  I want to match them with companies that are in their same city, so I want the company locations I have in my companies table to be the options for the "where do you live" list in the candidate form.  Is there a way to sync these up?  I tried linking the record, but I get a message saying "this is read only and won't appear on the form".  Ideally I want new locations to be automatically added to the candidate form when I add a new company with a new location.  

In our organization there is some of the user that can not log in. there was no problem for them the other week but suddenly they couldn´t  Can you give me a tip what to do

Say I have a table in which each record has a Single Line Text "Notes" field with content like this:MondayGood FridayTuesdayTaco TuesdayGood FridayTuesdayI want to find all records where the Notes have exact matches, in this case for Good Friday and Tuesday, and display them together.I figured I'd have to add a field to check for uniqueness somehow and then filter for non-unique records, but I'm not sure how to do this.