Other Questions

We have 3 bases.1. Complete database -  Where we keep and use final data2. Onboarding data and cleaning base - Where scraped data is uploaded and prepped to be pushed to complete database. Here we catch missing data points and where data doesn't match existing records in complete database. 3. External data cleaning / filling base - This is where onboarding records from 2. that have missing fields or fields that don't match complete database are pushed to for a team of scrapers to fill or replace with the accurate data. This is currently done through synced views. Ideally once cleaned data can get pushed back into 2. the onboarding data base once complete. The issue is getting data to be fixed or updated in 3 through the synced views. Another issues is the search fields don't appear in the synced views.Is there any work arounds for this or happy to for suggestions for another solution for the same use case. Note we have the separate base for 3 as we don't want to give access t

I'm helping with a local food pantry and shifting their data mgmt from google sheets to airtable. They register clients in a 1-time data entry task, then each time that client visits, they record that visit. So I have a Clients table and ClientVisits table. One client can obviously visit many times. Sometimes twice in a month.I am feeding this data into interfaces for the users.Each month the food pantry needs to run a report for:Number of visitsNumber of unique clientsSome other demographic infoNumber of visits is quite easy of course. How do I get the number of unique clients counted? In MySQL or SQL Server this is what I would want to do: SELECT COUNT(DISTINCT clientid) FROM ClientVisitsWHERE VisitDate >= '12/1/2022'AND VisitDate <= '12/31/2022'; 

It appears to me that Airtable can only report on a single table at a time (via a View). Yes, tables can have link fields (link, lookup, rollup,ect) from another table, but I do not want to have to add link fields to my table just so I can do reporting. I want to be able to create a report across multiple tables,as I can do with just about every other database on the market… Does anyone (especially if you work at Airtable) know if Airtable are working on this functionality ? Thank you Jim

Hello, today all my airtable bases are having a bug, when I upload any media, as soon as it fully uploads, I see a Green border on the cell and my avatar and it deletes the media, just as if I was logged in another computer and deleted it myself.It's happening in all my bases and I have no Automations/Scripts/Extensions/Filters/Groups running.See the video for more details: https://watch.screencastify.com/v/u294YkcGcuysELewlPnPIt's the first time it happens to me in 3 years since I started using Airtable.Anyone can help?

Hi, I'm trying to build a project cost tracker but I'm reasonably new to airtable. The issue I'm having is that as the project evolves, the costs change (as requirements change etc.). The business wants to be able to see that variance. Currently, when costs change, a new cost estimate record is created. All are linked back to the opportunity (our proposal to the client). However, I can't think of how to calculate the cost variance by cost centre automatically.  An example of what I'm trying to achieve is below:  Opportunity (LINKED TO RECORD WITH PRICE TO CLIENT)COST CENTRE 1COST CENTRE 2COST CENTRE 1 CHANGE FROM THE PREVIOUS ESTIMATECOST 2 CENTRE CHANGE FROM THE PREVIOUS ESTIMATECost Estimate V1 – Deal 1DEAL1£500£100N/AN/ACost Estimate V2 – Deal 1DEAL1£600£50£100-£50Cost Estimate V1 – Deal 2DEAL2£200£200N/AN/ACost Estimate V2 – Deal 2DEAL2£300£200£100£0

I have multiple tables - one is the master table, the other tables are child tables. Records from the master table should be automatically linked to the child tables when they are created, based on a field that contains a matching value for the child table.For example, I have tables:Master, Project 1, Project 2, Project 3.Master project contains a list of companies and field that lists their projects.Project 1's table is supposed to contain *only* companies that are associated with Project 1Within the master table there is a field labeled "Projects", which contains zero, one or more of "Project 1", "Project 2", "Project 3".If the field contains "Project 1", it should be linked to the table named "Project 1"If the field contains "Project 1" and "Project 2", it should be linked to both "Project 1" and "Project 2" tables.Hoping to do this within Airtable Scripting, so that it is dynamic and able to update based on the table names.My current code looks like this (using a button to create a

I'm currently running a script button that will copy the 'Reservation Requested By' value to 'Reserved for'  value. let table = base.getTable("Status Report"); let record = await input.recordAsync('Reservation Requested By', table);if (record) {   let oldValue = record.getCellValueAsString("Reservation Requested By");      let newValue = oldValue;   output.text(newValue);      await table.updateRecordAsync(record,{"Reserved for": newValue});} else {    output.text('');} I want to add a condition to this button so that if the 'reserved for' value is not empty, or exceeds certain days then remove the value. Can I do that?

Hi there,I embedded my Airtable into a Webflow website. Every time I want to "Add Condition" to filter my data, the page automatically scrolls down and hides the top taskbar. This is only an issue when I set the Airtable height to be larger than the window height. Please see video for the visuals. Can someone please help me? 

I'm feeling like I may have more OCD tendencies than I thought. It's driving me nuts that I can't set a field width for the columns in Airtable. Usually in Excel, I would make columns that contain like data the same width, not being able to do that in Airtable is making me crazy. I don't really know about scripts and I was wondering if it's possible to make one so I can input a field width for columns. I just need to know that they are the 

Hi everyone, Today is an important deadline day for us, and we are collecting client deliverables through Airtable forms. We have a large influx of form submissions today, and everything was working as expected until about 10:30am MT this morning. I received a correct form submission at 10:25am MT, and then the next form submission at 10:33am MT had been edited by an "anonymous" user. Every form we've received after that has also been edited by an "anonymous" user, and any files that our clients included in an attachment field on their form had disappeared / been deleted from the records.The only other post I can find like this is this one, but it doesn't seem to have a resolution. Our team is also unable to upload attachments to records ourselves.Does anyone have any insight on this issue? We really don't want to have to reach back out to all of the clients that are submitting deliverables today for the deadline to ask for them again.Let me know if any other information woul

I’m using Airtable to organize an annual event, and something we do is track people. I made a set of bases last year that track what each person does and links to many other tables, but the problem lies in trying to make this abstract for every year. I’d like to have a “contacts database” that is outside of each year’s airtable, and syncs contacts with “2023” status into the 2023 base, and same for other years. We need different bases for each year because a lot of what we do gets “reset” every year. I need to start with a blank slate and be able to easily copy people in. The problem is that I also need to add new contacts every year. By setting up a sync, we can’t edit the basic info on each Contact in the 2023 Base – I can no longer have forms (either with Airtable or Miniextensions) which populate Contact info, which is a mix of the info synced from the Contacts database and year-specific info. The closest I got is by having separate contacts tables for each year and using Multi-so

Hello Airtable Community, I'm creating a form where I need a specific number of volunteers for each area of an event I'm planning, for example, I need 5 volunteers on Saturday from 9am-12pm; 5 volunteers on Saturday from 12pm-3pm, etc. What can I do in creating the form to where as the volunteers sign up for various slots, the available number of slots decreases from 5 available to 4 to 3 to 2 to 1 to 0?I don't want six volunteers to sign up, I don't want the sixth person to see it would be an option.  Any suggestions would be most appreciated!Best, Dan

Scripting no longer has typescript support or formatting - is this coming back? (Please say its coming back)

Did Airtable use its own platform to design this Community Forum? It’d be perfect for what we are trying to do… We are trying to design a (closed - invitation-only) platform on which collaborators can start threads by asking questions. Currently each new record is a question. There is a tab for collaborators to be assigned to the question. The answer to the question is given in a long text field (with tabs for grouping the questions by issue) and the collaborators can upload documents to the record. Any comments and back and forth are in the Activity tab of the record as a comment. In Blocks, we have appear.in and google hangouts so participants can chat or video conference to discuss… But the above is missing the sequential conversation format (ask question, get reply, another reply, another reply and a resolution comment). It would also be great to be able to mention a group of collborators instead of naming each individually. Is that possible? (I have grouped the collaborators by co

Is Airtable able to sync with repos within an organization account?

As far as I'm aware, we're not able to set the Primary Field as the User type. Has this feature been discussed/is this a feature that is likely to be added in the future?

Hello,My organization requires our companies to submit quarterly reports via an Airtable form. Because companies cannot see the previous quarterly report form submitted, sometimes, they will duplicate answers from the previous quarter. I'm wondering if there is a way that companies can see the last quarterly report they provided when they are completing the current quarterly report.Thanks!

Hello community! Question 🙂 :Is it possible to take values from one table and use those values as field titles in another table.For example: Table1 has a list of first names and I would like to use those first names as separate field titles in Table2Makes sense?Hope someone can help me out! Thank you!

Hello, I am having trouble with numbers coming from a .CSV. Currently I have the field set as a Decimal (1.0). The data in the CSV looks like: The data when uploaded looks like: I’ve tried changing formats, but I need it to remain a number format so that I can pull averages. Thank you, Lindsay

I am trying to prefill a check list with the check boxes into a long text field, i.e. make prefill links for different maintenance reports as required. I am trying to use a formula to generate this result. Here is the code “?prefill_Notes=[+]+Test\n[+]+Test2” This is the output: It is not showing the second paragraph / line The check box is not in its checkable form but rather its underlying raw text form. I have then tried to prefill from a field already containing the correct structure of the check list and this solves issue 1. with the missing paragraph / new line spacing. “?prefill_Notes=” & ENCODE_URL_COMPONENT({Details / Task Breakdown}) But as you can see, Issue 2 still persists the check boxes are not immediately usable. Any way of doing this? Thanks

Hello, I'm new to Airtable and already very impressed. My question:One thing that Databases, PowerBI or Tableau have is RLS (row level security). I read this article https://support.airtable.com/docs/permissions-overview but it was more about the capabilities of different roles. What I want is sth different:In short, let's say I have a column USERNAME in my table. I share my table with a collaborator called Julia. Julia can only see the rows where the column equals to USERNAME is "Julia". It's basically like a filter but the the collaborator cannot unfilter it. Julia would have only viewing / editing access to the above mentioned rows.RLS are handy as they can scale. In our case, I might have 20 collaborators in the end. All collaborators should only be able to see their "own" rows.Thank you so much BR!

Hey All,I'm not sure if there is something similar on here anywhere, but I thought I'd ask.So the base(s) are pretty complex at this point, however here it goes.We have different levels of tracking.High level tracking of Clients. This tab(le) stores client data that goes through various states and tracks them.  They may never go into training, but it stores other high level data.Once a client has paid/agreed, etc for training they move from #1 tab into this tab: this table tracks unique training, so company ABC from #1, could have ABC-110123, and ABC-011723 (start date of training as unique ID). This also stores lookup data from the next one as far as ALL the trainingThis table is the actual training "calendar" so all the training dates with the respective courses, date & time, etc are store here. We also track the #of attendees that are invited as well as who actually shows up.All of this data is used to track the amount of training, specific people who attend, etc. The bigge

If I select multiple fields (columns) and cmd-click one of them, it narrows the selection to that one field. If I select multiple fields and go to the dropdown for one, it narrows the selection to that one field. How do I delete multiple fields at once rather than having to go through them one by one? This seems like incredibly basic spreadsheet functionality and I’m puzzled that I can’t find it.

Why are my bases unavailable - its been a few hours now.  

It is not possible to prevent base collaborators from viewing certain fields (columns) within a table or base. To get around this problem, the only recommended solution I have seen in this community is third-party tools, also referred to as external tools or portal tools.Examples of these recommended tools are Noloco.io, MiniExtensions.com, GlideApps.com, Softr.io, Pory.io, and StackerHQ.com.But rather than using a third-party tool, what if we created a “mirror base” within AirTable, and established a different set of collaborators for the mirror base?The mirror base would be a duplicate of the original base, but with several additional fields added. The mirror would update in real time whenever the original base is updated. The two bases would always be exact copies of each other, except that the mirror would have several additional fields.Could this work?