Other Questions

Hi there, i’m new here. My question in a nutshell is if anyone has had success building out the equivalent of a School Information System (SIS) using Airtable. Read on for more detail. My wife and i and a small team are founding a new school for children in our community. We’ll start K–2 this fall and—should our prayers be answers—we’ll add a grade level each year all the way to grade 12. To date, we’ve been building out and refining all of our core systems, and now we’re researching a significant decision that virtually all schools face: choosing a SIS. There’s a million of these systems out there and they all seem to take a kind of everything-you’ll-ever-need-in-one-place approach. Our workflow, however, is heavily dependent on SAAS. We use G Suite (email and productivity), Asana (tasks/project management), HubSpot (donor management), PieSync (keeping contacts in sync), Calendly (appointment scheduler), Eventbrite (fundraisers), Aplos (bookkeeping),

Hello all, I would love some advice on a function I am experimenting with. I’m trying to build a system where I can generate student progress reports for a private high school by leveraging linked records and the “Pages” block. In my experiment I have three tables: Student List, Course List, Grades (see below). The Student List is linked to the Course List. I can “enroll” students in courses with the linked record, which allows me to display their courses on a “Page” block, which will generate progress reports (below). The tricky part comes in with

In my existing base all images stay fine but when I made a copy of the base and started replacing images in the Page Designer using url from Copy Image Address menu (the images are residing in the same base) they get displayed but get broken in a short time. The new URLs look different from my old base although I am getting the link the same way.Old base (existing images in Page Designer):https://dl.airtable.com/.attachmentThumbnails/ef32cff2ffea90eb9be2932d18a0a21b/ddc5a116‘New base (copy of the old one)  https://v5.airtableusercontent.com/v1/15/15/1678831200000/_Wi_DAKuC8szr6BlzQnjyw/Km2nzwS4ZxXQIDNQTz_3ecuRdUAxDCjWl28ZCMtGHhvZyz7XOtqigDn35qsUiMG2z4BzrsHnrKvhaz9ZFqBkBA/DjivglXPEKVSxzri7OF3EJJ0krPj

Hi!   So I am an agent who books talent for conventions.  I have a base that has like 75 sheets in it.  Each sheet is a convention and on those sheets it is marked which talent is going to that convention.  My question is, can I make another sheet for the front of the base that is basically a "Master Convention list" which would list each of the talent in column A and then in columns B-whatever, list what conventions they are invited to (which sheets they appear on) I can't seem to figure this one out. Any help would be appreciated

Hi!Recently a form I made had several of the fields overwritten when I added another form to it. The field went from a text response to a file upload, deleting all the text responses. I can see the deleted responses if I go to the individual row items and look through the version history. Is there anyway to undo the overwriting on the field level?

Hey guys. I’m trying to simplify a de-dupe routine. Scenario: I have a significant amount of records I’m importing. Many have identical IDs but have one multiple-select field that is different. I need to merge those into one record to combine the multiple selects. My manual process has been to do the following: Copy/paste new data in. Run De-Dupe App manually, checking every record. This works, but it’s super time-consuming. I need to automate the process. Is there any batch process to handle this? It’s always the same result. Needs to merge against the ID. All other fields remain the same, the only change is the multiple-select field. Ideas? Thanks.

Hi, we have a Table 1 with many fields. We want to use the same fields for Table 2, with different data. Often we want to change some of the fields, such as formulas. So, suppose I modify the formula for my "Average Cost" field in Table 1. Is there a way to make the formula change identically for my "Average Cost" field in Table 2?

I am in year 2 of using a pro license of my Airtable workspace. My organisation is based out of Mumbai, India and since the end of last year our central bank does not allow us to make payments that do not require a two factor authorisation.Luckily our payment went through the first time around last year as we made the payment prior to this rule being enforced. This year when we had to pay for the annual subscription renewal we used a colleagues American bank card to make the payment as to avoid any issues - this card was used by another team in the organisation to successfully make a payment for an Airtable pro license a couple of weeks ago. This was the second American card we'd tried to use. Both were declined and we can't figure out why. Airtable support hasn't been of too much help and we risk losing a lot of data. Any and all suggestions welcome.PS: We are trying to update an account with approx. 7 collaborators

We send emails with prefilled linked to forms to thousands of users. Some macOS users running Safari cannot open the forms. They click on the link in their email client, and Safari opens a window showing nothing but a white background.Since we lack the staff to troubleshoot individual technical issues, we tell them to try Chrome or Firefox. But some users don't have other browsers installed and lack the skills to install a new one. The call I took last week was from a user who clearly wouldn't have been able to install extensions that could have interfered, leaving us puzzled.Is there anything else we can do to make our form more compatible with macOS and Safari? We are prefilling several fields, which remain hidden, and display a thank you page after submission. The form is opened by clicking a link in an email; it is not embedded into a Web site.

i was asked by a client of mine -when i upload an image or any other file - is it beeing screened for viruses or malware by airtable ? 

Hi All. This posting from my side aims to seek solutions from you. When I went to ‘Update sync configuration’ in a synced table of my target/destination base (synced base), and I wanted to change the name of one of the two sources I used to sync its data to the target base’s synced table, I could not do it. This issue is because I named that relevant source a bit too long. As a result, I could not find the three-dot sign at the end of the source label, which can be used to edit synced fields or change/rename the source label. To sum up, the problem here is caused by the long name of the source mentioned; consequently, the three-dot button is not available for use. Would you please share your idea on how to resolve this problem? Thank you.

This doc states that when “you change cell values, … [etc.], the link will automatically update in real time to show the most up-to-date version of the view.” However, I’ve got a setup in which Typeform submissions trigger Zapier to find & update Airtable records, and I can’t get the Airtable iFrame (embedded on my site) to update in real time. Am I missing something?

The CSV Import Extension is probably the most used extension for me on daily basis multiple times. I have about 6 different CSV templates that I import on almost daily basis and I am pleased how well it works… once it is setup. The issue is, the CSV Import Extension doesn’t allow saving the import profile for a specific CSV template. Of course I can create separate copies of the CSV Import Extension but I already have 6 copies of the extension. I read there are limits to how many extensions you can have installed. It says 20. But from what I read the number is limited to Airtable own extension but not to 3rd party extensions? Anyhow, having multiple copies of the extension is not ideal if I could somehow load saved configuration of the extension when I am going to use it. If I was using one extension for all imports, it wouldn’t work because the mapping will get messed up every time a difference CSV is imported. Being able to save the configuration

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(cur

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", "Statu

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

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 c