Other Questions

Hi, is there a way to connect several fields. I have several fields: dress name, dress style number, dress retail price, and dress wholesale price. Is there a way that when I enter the name of the dress in that field, the base can fill in the other fields with the accompanying information?

How do I find out when someone has completed my form and submitted answers? I did a test run and received zero notifications after entering my information. I need to see the data after people have completed these forms.

Hello Airtable gurus, Not a native english speaker and already awake for 18hours so my explanation might be bad My primary field is a concatenation of 3 fields… Is there a way to use Zapier and link a record by only using that data has a partial match from any of the 3 concatenated Primary field? I mean when assigning a linked record manually, we can just type anything and if it matches the primary field, the record shows up right? Is there a way to replicate this via Zapier? image|700x493 I tried but I get this error unless it’s an exact match Context: I want to use Typeform as a customer registration form . I have 2 tables, Customers and Addresses. I have to separate the Address table so i can assign multiple address to customers and be able to just choose a PRIMARY shipping address, similar to Amazon/shopify. With the help of zapier, customers fills up the profile part of the form which goes to Customers table, and Shipping address goes to Address while it automatically link the c

How can I create a formula to set a reminder every interval of X months for a period of P time? For instance for the second column, create a reminder on 6/1/2021, 9/1/2021, 12/1/2021, 3/1/2022

I am trying to upload a pdf to airtable. It was working fine. Today, I am facing a weird situation where pdfs are getting uploaded and suddenly disappearing from the table. This behavior is random. I couldn’t find any solutions to fix this issue. Could you please help me with this?

I have a set of data that contains first name, last name, timezone, and email address. I’d like to create automatic groups of 3 based on time zone (each participant needs to have the same timezone per group) and then somehow (hopefully in an automated manner!) communicate the peer groups with their first, last, email to each group. Anyone have any ideas for how this could be done with Airtable? Thanks in advance!

I have a table that tracks every donation made to our charity, which includes the title of the fundraiser to where the funds were donated. This is triggered by each new donation. What I need to do is find a way to AUTOSUM the donations by the fundraiser title. The stick in my widget is that this number will be constantly updating as more donations come in. Currently, I can group by single select and see the AUTOSUM for each fundraiser. As new donations come in, this number automatically updates. Gorgeous. Since I need that number to use in other places, I’ll need that value to inhabit a single record. What I’ve tried to do is create a NEW table to do a ROLLUP. My issue with this is that I need to manually add each new donation to get an accurate snapshot of the current SUM. Since this value will be used in client-facing data, it has to be up to the minute. So, if a new donation came in for Sam’s page in the first image, the sum of the grouping would increase. But the record in the li

I wish the field order in dedupe was useful. Putting them in order of creation is not helpful when you have hundreds of fields.

you can’t merge a calculated field so why to they appear in the “Dedupe” app. In my case I have scores of calculations so using dedupe is difficult because I can’t hide those non-mergable calculation fields.

Hello, I am in the process of trying to map an existing Google Form to Airtable and I am not having much success. I’m doing a test drive to just understand the process so I can then build out a larger form and automate it. At the moment I’ve only included two fields: Google Form: Name (Short Answer) Test (Multiple Choice) (“Option 1” is the only choice available") Airtable Col. 1 (AutoNumber) Col. 2 Name (Single Line Text) Col. 3 Test (Single Select) (“Option 1” is the only choice available") I’m using an app called Form Director to do the automation: #; App Field; Form Field; Valid short_text Name; short_text Name; done short_text Test; radio_button_checked Test; done Can someone please assist?

Is it possible to access new fields added to a synced table or records linked to the synced table from the source table?

Hello - I’m using page designer formatted on an 8.5x11. I’m using the table format to display a long list of inputs. The problem I’m running into is the list extends beyond the length of the sheet and I can’t figure out how to continue the cutoff information in a secondary table on the same sheet. It feels like I’m missing something straight forward. Thanks in advance!

I own a music lessons studio and the software we use (WellnessLiving) reports revenue per lesson and instructor pay per lesson in two separate reports. I’m hoping to find a way to match up a lesson record that contains the revenue for that lesson with a separate lesson record that contains the instructor pay in order to see my gross profit. In essence I have two sets of the same data (e.g. two entries for a 30 min. guitar lesson from March 28 at 2:30pm) that both contain different data that I want to combine. I could do this manually using the Dedupe app but I figured there has to be a way to automate this.

Hello all, Now, I want to count a single select quantity from a different table Table 1 like this Table 2 like this And I want to count Table 1’s status quantity I want the result in table 2 show todo 4 in progress 2 done 2 Does anyone know how to do that? Thank you all. David

Hi All, How do you produce a gantt chart which has the tasks from two different tables (in the same base) and shows the dependencies between them? ie you have two projects generally be tracked separately but want a gantt view of the dependencies between the projects? Thanks

I’ve made a airtable form and received quite some data already (incl email). I realised I forgot to ask the date of birth. Is there a way to send many people individual emails to request them to send it back and it auto fills the DOB field?

Hi everyone, I am new to Airtable and I have been stuck on this for a while now, basically what I need is: A Products table for thousands of products These products can be grouped into 10 main categories There are a few dozen sub-categories under each main categories What I would like to achieve is, each time when I am adding a new product record, I can select the main categories drop down menu, and after that only those sub-categories related to that main categories will show in the sub-category drop down menu I am totally lost here, please help. Thanks in advance. Anson

I use airtable as a ticketing system. Would like to be able to have users send an email that can be parsed and turned into a ticket in my airtable. Was wondering if anyone knows of an airtable app that will do this?

Hi! I want to create a report with some figures that I have in APPs. Is there any way to do it? I use Page designer for reports but there seems no way to add there the graphs I obtain from other apps. Could somebody advice? Thanks in advance

So our team is semi unique in that some collaborators only need access to certain fields to change, while others need semi admin. The semi admin is easy enough, as I can set them to editors only. But let’s say another set of collaborators, I only share one base, and only want them to be able to edit a certain field or set of fields. Is there a way to do this?

I’m just curious what other peoples workflows are here? I am using airtable just for myself right now, since its easier for to completely setup and manage the data on my end. But how would I go about collaborating when I start adding team members who can edit these airtable files? For now its just going to be 1 additional user adding data My major concerns are the following: The other user being added on here, some of their data isn’t up to my standards so its considered slightly “garbage” data in my mind. It doesn’t meet the high level standards I set out, so I need to keep a close eye on this data. This is mostly for a product database. How exactly would I go about ensuring my data is as clean as possible? Which feature would I use: Collaboration / revision history checkups? Personal table views ($24/plan)? (only give permissions to edit certain parts of the table?) Rigid referential integrity enforcements? (I don’t know how this works yet though) Could someone possibly chime in

Hello, guys. I’m looking to visualize data in my Base with a spider graph. Their is no app in the community, and I can’t seem to find a platform that I can afford, or that’s good, to do this. Does anyone have any experience, or can recommend something Help and thanks!

Hello, I’m discovering AirTable, I have a free airtable plan. I would like to connect it to my Mysql database. In my database I’ve the number of messages that my member (Adolphe) sent. Adolphe could send 0 or 100 messages every day, so the number could change every day. In AirTable, I have a raw specially for Adolphe. I’ve created a column named “Total messages sent”. How could check every 24 hours the total number of Adolphe with my Mysql in AirTable please ? Thank you

On my calendar view, it automatically applies a label to my entries. I want to remove this for my date ranges because it is applying a “Start Date” label to the first day, but when it’s a long title, this label can appear on a day that’s not actually the start date. I do not see any option to remove the label. I’ve just been putting a “-” as the label for a workaround, but I’m curious if there is a better way. Thanks!

Hi Airtable community, Currently i am working on setting up a referral program. I have attached an images to explain what i am looking for. I hope someone could help me out, as i am quite new to airtable. I have been experimenting with the FIND() formula, yet i could not figure it out. The “gebruikt download url” tells me from which url a subscriber of the Ebook has downloaded it. This can be the basis url, as is the first record. In the second column, you will find a generated referral url. This url is meant to be shared, in order to get some price. In the second record, the column “gebruikte download url” shows that the ebook has been downloaded through the generated referral link from the 1e record, as both of them contain the same =ref"" code. What i would like to do in the last column “Aantal referral” is to count how many times a certain referral url has been used. The before last column shows the referral code of the subscriber. I’d like to built a formula, which looks for that