Other Questions

I’m new to this and trying understand whether I can “get there from here”. The concept: ~ People fill out a form with the results going into a base ~ A majority of the data elements for these records are then made accessible to a public website ~ Anyone can then go to that website and do a search based on a variety of elements that were made available; they can filter, search, sort, etc to find the records that are helpful to them. Is this do-able? I was not exhaustive in my search of case studies, but have not yet found one that shows that you can do this. Thank you!

Hi, Building a client website and wondering if anyone has used Air Table to collect all the website content. If so, did you start with a template? Any help on how to best set this up would be much appreciated. Thanks!

Hi, I’m having trouble getting my zap to find a record in airtable. Desired Workflow: I create a new record in Airtable and name it “wood deck” in the “Project” field. ZAP 1 triggers and creates a new task in Clockify called “wood deck”. I create a new time entry in clockify. ZAP 2 triggers and updates an “Elapsed Time” field in Airtable. Problem: I can’t get ZAP 2 to find a record to update in Airtable. I specify which base and which table to look in. Then in the “record” spot I punch in {Project}=“clockify task name” When I run the test I get an error that says record not found… Am i setting this up wrong?

Hello, I would like to create a formula that works out a date period for example the start date is 11/12/20 and 4 months later (calendar months) ie 11/04/2020 is there a formula I can use to automate this date of the 11/04 from my start date? Thanks

I have a lookup option (in Number of weeks) that has two different values. I want to be able to extract the numeric value from either of the text strings that is chosen and place that value in the AMOUNT column but I have no real idea as to how to do it. Can somebody please help me

Hello! I have three tables: Products, Bill of Materials & Pack Cards. Products & Bill of Materials are linked together, with up to 10 rows linked from Bill of Materials to each record in Products. These are manually created and do not change. The Pack Cards table is entered 2-3 times daily & is linked to both Products & Bill of Materials and contains entries of Products divided into up to 4 records based on the type of label indicated in a field (we ship plants and they require different stickers based on destination). These records look like duplicates if you are only looking at the product ID. Once I am done processing a round of Pack Cards with Page Designer, I delete the entries and re-import later, so the links are deleted. I have a script set up to run at the click of a button, but what it currently does is only links only one out of the four possible records with records in the Bill of Materials. My goal is to have all four linked up, but I’m not sure how.

So I wanted to get the API key so I could integrate some zaps, navigated to the API ‘mode’ of the desktop app and now its stuck there. There’s a big blue button that says “Open Base” that does nothing when I click it. I’ve uninstalled the app and redownloaded the latest version, and every time I open it its still stuck. Help!

Has anyone transferred off of Affinity and is only using Airtable as their CRM? Currently we use Affinity because its connected to our emails, but I’d like to tansfer off to only use AirTable, and possibly set up at Zapier connection with MailParser to get the email integrated to Airtable. I’d love to hear if anyone has ever done this and how they feel about it?

When I try to print a grid view, the print dialogue box comes on, I chose all the options I want and then click on print. Normally this used to take me to the computer’s print dialogue. Since yesterday, it starts to say “printing” on the click box and then just stop doing anything else. I have tried to print using the App on a MacOS, on a Windows, and by logging into system via a browser. All the do the same. I have tried changing the options. Nothing works. It was all fine two days ago and then it suddenly stopped yesterday. Has anyone else had a similar problem?

Is there a way to color coordinate different views on a table? I have several views that all related to a topic. Then one view that lists outstanding action items. I’d love to be able to visually group these by color.

Hello, I apologize; this likely has a simple answer, but I cannot figure it out. I am trying to figure out how to reorder records in a table. There does not seem to be an option to grab and drag anything; when I try, it just fills in a check mark where the number is. I copied this airtable from another user, and this is my first time using airtable. I am very unfamiliar.

We have unintentionally deleted a question out of a form where in the past business partners would insert their delivery Zip Codes. We usually update this info on the back end ourselves to the correct coverage radius. When trying to revert back to multiple old snapshots to correct the removal of this field we get an error message. Has anyone else had this issue when trying to restore old snapshots?

I am very new to Airtable, having trial account about a week ago. So far, I really like it. And I think I want to use it for my organization. I do have a question though. As far as I know (from reading multiple posts on it on community and on the FAQ), read-only collaborator do not have to be a paid users. My question is. For key people in the organization, Airtable Plus is definitive. But for the rest, do they have to be free users? Or can I have my organization to have several Plus collaborators and the rest on the Pro level and Free level? (Can’t seem to find this on FAQ). Also for all these users. Do they each have to make account (and paid separately), or the invoice will be sent to my organization as a whole in one invoice? Most platform I know require the admin to add the users (the latter). But since there is password and domain restricted shares on view, I suppose Airtable works a bit differently? Does this mean that each user has to be

I am attempting to call a POST API outside of AirTable to kick off another process. I am passing an x-authorization header with the proper token, but am getting a Status Code 401. The request method is “OPTIONS” when I inspect the code and look at the network headers. I believe the issue has something to do with the User-Agent I’m passing (inherited from the browser) because it works fine when I send the exact same request from Postman. I’ve tried manually overriding the User-Agent to match what I am sending via postman, but still getting the 401 Status Code. Any ideas?? Thanks! Joe

I have created 1st table(Data) with two columns and 2 rows. Column 1 Column 2 Column 3 Row 1: Furniture 1 website Count(4) Row 2: Electricals 1 website Count (10) I have created 2nd table(Furniture with two columns and 2 rows. Item Price Row 1: Table 100 Row 2: chair 50 Row 3: Sofa 1000 Row 4: study Table 200 I have created 3rd table with multiple records for Electricals with item and price I am looking for a solution where I open Airtable, go to Table 1 and click on “Furniture” in Column 1 and it leads me to Furniture table for details. Similarly I click to “Electrical” in Column 1 it leads me to Electrical Table Please help

Hello, I’m trying to figure out how a Form view can be pre-populated with information from a record in the grid view - if possible I’d like this information to pre-populate in the description for the form item. The goal is that Form 1 will allow users to submit information that populates a grid view. Then, Form 2 would have some information from the grid view filled-in once that record matches a certain criteria. Sorry if this has been answered and I missed it, or if this doesn’t make sense :grinning_face_with_sweat:

We recently switched from using spreadsheets to Airtable to track advertising sales, and I am quickly learning how Airtable does not have some of the basic abilities of a spreadsheet. In our old spreadsheet way of doing things, we were easily able to total up advertising sales in a field and compare it to an entry containing the budget goal for advertising sales. I cannot figure out how to do that in airtable. The attached image shows what I am trying to accomplish. I have been able to create a summary field in our table that ads up the total sales, but I cannot figure out how to create the budget line and % of budget reached line / formulas. Any help is appreciated!

Hi, im using Airtable to calculate invoice dated from when a client signs up depending on payment method and type. I have a start date, and i have a last invoice date and next invoice date. And im using a formula now to calculate next invoice date based on last invoice date. But if the last invoice date is empty i get an error. What i want to happen is that if there is no last invoice date, it should instead be start date. Here is my current working formula: DATETIME_FORMAT(DATEADD({Last Invoice Date},IF({Payment Method}="Quarter",90,IF({Payment Method}="Partner",360,30)),'day'),'YYYY-MM-DD') And as i said, if {Last Invoice Date} is empty i get an #error. My manual solution now is to just enter the start date manually in the last invoice field. What i want to do is to base the first invoice date on the start date, if the last invoice field is empty. and i tried this. IF ({Last Invoice Date} = BLANK(

Hello all! Wondering if there is a way to export selected records to a Google Doc/Word Doc and not all records in a database? I know Page Designer can do this but I would like all of the selected records to be on one document and not broken up.

Hey everyone, I’m trying to use my base to lookup all the field variations for a given primary field input. Basically, I’m compiling a list of games (Title) with different software that add 3D audio (Spatializer) and I’m looking for the most intuitive way for anyone to find the link for the respective Guide by just typing the Title. The closest 2 methods I found are: Duplicating the primary field (Title) so I can change the type to single select. This way, I can set up a form where I can start typing and have it auto-fill with Title options. Then I added the fields I want shown as conditionals and simulated it returning Gears of War record values.

Hello. I have a table where I have created a linked field to establish a new table. When I look at that new table, I notice some fields that are actually duplicates (e.g. the value of a field has a typo.) When I correct that typo, it seems like that record should go away and instead be incorporated into another record. But this doesn’t seem to happen. Here are the specifics. My original table has a field called “Type of Case”. I set up that field to be a linked field and to then create a new table based on it. So the new table called Type of Case has all if the cases (many:1 relationship to Case Name, meaning that an individual case can have multiple types). So, in the new table called Type of Case I see a few duplicates because of typos or inconsistent naming. For example, one type is “Personal Liability” and the other is “personal liability”. When I correct the lower case version to “Personal Liability”, I expect the other one to disappear altogether, meaning that it seems

Hello AT noob here, so apologies if this is very basic. We’ve set up a simple base that books staff against sites and dates. I want to make sure that we don’t accidentally double book a staff member on two sites on the same day. I have a field that logs each date a staff member is booked to work - I’ve tried to use deduce to identify any instances where are staff member has two identical dates booked, but I have so far not managed to make it work. is this the right way to go about it or is there a better way?

Hello, I would like to send an SMS or Email as notification when I click on button in Certain Records. But unfortunately buttons are not supported in the Android APP, I wanted to run a script when I press this button in my Android APP. What do you suggest as alternative? Best Regards, Amro

I have created a base that has a list of all my customers. I am looking to embed each individual record e.g. my customer data into another website so my staff can view it. I can’t seem to work out how to embed individual records. Is this possible? If not does anyone have any work around?

I have a great base setup that is then grouped by ‘Month’ and shows all of billing records through the month/year. Month being a single select column. Billing records being a different currency column. On the desktop app and through the browser, I am able to easily see the monthly and full annual total at the top of each ‘group’. On my mobile device, I am only able to see the count at the top of each group. The number of invoices I’ve billed out a month is not my top concern, instead I’d like to see how much I’ve billed that month total. How can I create this on mobile? Is there a separate setting, view, or do I need to create a new base altogether that pulls this data? I have created a pivot table through the app, but again cannot figure out how to show this on mobile.