Other Questions

Hello, I have a table of records that other records in other tables are linked to. I want to see if there is anyway to keep the data in the linked records from updating when I update info in the source record. That way only new linked records going forward would have the updated info from the source record and the old ones would still have the old info. Example: If price in source record is $5 then when a record is linked the price on the linked record will be $5. Later the price is increased to $10 in the source record but I need to keep all previous linked records at $5 because that was the price when those records were created. Not sure if this is something that can be done or not.

Is it possible to display the Gantt view by time?

If I delete an attachment (image). Can I recover it later by going back to a previous snapshot? I’m in a Pro plan.

How do I control the filter, and group changes for Edit access users. how do I find who is changing it?

Hi all, I’m using the Airtable API to provide data for a jamstack site. I’ve run into a roadblock with the attachments field. Has anyone found a way to connect alt text or image description information to multiple images? (The previous workaround was to have one Image column and one Alt Text column, but it falls apart if you want to use multiple images). If I added a comment to each image, would it be possible to access that information in the API? (Looking through the API docs, it seems like the answer is no) Is there some way to add this information to the uploaded file?

Tables are not loading in Airtable Mac Desktop, just spins, but the base shows up normally.

Basic sales funnel. Opportunity moves from closed-lost back to an open state. Can I create a grid view that shows the different states of the opportunity? Thanks, community!

I setup a Zap to update one table from a base without date from another table. It works great but the problem is that I want the update to only add the new data to the existing one (I am updating 2 fields: attachments and a long text field). So far when I update a record, the new input deletes whatever was in that cell before. Is there a way to keep the existing data and just add the new one to it? Thanks!

Hi, Is the free plan account the same as a trial account? Or can I actually use free plan indefinitely? I am double checking because caspio made it look like they had a free plan but it was just making another free trial where you would have to re-import your data everytime! Also can I still share views? Thanks in advance!

I have a database for students DStu, a database for incidents report DInc, one for communcation with parents Dcom and a database for social emotional report DSoc The DStu is sync with the three other database so we can add incident or social emotional concerns/interventions connected to one students or multiple students. I would like to create one more database which will combine: The student Any incidents related to him/her Any social emotional concern/intervention related to him/her Any communication to parents related to him. How can I do this ?

I think I already know the answer (tables aren’t the same as spreadsheets so you can’t copy cells, only records), but wanted to post in the off chance someone can suggest a possible work around. Trying to copy a formulated date from one table to another so I can produce a gantt for each record in my base. Table 1 has records of each project with various fields containing start/stop/checkpoint dates Table 2 I was using as the base for my Gantt with only two fields (start date, end date) Currently I have to copy and paste but am hoping maybe there’s a scripting with a map loop solution out there? Example: Table 1 Record 1: Project 1 (Name) Field 1 (start project - date) Field 2 (check-in with employee - formula off of start project date) Field 3 (90-day assessment - formula off of start project date) Field 4 (end project - formula off of start project date) Record 2: Project 2 Name Field 1 (start project - date) Field 2 (check-in with employee - formula off of start project date

Not sure if this is possible, but will try to describe what I’m hoping to do. We get monthly sales reports from a variety of partners (Excel and CSVs), and each are different in terms of the number of columns and column headers, but there are a handful of columns that are consistent (productID, unitsSold, Sales) that I’d like to combine together into a single table. My first thought was to create a base with a table structured the same as each partner’s report, then a master table that pulls those three common columns and merges them into consolidated columns. I’d then simply paste the new monthly data into these each month and the master table would miraculously update with the new data! But, alas, I’m realizing that’s not how AirTable works. Is there a way to do what I’m trying to do? Or do I need to combine the data outside of AirTable each month first and THEN bring it in as a single, consolidated table? I hope that’s clear(-ish) — thanks in advance for the help. Scott

I have text file following formate Name URL is there anyway i can import that text file info in two column

I had 5.500 records in a main table and this morning they’re just gone. That simple. No filter ou sorting issue, just no record at all. I recovered the table from a snapshot, but all the linked table and fields were lost. I can’t find a way to understand what was the cause of this problem and it’s making my team concerned about how reliable Airtable is. Is there a way to understand what happended?

2 part related question How to create a meaningful SKU number… I am not sure how generally SKU numbers are created, is it random or is it shorthand code based on the description How to generate barcode ?

I have added a number of records to a database of about 500 records in total. When I sort the base, by any field, it sorts the records in two “batches”. Less than half of them from A-Z and then the rest again from A-Z. It makes it impossible to check for duplicates and completely baffles me. There was a previous tip about deleting hidden leading spaces. I have checked for this and this is not the case for me, also that would not affect sorting on every field. Any suggestions?

Hi, I currently use the CSV Import App to import an excel and use the “merge with existing records” to update values with current matches. However, I’d like it to recognize when certain matches are no longer in the excel that I’m uploading and thus delete rows in Airtable. So for example, If day 1, I import Then the next day, I import I want it to recognize that I’ve deleted “Walmart” and thus delete it from the existing Airtable. Any ideas as to how to do this?

When typing a tweet in a Long Text box, I start typing the @ name for Twitter, but it auto populates with the names of my collaborators in Airtable. How do I turn this function off just for one long text box? (I want to be able to tag them in the other boxes, just not my ‘Tweet Draft’ Box, because it causes problems with the format of the tweet. I realize I can copy paste the twitter @ for this, or use a different symbol, but I want to be able to cop/paste directly into Twitter, formatted perfectly.)

Hello! I have one AirTable database with three tables. The first two (Form Responses 1 and Form Responses 2) are synced with JotForm, and they show the responses from two separate forms I have created with JotForm. All of my clients fill out both forms. The forms have different questions, but both start by asking for the name and email. I would like for the third table to combine my clients’ responses in both forms (currently separated in tables 1 and 2) into one row. This would likely be through filtering by email. Is this possible? Let me know if screenshots would be helpful or if I can clarify in any way. Thank you!

Hi :slightly_smiling_face: Trying to create Google docs from Airtable record, but I am stuck with using link fields. Here is the explanation and would appreciate if you can help. Airtable base have three tables; Clients, Offer and Services. Offer and Services are linked and Offer can be linked to multiple Services. I have set up Integromat to create Google Doc from a template and I got stuck with listing all linked Services to an Offer. I user Iterator to extract all Services linked to Offers, but I don not know how to have them listed in Docs. It would always return only one Service in Docs. Then I added Array Aggregator, but It dos not output the records data that I need. Not sure how to continue from here… Below are the screenshots of the scenario;

I have been searching everywhere for a way to do this, but I have a table, named Categories. It is linked to a table named Bonuses. What I want to do is in my main form (and table) filter the bonuses available based on the Category selected. Is this possible?

Hi, I apologize in advance, I am sure this is an easy question, but alas. I am new to airtable and have a very basic questions- How do I when to create a table and when to create a dropdown? I feel like if i am going to reuse the data I should do a table, but I seem to have a LOT of tables right now and that doesn’t feel quite right. Thank you in advance.

Okay trying to do a bill manager and I have months listed and check marks for when a month is complete. I have put the day of the month in the date field. I would like to get the month off of the check marks and year as current year. Is this possible or am I asking for too much. Tia… Richard

Hi - We have signed up to the Pro Plan but when I try and set up emails I get the message “On your billing plan, you may only email collaborators with verified emails. See more plans.” Is this because we are still on a Pro Plan Trial and it is waiting to switch over in 2 days to the full Pro Plan. Can it be forced to switch over now if this is the case?

I have three databases from which I need to set up the proper sync: Database Students 20-21: list of all the students from 2020-2021 school year (including field school year 20-21, unique student ID and photos (attachment) Database Students 21-22: list of all the students from 2021-2022 school year (including field school year 21-22, a unique student ID and a field Indicating if a student is new. (no photo yet) Database Students All Years: I would like to sync the Database 2020-21 and then the database 2021-22. This database is not syncing the field “New student” as this database is to collect information through the year. the field School year becomes “Last Year enrolled”. Problem : avoiding duplicates I would like to be able to sync the 2 first databases with the third one and avoid duplicates. For now if student ID xxxx is in database 2020-21, and he is re-enrolled so he is also in database 2021-22, then I have two occurrences in database All years. How can I sync the databa