Other Questions

My base records trading days and transactions for a small visitor attraction that is open a few days each week. There are two tables - Trading days… which records the days open and the visitor numbers. Income/Expenditure… which records any cash transactions linked to the trading days. Each transaction is a positive or negative cashflow amount. I roll up the cashflow in a column in the Trading Days table, and can thus report on the monthly cashflow through a grouped view. If income is £10 more than outgoings, the total of the rollup is £10… that’s the “cash on hand”. What’s missing is the ability to show the previous month’s closing “cash on hand” anywhere - which is the starting point for this month of course. It’s effectively the total of the cashflow column in I/E view grouped by month and limited to last month’s entries. So I want to rollup the PREVIOUS month’s cashflow column into a column called “CARRIED FORWARD”. I know, this will show the s

What can I do? I just created an account but why is my airtable full of content that I did not create? I don’t know what to do? I’m vry confused?

With Windows 10, the user can select an OBJ file (3D model) within File Explorer and the model will preview in a simplistic manner, allowing the user to spin and zoom the model. Is there any Airtable app solution available for this feature in Airtable? The current Airtable 3D app is interesting, however it is more about users interacting within a 3D space and concatenates each 3D record into the one 3D space - its effectively useless for simply previewing one 3D record at a time, and doesn’t have a camera orbit feature. All I’m after is a 3D file viewer app experience, where the camera orbits the file, and the user can toggle the orbit, spin the model. Extra points if they can ambient change lighting. I’m hoping the existing Airtable 3D app devs read this and can add this functionality to their feature pipeline.

Until today I have been able to download a .pdf image from AirTable to my Desktop as a .pdf so that I could use the feature on my Microsoft Surface to make notations on the .pdf, then resave it to the desktop and upload the notated document back to AirTable. For some reason, though I can download the document that saves is not in the .pdf format.

Hi Community! I could use some help I’m trying to set up an automation that will trigger airtable to send an email on a given date and at a specific time. The trigger I’m currently using is when a record matches a condition and the condition being when send date is. However, I can’t specify the exact time. Thanks for your hep!

I’m Fairly new to the coding side of Airtable. There are terms I don’t understand yet. Could someone explain what is REST API? Where can I learn more about it too?

Hi guys, I have multiple bases with the same structure. (Meaning - same fields, same data but different clients). I’m trying to build a base that contains all records from all of the bases with a specific status (the status called ‘Send Pitch’). So, I’ve managed to collect all of these statuses from all bases using AT automation and scripting block. The first step is “When record matches conditions” (when the status = “Send Pitch”) and then a short script to add the relevant values into my webhook. let url = "https://hooks.zapier.com/hooks/catch/XXXXXXX/?recordID="; let config = input.config(); let baseID = base.id; let table = base.getTable("SDR Workbench"); let tblID = table.id; let basename = base.name; await fetch(url + config.recordId + '&baseID=' + baseID + '&tblid=' + tblID + '&tblname=' + basename + '&cname=' + config.cname + '&fuptxt=' + config.fuptext); So, one way is good. All of t

Hi Everone, So We have a base contains all content titles from Series and Movies, I have created another synced base reading all the content that is coming in the next months, and Marketing people like to apply their campaigns depending on the scale of each title. My first content base " Primary column is the name of the title " English title + Season + EPS formula and because the marketing base is synced with it, it shows a synced primary column. however, the Marketing people would like to have their own Primary filed but still synced with that one from the content base. Is there a way to change the primary column in the synced table base without affecting the primary column in my source? like they want to add a campaign name or an event. Or how can I un-sync the primary Column in Airtable from a synced table? Thanks in advance my awesome community. My Best Ahmed

Hey, I would like to set up a airtable script that uploads to an S3 bucket. What is the easiest way to do it? Could you please share any script snippets? Thanks

Hello, can I show all of the cards in a gallery view rather than requiring use of the scroll bar? tia

Here is what I am trying to do. I have 1 base that is every customer and their submissions. They can be split up into different order numbers. So every row in Base 1 has an order number attached to it. The next base is order numbers and shows all order numbers and what stage they are in. I want the “stage” column in sheet 1 to update what stage the order number is in whenever I change “stage” in the order numbers sheet and update it is for all records that are in that order number. So I change “stage” in “order number base” and then every row in Base 1 that has that same order number will change the “stage” filed to match up. I am assuming their is a way to do this but I am running into a wall - Yes, I am new to airtable but I see the massive potential!

Hello, I’d like to automation one field ( Créateur) with another field (CA). You can see in the picture . For the moment, I must enter “Créateurs” and “CA” two times in oder to complete another table “CA” . I’ve try to make automation but I’m not fix it . When I make automation, Airtable don’t show me the possibility to imput “Créateurs” in the table. I’m asking to myself if this field type, in this case, single select, can be the problem ? Thanks very much for your time

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

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 f

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