Other Questions

Hiya - I have a script that moves records from one table to another but the comments that have been written within the record don't go with them.  Why? 

Hi all,I run a small publishing business that is considering using Airtable to manage our advertising database. We have a small handful of users — like around 5 or so — that really NEED Airtable access.I have security permissions concerns, and I know we will hit the record and attachment size limits quickly. Enterprise has a handful of other features we could possibly use.My question — is Enterprise worth it to get around those things? It's a lot of money, but is it worth it?Or should I hire someone to build something for me using Airtable APIs with SOFTR on Pro plans? And then pair it with Google Drive or Box? No matter what, I expect to bump up against record limits. Looking for feedback!

Is there a way to show a button/option of Accept or Deny within the email using automation? Currently, the email is sent with a link the reader clicks, that opens a form (duplicating the same info in the email) to make their selection.

Hi all,I'm looking into the possibilities of making Airtable part of our project management set-up. At this moment, employees log their hours in Excel timesheets (on a daily basis, per month) and get copied over and over to make simulations or analysis of our ongoing projects. We have some major drawbacks in our way of working:- Information is not up-to-date, as timesheets are being processed once a month.- We need to copy the time data more than once, as we have no database set-up or whatsoever. Airtable could make it easier to centralize all timesheet data and link it back to other fixed data like project information, invoice structuring, people management... (no planning)I have a few questions about this:- What could be a good timesheet tool that works well together with Airtable? I need something "as simple as possible" that exports data on a daily base to our Airtable timesheet database.- Is Airtable an interesting tool to use f

Hello, with Airtable’s announcements today, I’m wondering if it now might be possible to do a two-way sync with a WordPress table. As I understand it, it hasn’t been possible to update a record in a WordPress table when the record is updated in Airtable. I tested Zapier and was able to ADD a new record in Airtable when a record is added in WordPress. But, ideally what I need is a true two-way sync between the two programs. I’m building an alumni site in WordPress, and would like the following functionality: When a user is added in WordPress, the user is added in Airtable When a user is updated in either WordPress or Airtable, the two records are synced so the update will happen in both databases Happy to hire a community expert to work on this functionality, but do we know if this is now possible with Airtable’s new updates announced today? Any/all thoughts appreciated, thank you!

I’d like to use AirTable as a backend for Wordpress. Is there a wordpress plugin to so ? (I already know AirPress) How would you organize your Post in a AirTable ? and more precisely how would you handle Markdown from AirtTable rich fields and images ? I give a try to AirPress it’s great but it doesn’t go very far It do not handle Markdown fields It seems there is a “timeout” on AirTable Images ? So the URL is quickly forbidden I need to do custom trick in order to handle from markdown field May be I should you an other FrontEnd than Wordpress ? (I chose Wordpress because it power half of the web ;-)) May be I should explicitly post and update Wordpress instead of using virtual fields ?

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