Other Questions

Dear AT community, Doing inventory. I have 3 tables with a list of items, each having their quantities, re-order levels, price, etc. Reason for 3 separate tables below. Looking to create a combined “shopping view” - items from all 3 tables that are below re-order quantities. What is the best way to build this view? Context - Each table has a re-order level column (1/0), that calculates based on a formula. Each table has a corresponding “shopping” view that is filtered on items where re-order level =1. The items are separated into tables by consumption types. Table 1 consists of items measured in numbers/units, 2 has items measured by weights and 3 by lifespan. I could do these as separate columns in a single table but I figured 3 separate tables will make for clean design. Also, curious to learn creating a single view from multiple tables. As always, really appreciate the guidance and learning. Regards, Sunny

Hi new to Airtable, and getting stumped combining data on 1 table from 2 other tables. using 1 table to reference another table. The setup is: I have 3 tables Staff/Projects/Billing, in the projects table I assign staff to a project and count the hours in the staff table I have each staff member and their rate and location in the billing table I list a billing line item link it to a project and then from the projects table I pull in the assigned staff member and the hours worked. I then want to perform a lookup on the staff table using the staff name pulled from the projects table, using this to get the country and the price. But this is where I am getting stumped. The obvious answer is that I pull the staff data to the projects table and then pull that data again to the billing table, but I want to avoid the doubling up if possible as in the long term this will be used on a largish database so any optimization I can achieve will help. FYI in this situation, linked columns are single

I have .docx files in attachment field that fail to render a preview. Wouldn’t be a problem if I could download it and open in MS Word but there is no option to download the file. How can I solve this?

Imagine you have a long text field with rich text enabled that’s called Notes. You have a form view with shared link https://airtable.com/baseid. How do you prefill the Notes field with markdown formatted content? When I prefill with markdown formatted text, it get’s processed as plain text. For example: https://airtable.com/baseid?prefill_Notes=Test%20list%0A*%20A%0A*%20B prefills the Notes field with Test list * A * B Instead of Test list A B

Do Airtable forms meet minimum accessibility requirements? If they don’t meet standards when embedded, do they meet minimums when linked it from a site? If standards are met, what level (example: WCAG 2.0 AA)? Thank you.

Hello!, i have 1 base with 6 table. Everything worked fine, now i have 2 tables navigation problem. I see duplicate view of the table, with same information (as a mirror), with different navigations bar to move independent. I want only one. Thanks.

Hey everyone, I’m using Airtable’s new built-in automations feature but am running into some trouble. The first major roadblock is that my input variables are “null” even though there’s data in the actual field. I know this feature is new, so I’m actually thinking this is a bug but has anyone else had similar issues? When I run a test, sometimes my input variable doesn’t even show that it exists! I’ve attached a screenshot to show what I mean. I’m also getting inconsistent results with my fields and the values they have once brought into the code editor. I’ve had a situation where 2 identical fields (rollup fields configured to be the exact same thing) were brought in as input variables but one was an array with only 1 item in it (all of the values were mashed together as a single string) and one was an array with all the items as individual values in the array (which is what I would expect and want to happen). Anyone else getting inconsistent results like this? It’s making it really

Hello, I am trying to setup a data base for vechicle management, to facilitate followup on different issues depending on a deadline. What I need is it to return a value as it follows: Deadline overdue = Overdue Deadline between 0-10 days = Urgent Deadline between 10-15 days= Soon I created a column for calculating the no. of days to the deadline and used the following formula but it works only for the first two criteria: IF({Deadline}<=0,“Overdue”, IF(AND({Deadline}>=0,{Deadline}<=10,“URGENT”), IF(AND({Deadline}>=10,{Deadline}<=15),“SOON”))) Thankyou in advance!

Diacritical marks in names do not import properly into Airtable.

Hi Team, I am starting out in the CRM environment and came to know about you. I have a small business running. I have a few questions and wonder how you guys can help me manage my business with you. Please listen to me carefully: Well, I run a B2B business. I got around 200 clients from all over the country. I ship the products to them over their request and receive the payments digitally or by cash. The problem is that I got around 1000 products and which I ship to 200 different clients. I need to remember the pricing I quoted to different customers, different type of products I have shipped to them, their dimensions, details and all. The thing I want is: I make the profile for each one. Update all the products I shipped to them with details, dimensions and pricing I quoted. Whenever, a client returns, ask for the same product he bought in the past. I search for the client and see what price I quoted to him for that particular product. This will help me to manage long-term relations

I would like to report on user activity. Is it possible to get back-end reports of user activity? Thank you

I have created a new empty table with a form view. I want the user to be able to select records in the form, that are pulled from a different table with two columns (make & model, years) Not sure how to achieve this. Every time I create a linked record it just pulls the make and model of the car. Not the years.

I’m sharing an “Airtable Calendar View” with Google calendar (via an iCal subscription link ). Twice in a couple of weeks the link appears to have broken and events no longer show on my Google calendar. On the first occasion all events were missing so I Unsubscribed from the Calendar and then re-subscribed which seemed to fix the issue. On the second occasion only a few events are showing on random days - Resetting the link hasn’t worked this time - any suggestions gratefully received

Hi, I am trying to run a script through an Automation. The Automation is triggered by records entering a view. I receive the following error on a line that does updateRecordAsync: Error: You are not permitted to perform this operation I am not sure why because updateRecordAsync is used in the example provided here: Airtable - Support Run a script Action Overview When building an Automation, you may choose the "Run a script" action. When an automation containing a "Run a script" action runs successfully, it will allow you to tri...

Hi all Hope you can help. Using the scripting block, how could I loop through the records and return the value of a lookup field. All other fields are fine but linked and lookup fields throw an error. Here’s my code… let table = base.getTable("Daily Orders"); let view = table.getView("Unfulfilled Daily Orders"); let sku = table.getField("Line Items: Sku"); //Lookup Field let result = await view.selectRecordsAsync({ sorts: [{field: "Line Items: Variant Id", direction: "asc"}] }); for (let record1 of result.records) { output.text(record1.getCellValue(sku)); // throws an error } ERROR Error: Unknown value ‘AlexSaleBeanieAdultCharcoal’ passed to output.text() at main on line 12 Please help! Thanks Claire

So I have been trying to zap my jotform submissions into Air table. Everytime I i put in a search field and a value to make the zap work, I keep coming up with errors, what am I missing? My air table almost mirriors the jotform submissions Has anyone done a zap with jotform and airtable?

Hey Airtable community, Wondering if anyone has an easy solution for this… Currently, we’ve got a survey set up that we send to a multitude of clients. Some of the fields need to be duplicated more than once as some of the questions are for specific individuals rather than the company/organization as a whole. Is there an easy way (such as a "add more fields or “+” button that would allow the client that is filling out the form to duplicate a set of fields on their own? Or does this need to be set up manually with conditional formatting in place? Previously we’ve manually set up duplicated fields that are conditionally formatted to a specific number that’s noted by the client filling out the survey (i.e. # of employees). Where if the answer is equal to 5 or more, 5 duplications of the required fields pop up for the client. If the answer is 10, 10 duplications of the required field pop up for the client to fill in. Any suggestions or help regarding this would be amazing, thanks!

Instead of dropdown menu for views, I need a Menu Style Views for displaying different views I have created. How can I do it?

Hi Airtable community, I’m planning to use Airtable as the datastore for a statically generated site I’m building using GatsbyJS. I’ve been really impressed by the ease of use of this tool! I’m looking for the ability to create a carousel of images that have a caption and alt text per images. My idea was to have each image be a row in a table, with caption and alt text being additional columns. I would group them by an additional column, to have multiple carousels. Is it possible to limit a row with an attachment column to just have one attachment? Also if it sounds like I’m going about this the wrong way, I’d appreciate any feedback. Thank you!

Wondering if it’s possible to format within the chart block. For example, I have a scatter chart, and the dots are tiny. I want bigger dots!!! Possible? I didn’t see it. Thank ya

Greeting, I am using airtable as CRM with all leads being managed and assigned via airtable. One of the main challenge I have is that a lot of the Sales team are missing their appointments (Whenever a lead come to the system, it comes with the best date and time to call) I want to create a reminder and email notification to be send to the sales team 10 minutes before each appointment so they can call the customer on time How can i create such column with 0 or 1 Whenever the time of appointment is 10 minutes earlier to the current time it turns into 1 then i can create a view with filter for all the value of (1) And finally i can create a zap for each new record on that particular view (I can take care of it afterward) Is that possible? If yes, then how? Thanks in advance for your support and collaboration. Regards

airtable VIEW’s UI is slowly improving, and in the right direction! Bravo and thanks AIRTABLE DEV team ! I’ve already often weighed against the VIEWs in the SCRIPT-BLOCK section but when it evolves in the right direction, it doesn’t leave me indifferent. Most importantly, AIRTABLE DEV team, keep going, read the Product Suggestions about the most requested VIEWS UI and features and don’t stop on the way ! olπ @Jason @Kasra

I’ve created a Zap to create a calendar event based on a Field (formula) from a filtered View on a specific Base. When testing on one specific event, it works and the event shows up on my calendar. However, it is not creating events for all the records in that particular view. I’m thinking it may be possible that the reason is that the trigger is a new record (even though the test event already exists in the base). Anyone have any ideas on how I can get Zapier to trigger off of all of the existing records in this view and create all the events for those records, as well as new ones I will create going forward? Thanks!

I have the first column with a start date (Date Submitted). I am wanting to know how to code so that the next column will show how many days are passing since the start date (Date submitted). Then if the status (another column) comes back as closed it’ll then show closed.

I have been getting inconsistent results when inputting data in a linked record field. When I paste a comma separated list into the field, I randomly get one of the following results: Linking to each comma separated record Creation of a single new linked record with a long name of the entire list. I have performed the paste action several times in a row and gotten different results. Can anyone explain why? Has anyone else had this? Scenario 1 is the result I am expecting. Thank you!!