Other Questions

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!!

This may be the wrong category, but I need to join two tables for output of our data. I have two linked tables: Person and Classes The person table looks like: Name | Classes ---------------- John | A,B,C,F Sally | B,F Max | B,C While the linked classes table looks like: Class | Date | People --------------------------- A | 1975 | John B | 2000 | John,Sally,Max C | 1823 | John,Max D | 1492 | E | 2020 | F | 2010 | John,Sally What I need is: Person|Class|Date -------------- John | A | 1975 John | B | 2000 John | C | 1823 John | F | 2010 Sally | B | 2000 Sally | F | 2010 Max | B | 2000 Max | C | 1823 How can I achieve this in Airtable?

Good Morning! I am having some difficulty with getting an automation to connect with Teams. My admin said he logged in and granted access, but when I try to log in, it doesn’t work. Do I have to be on his Airtable account? Or have him perform the Teams login on my account? Any similar experiences out there? Thank you!

Hi All, Struggling with a formula if anyone can help! I would like the fee to show in the field, if the date booked is a 2018 date. Then I’ll have another field pulling out all the 2019 fees etc. Then use a roll up to bring in the totals to another tab. When I do the formula below it pulls in all Fees no matter what the date is, and when I click back in to the formula it has removed the ,0 part. IF({Date Booked}>=(01/01/2018),{Date Booked}<=(31/12/2018),{Fee £},0) Any help much appreciated! Thanks Neil

We built an agile Gantt chart in AirTable. We’ve got tables with Sprints, Epics and Tasks. Is it possible to disallow the start of a sprint date that is before or after an epic? So the idea would be if an engineer schedules a Sprint to start after the Epic closes, they wouldn’t be allowed to.

Every time I open Airtable and go to my most-used table, the same Personal view always loads. I think it is the first grid I set up in the table and right now it’s my only Personal view. However, I would like to have a different view load as a default. Per the suggestins in a previous closed thread (Change Default View), I tried moving the desired view to the top of the list, and also to quit Airtable on the desired view and reopen, but it still goes to the Personal view. Is there a way to change this? I’d love to see an option in the view controls to set ia particulare view as the default for the table. Thanks Helen