Other Questions

Hi all! We are using Airtable as a research database and want to make some of our work public through Our main base for entry has a series of 5 tables that are all interconnected (we take advantage of the ability to have relational tables within bases). For example, in table 1, our records link to records in tables 2, 3, and 4. Some of the information in our main base has sensitive information (like researcher identifying information) which we do not want to make public. Is there a way to create a synced version of the base that maintains the relations between the tables (e.g. “link to record from other table fields”) while allowing us to limit the fields that are shown on the public version? We want to make research public as we continue to update the main base, so just duplicating the base and removing fields isn’t an option (need some sort of sync with the main base that is being updated). I tried to create a synced base with all the tables from the main base, however, those “link t

Hello. I’m building a table for answering a questionnaire. A person can answer many questions and each answer get a new record. I would like to add a function that counts the number of questionnaire that has been sent in. So I need to find a function that’s not summing the answers (many answers in one questionnaire), but rather count the number of people that has taken the questionnaire. Is that possible?

I am evaluating productivity of another team in AirTable. The team in question enters their projects and tasks into AirTable, however many Task start dates were not entered by users. Is it possible to export the date each task was entered to AirTable in a fairly simple way, or is it impossible to collect that data retroactively without already having an API set up? Thanks.

How can i restore data from Trash by using Android app? Don’t have access to PC.

I am trying to make a quote builder in an “opportunity table” The way I do it is I mark a company/contact (in their respective tables) as “in progress” and a record gets created in another table (called Opportunities). in there I link to a products table and delivery table (the products are ad spaces, the delivery are the publications/issues) and then I add lookup fields and counting fields to make one quote. I have made 4 copies of this to be able to put together multiple offers for the client to chose from. After filling out fields, I would like to be able to click a button for the quotes to aggregate to a pdf (or straight into the body of the e-mail) and sends it to the contact. I know there’s a solution similar to this for contracts that requires two other apps (zapier and helloSign) but I’m wondering if there’s a way of doing this without the extra apps.

Hey! I am struggling to search records in integromat. I have a table with field Status and Last Modified Status autofield. When I try to fetch data with integromat with formula everything is ok: ({Last Modified Status}) but when I add condition to the formula: ({Last Modified Status} <= "{{addDays(now; -30)}}") it fails with: The formula for filtering records is invalid: Unknown field names: last modified status I also tried this formula with the same error: IS_AFTER({Last Modified Status}, "{{addDays(now; -30)}}") Any ideas how to fix this error?

I’ve been spending all week looking at Airtable and trying out options. I’m very impressed and excited to use its features. I’m also impressed with this forum. Many knowledgeable people here. I am needing some help and I think those more experienced might be able to point me in the right direction. I don’t mind putting in the hard work and learning it, but this is so robust I don’t know how best to start. To give some context, I design t-shirts. I currently have about 500 live designs between three different POD’s (Print-on-Demand) companies. I plan to start scaling up to around 2000 (or more) designs this year and I foresee Airtable really helping me stay organized. I only need to worry about design and uploading the artwork. They handle all the printing, ordering, shipping, etc. That means I can create one art file and use that same file for several different t-shirt printing platforms. I don’t have to worry about tracking multiple files of the same design. Currently, my thought it t

After accidentally deleting a field, we can restore it via undelete or snapshot. HOWEVER, the deleted field was referenced by a ‘last modified date’ field. When the deleted field is restored from Trash, the last modified date is set to the current date/time for all records. I understand this is expected behavior. but I’m looking for a workaround. Using the snapshot, we can recover the original ‘last modified date’, but there are two remaining problems: We want to continue to use the original base as it has various integrations that we’d rather not rebuild; if we do an export from the restored snapshot and import into the original base, the last modified time will be off again. any records that were changed after the snapshot must be edited again after restoring from snapshot and will not have the accurate modified time stamp. Is there a way to keep the time stamps for the restored records on import? And is there a way to fix the time stamp for those recently updated records? Thanks.

Hello everyone! I am a University student, and am currently working with a start-up whose web service allows for the creation of internal websites using Airtable as a backend (e.g., can display Airtable data to customers in a web format). We are hoping to gain a better understanding of the ways in which people use Airtable, and so would love it if anyone was able to jump on a quick phone call. Please feel free to email me on rishabh.dhawan@businessoneunimelb.edu.au if you are interested. Thank you!

Can airtable search for a number specific keyword from a “long text” column ie. search for all cat, dog, lion, horse and if any keyword from the target list is found then add found keyword to separate column. im looking for a way to search and identify keywords from large text then tag the record with the keywords found. is this possible if so how, thx

Hi! On a form I’m trying to create, I’m trying to ask users their first preferred date for a booking. However, I would need the date field to only allow users to select a date at least 3 business days out from the current date that the user is filling out/viewing the form. Is this a feature that is available, or is there a user friendly work around for this?

I am having a problem retrieving values when linking one table to another. I made a video showing the issue (as it is easier to show it then to explain it). Here is the link (please forgive the watermark): Airtable Question -- Linked Table with Selected Field.mp4 - Google Drive Thanks and be well, Moshe

I recently posted some personally identifiable information in a survey and I’m unable to edit that. Any suggestions to get that information edited?

Hello Until I perform the upgrade, is there a risk of my data being deleted from the base? Or data may not be saved?

Is there any limit to the number of fields in a base? Also is there a limit to the number of entries that can be put in a Multiple Select field (I am wanting to transfer (one at a time) some 80,000 records from a desktop database which has approximately 250 fields and in the process rethink how i want the information presented. Whether the finished layout will also have circa 250 fields i don’t know but what I don’t want to find as i progress that I have reached AT’s limit.) tia

Hi, My script is working OK but make some red marks where shouldn’t be (i think). the script is quite complex and divided into parts, designed to work in different bases, related to old tables inventory and cleanup, so I avoid hardcoding Table/Names outside of beginning const values Here, it marks red for ‘FinalTableX’ not existed in base, but not marks if I put ‘FinalTable’ existed. I think that’s incorrect behaviour, because that piece is intended to “check table, create if not exist or use existing”, maybe remains from past months, before great breaktrough with create table by script. I think, same with fields. Commented function also cause marking FIELDS, i changed it because i suddenly need second field to be Multitext. Including text source const FIELDS=[‘Name’,‘List’,‘Info’,‘button’]; const ROOTTABLE=‘FinalTable’; let tableNames=base.tables.map(table=>table.name); if (!tableNames.includes(ROOTTABLE)) { //createRootTable; const tableId = await base.createTableAsync(ROOTTABLE

How does AT sort (address) numbers that also have a suffix letter? For example, 2A, 2B, etc. To overcome the sorting problem for addresses in a Filemaker desktop database I use, I have a separate field alongside the address number in which I enter the address number in numerical formal only and use that separate field for sorting. For example, 2.1, 2,2, etc. tia

Hi everyone ! I have a personnal plan plus and 1988 dollars credits on it. I want to upgrade to the Pro plan (20 dollars, paid yearly). The only thing is that i’m afraid to lose my beautiful credits if i upgrade … So i want you to ask if the credits are saved when you upgrade your plan :thinking: Thank you

Hi so I’m pretty new to airtable and I was wondering the following: We have a CRM with a Leads Table and a Sales Calls table. The sales calls now have linked fields to the names of the leads. But I would like to be able to adjust the status of a lead in the Sales Calls table as well. However, I see that when I use a lookup field, it only get the status from the Leads Table, and I’m not allowed to adjust the status in the Sales Calls Table. Is there a solution for this, so that the two are linked and I’m able to change them in either table? Thanks!

Hi! I decided to try all the airtable automation power and upgraded to PRO plan. During 1 hour I realized that such automation is not necessary for me now and returned to the free plan. After that, I lost all my credits. How is this possible?

Is there an app or block to track the activity of other collaborators using the same base? It’s my base, but I’m wondering if I invite other collaborators if I can track their activity. Thanks

Is it possible to prevent collaborators from editing Dashboards that have been created using Page Designer?

Hi - First time posting and not a beginner but no where near a pro at airtable but I am trying to include the images of my rental products in the list that populates on my form. I have a field where visitors can request individual or multiple pieces of equipment and it would be great if they could see the product they’d be renting. I’m not sure why it shows images on the backend side of Airtable but then when you go to the front facing link, it only shows the text. I have included screenshots of what I’m talking about but can anyone shed any light on if including images to my rental products is possible?

I have a list of people and their dates of birth. I’d like to know if that birthday falls in the current month. Right now, I have a column, the formula of which is IS_SAME({55th Birthday},TODAY()), which indicates if that birthday is today, but I’d like to see everyone in the list who turns 55 next month. So, in September, the October 55th birthdays are indicated; in October, the November 55th birthdays will be flagged; and so forth. Then, I’d like to have a column which shows the first business day of that month so that, using Zapier, I can pass that date on to my CRM. So, in the view I’m going to create, I’d like to see, in October, everyone who turns 55 in November, and I’ll want a column with the first business day in November.

Hi all, we’re trying to create a bar chart using Vega-Lite app. This is where we at right now: { “$schema”: “https://vega.github.io/schema/vega-lite/v4.json”, “title”: “Test Corporate”, “width”: “container”, “height”: “container”, “data”: { “values”: [ { “tratti”: “EXECUTIVE”, “field”: “EXECUTIVE”, “type”: “nominal” }, { “tratti”: “ORGANIZZAZIONE”, “field”: “ORGANIZZAZIONE”, “type”: “nominal” }, { “tratti”: “RIPETITIVITA VENDITE”, “field”: “RIPETITIVITA VENDITE”, “type”: “nominal” }, { “tratti”: “FINANZE”, “field”: “FINANZE”, “type”: “nominal” }, { “tratti”: “ATTIVITA”, “field”: “ATTIVITA”, “type”: “nominal” }, { “tratti”: “CERTEZZA QUALITA”, “field”: “CERTEZZA QUALITA”, “type”: “nominal” }, { “tratti”: “NUOVE VENDITE”, “field”: “NUOVE VENDITE”, “type”: “nominal” }, { “tratti”: “STRESS”, “field”: “STRESS”, “type”: “nominal” }, { “tratti”: “PRINCIPI BASE”, “field”: “PRINCIPI BASE”, “type”: “nominal” }, { “tratti”: “AIUTO”, “field”: “AIUTO”, “type”: “nominal” } ] }, “mark”: “bar”, “enco