Other Questions

Hello, community! May be you can help to resolve my task. We have a 2 simple tables: Clients. (with Form1 for new clients) Orders – with ClientID linked field. – with Package (regular/premium single select) Now our new clients are filling the Form1 and after that we are creating manually a new Order in Orders table with this client. I want clients to fill out Form1, select a Package type and create a record in both the Clients table and the Orders Table. How to do it? Need to use third-party add-ons like miniextensions or something else?

Hello, I need help to calculate the start date of the next season based on 'today’s date and a given ‘month’ for the season start. e.g. If Today() = 2 December 2020 And Season Start = “August” (using a select field) The formula should calculate to 1 August 2021 If Today() = 31 July 2021 And Season Start = “August” The formula should still calculate to 1 August 2021 Thanks in advance!!

I have an automation that utilizes a script to update records. I needed to update the code and did so easily but now a message is showing that says “update this automation” with an update button next to it. Nothing happens when i click it. Am i missing something? thank you!

The Gantt PDF export defaults to Letter size paper. When printing from PDF to other sizes lots of space is unused. It would be preferred to be able to choose the paper size and margins when exporting so as to maximize the printing area. Thanks.

Hello, I’m using airtable to track software, on servers, in locations. I have a table setup for locations, that are linked to servers in the servers table. And the software table is linked to the server table. So software on server, in location. Is there a way that Airtable can dynamically create a lineage view so that when I put in the name of the software, it will link to the server and then the location. Or putting in the name of a location and getting the servers, and then software that’s associated? The goal of this would be for maintenance activities at any level, we’ll know what’s affected and can notify the proper location/software/server owners. TIA

I’m not good with formulas. Can I get some quick help, please? This formula… ({Material Length}/{Product Length})/{Purchase Cost} With these values in their respective columns… Material Length - 48 Product Length - 16 Purchase Cost - $39.99 Gives me a cost per product result of… $.08 The result should be $13.33. What am I doing wrong?

I would like to invite Customer contacts to base (projects) where we actively collaborate with them from the first day they have signed the contract.

I want to build an app that can handle incoming HTTPS requests from webhooks. Would it be possible to set up an express server in the app so that any requests to my app_url.com/api get processed by my app? The use case is, a webhook sends a request to the app, the app then updates rows within my airtable base.

Our Marketing team of 10 has been using Airtable for the past year. I am the Airtable “admin” on the team but am struggling a little bit on ways to streamline the instance I have built out. We have a lot of information in our instance that was built out for all different needs of the marketing org (content, design, product, regional, MOPS). It just feels a little over saturated and I welcome any help or suggestions to streamline. You view our read only base here: https://airtable.com/invite/l?inviteId=invvgV9ZF8wl5BMVq&inviteToken=76b50a841995a7916afca4962cfd225d462c1a22018887f27d6192b8f8511e34

Hello Guys, I’m trying to building a web app form my company. We need a Sales Order App for our agents, I’ve create: Products table Customer table Orders table But I have a problem we sell fashion stuff and every product has multiple sizes, how can I make it work like a you select a product and for each size you choose the quantity? something like this image: Can you help me???

Hi There, I have a date field (name = Contract Start) with a simple dd/mm/yy. In a new field (name= Order Date), I would like a formula to create a date that is six weeks prior to the date in the ‘Contract Start’ field. I have tried this: DATEADD(Contract Start,-6,‘week’), but not working. When building the formula, the system offers the {Contract Start}, which I have also tried, and also did not work. I’m hoping that someone is able to correct my error. Many Thanks Rob

Pretty new here so forgive me if this is an obvious question! In Excel, I have the option to filter a column to show a certain subset of entries - e.g. I can click on the filter button on the column header, and view checkboxes for every single type of entry in that column. (e.g. if the column is full of Apple, Orange, Kiwi, etc., I could select to see only the records with Apple OR Orange in that column). In Airtable, this seems much less intuitive - I can manually type in filters, but a) typing each entry is slower than simply going down the dropdown / checkbox list and selecting which values I want to display, and b) forces me to manually remember or find I might want to filter for, instead of having a list presented to me. Additionally, if I want to filter multiple columns this way, the whole AND/OR filter list becomes confusing to work with. (e.g. am I filtering for: (Column A is Apple OR Column A is Orange) AND Column B is Aeroplane or Column A is Apple OR (Column A is Orange AND

I have a Google Form that is pulling records into a table using automation. Once we’ve reached out to those people, we archive them with a checkbox. However, it’s gotten to the point where it’s hard to sort through the archived and ones we still need to contact. I’m using a script to create an automation where once the archived checkbox is checked, the record will be deleted off the existing table and moved to an “archive” table. My problem is that it’s throwing an error code for any field that has preset answers (multiple select or dropdown). I am still new to Airtable scripting so I’m struggling! ERROR CODE: Error: Field “Who are you interested in booking an appointment with?” cannot accept the provided value. at main on line 6 CODE: let table1 = base.getTable(“Referral Calls copy”); let table2 = base.getTable(“Archive”); let result = await table1.selectRecordsAsync(); for (let record of result.records) { if (record.getCellValue(“Archived”)) { await table2.createRecordsAsync([ { fiel

I manage a dataset with each row representing dates and several columns with times. In this dataset, I really don’t need ‘dates’ in the field but have to use ‘date’ format. Is there a format or formula or anything else that I don’t need to enter date every time?

Hi guys! I looked through several threads that were also trying to find COUNTIF workarounds, but none really matched the use case I have, so I’m hoping to find some help. We use Airtable to manage a large editorial team and content calendar. We have our main editorial table with our content roadmap and weekly assignments. My colleague who manages our freelance writer network has created a separate table with information about all of our freelancers including their names, contact info, assignment capacity, area of expertise, etc. She is wanting to find a way to count all active assignments assigned to a particular freelancer and pull that number from our main editorial table into her freelancer table. Is this possible? I can easily find the assignment count of each freelancer within our main editorial board, but can’t figure out a way to get that count to show up on the other table. Right now she is manually counting and putting that number in there as plain text. I’m attaching screensh

I have seen how to hide fields and create personal views and locked views but I did not understand how to make some attributes (columns) of a table visible only to one user. These attributes are not to be seen by other users. For example, with the maintenance table I would like to hide the “expected cost” field from the operators and see it only I who am the owner. Can you help me please Thank you very much

I’m trying to see if there is an ability to lock a task/table for individuals. Basically, we are providing courses and the next levels (with the content) need to be locked until they’ve completed courses/tasks…

Hello, I have text that I would like to paste text into a table. I’d like each line of text to get split across two columns. I know that I could probably get to this to work with a CSV import but I’m wondering if there’s a way to get the result I want with copy/paste. Here’s an example of the text I would be pasting: Line 1, Another boring day in the ocean. Line 3, Another boring day in the ocean, SIR! Here’s how I would like it to appear in a table: Here’s how it actually appears in a table when I paste it: I would either like the paste function to recognize the , and split the text into two cells at the comma (like a CSV import would do). Or I would like to paste the text then highlight column A and split the text at the comma into two columns. Are either of these things possible?

Hello everybody. I’m getting the Max value from a field which links to some records, then I’m adding to the link to increment it for the next time I need the MAX. Is there a limit on how many records I can link from 1 field? Thanks.

I created a test account to explore airtable functionality. We might need to publish our own application on airtable marketplace. But I cannot install any application from the marketplace. I click “Install” button on an app (e.g. - this one https://airtable.com/marketplace/blkt8D4LiDFZ1SCop/sendgrid) and nothing happens why is this?

Hi! I have table: integer - text - date I want view with group by text+date and average(integer) In grid view I see count(records) In Martix app and Pivot app - summarization by one field only. In excel/spreadsheet I can do it easily in pivot report. Could you advise way to create such view here?

Hey guys. I have an integration between Typeform and Airtable, I’m using Zapier to do that. BUT whenever a new record is created in Airtable, this record appears duplicated but without the field that I named as “Interaction ID” and with a different Record ID. PS: If I run a test in Zapier, the record appears with no duplication. Any ideas?

Hello everyone, I was wondeing if there was anything like a heatmap app where i can see what time of the day/week is the most popular order times, please see my screenshot for extra clarification (this was taken from google analytics). Many thanks! Matt

Hi Airtable Community! I have a problem I’m sure some of you have already solved. I’m collecting monthly data for specific metrics (example: Revenue) I’m capturing three data elements in one record - Actual, Budget, and Previous Year. When I try to create visualizations for this in the Chart app, because of the way I’m capturing the data I can’t get the visualization I’m looking for. I would like to see three vertical (or horizontal bars) for for each of the data points in the record (Actual, Budget, Previous Year). I’m thinking Veg-Lite might be the answer but have never used it. Really appreciate any feedback and ideas. I’m also open to other ideas on how to better capture this data from end users, there may be a better way to capture these elements that would lend to better visualizations. I added all three data fields to one record to make it easier for the end users to submit updates. Thank you all. Travis

Hi—I’m new to Airtable, and have a free account for now. I’m working with a cowriter on a detailed outline for a musical. My cowriter has a Pro Plan. If I also get a Pro Plan, can we collaborate on the same base without either of us being charged a collaboration fee beyond the $20/month standard fee? If not, is there any plan that would allow us to both make changes to the same base without being charged a base-specific collaboration fee? Thanks—Peter