Other Questions

Hi All I have downloaded airtable and it looks great, I have used an existing template, and now created some individual Gantt views I wish to share with specific team members. All that has gone well except that they cannot see the gantt table because of the following error message “Start date field is hidden or invalid” If I select the option “share all fields in expanded records” then this error goes away, BUT unfortunately this then means they are not seeing only the targeting records relvant to them as I have selected but instead all the grouped records become expanded making their gantt view huge and also then not matching the gantt view as I see it. In addition the expanded records are listed in reverse alphabetical order which also doesnt match the Gantt as I have created it in my Base How can I get around this? cheers Philip

Hi, I have two tables in my database: Food Items (contains a number of food items with various attributes such as price, food type, etc.) Shops (contains a list of shops with attributes such as address, post code) These would have a many to many relationship, in that each food item could be in many shops and each shops could contain many food items. I would like to make a third table which automatically contains all possible combinations of the two tables, and which automatically updates whenever a new record is added to either of the first two tables. Then I intend to add some other attributes and set up a filter so that I could query it. I can not work out how to do this. I have found a way to create a junction table by following this tutorial ( https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relationships#ex3 ) but it seems to require me selecting each line manually. I must be doing something wrong but can not work out what it is. Edit t

Hi all! I just started doing taxes as a small business and I figured I’d make an airtable chart to keep track of all the different tax rates in different counties. However, what I’m running into is this: When I go to formatting I get the response: Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date. Here is my formula: IF( SEARCH("Online", {Location}), "0%", IF( SEARCH("Wake", {Location}), "2%", IF( SEARCH("Durham", {Location}), "2.25%" ) ) ) I’ve tried both with and without the % symbol. To be fair, the return in that column works fine but I can’t then make a later formula using those values because it doesn’t recognize them as numbers. Here’s a screenshot of the table I saw in another thread that maybe doing a separate tax rates table would help, but I am unsure how to set it so that if I click “Durham” on my Location it would

Has anyone successfully set up the app “Address Cleanser by LOB”, from lob.com? I cannot get past the setup stage. When I submit the last of my setup details (page 2 of 2) I get the message “Sorry, an error occurred”. It recommends reloading the app, which I’ve done several times, then contacting Lob support. I thought I’d try the community first. Also, I’m using a test environment secret API key from Lob. Also tried the live environment secret API key but that requires a credit card (so I didn’t actually try it). Also tried the test environment publishable API key but it says a publishable API key cannot be used to authenticate with this end point (I’m in Australia – the end point at the end of the world!).

I use a service that exports a list of movies. Whenever there are multiple countries or directors it puts them into a new row below the main record. Is there any way to combine these additional rows of entries automatically so they all go into the same row as the movie title? Here’s the airtable in question: Airtable Films - Airtable Explore the "Films" base on Airtable.

I have a worksheet for each coaching session I have across various clients. I also have a column with a link to notes for each session. At the end of the month I would like to provide an email of “what we did this month”. I would love to have some of the data from the worksheet in a view I could share without fear that they see other people’s work. I know how to create views to filter and sort but there is no easy “cut/paste” way to put this in an email. And the sharing of the view would show everyone’s work. Any help would be appreciated.

Hi, my aim is to create a table with all my customer update details. I hope to archive when ever i send a survey to customer via Typeform or mailchimp platform. The answers will be create/add/update to my Airtable. The main identifier is by email address. Is this possible? Thank you

I would appreciate an option of when viewing in month calendar view that the day could list all records for that day without rolling them up to the default number of records viewable to 4. It would simply stretch the day on the calendar to include all records.

I’ve embedded an airtable form in a page built with Shopify. I wanted to prefill the form using the URL parameter, but I don’t know how to do it. I have embedded the Airtable form in a page built with Shopify, but am unable to get it to prefill the form values based on the URL parameter. I have seen a guide on how to do exactly this in Webflow here (screenshot also attached): How to implement prefill using URL parameter to airtable form embed in webflow - Custom code - Forum | Webflow Could anybody help me translate this into instructions for a Shopify page? Thanks so much!

Hello, I used miniextensions to take screenshots from an URL page. I set up the request but the screenshot doesn’t match exactly to the url linked. When I click on the URL, the page displayed is not exactly the same as the screenshot. I don’t know why ?

Je ne parviens pas à trouver comment créer un lien utm à partir du lien de partage de la vue, qui permettrait de mettre une campagne dans l’url, visible dans Google Analytics. J’ai trouvé l’option bitly, mais elle n’est pas reliée à mon Google Analytics. Est-ce que vous savez si c’est possible de le faire par un autre moyen ? :slightly_smiling_face:

Trying to install an API plugin for Wordpress and can’t seem to find it. I have the API Key, but can’t see an APP ID.

I am looking to run an automation or a script. I would prefer to use a button so a script would be better. Here is the scenario: I have a table with student information I have a table where I take daily attendance I would like to on a daily basis, preferably at the press of a button, copy my list of students from the name field in the students’ table to the name field in the attendance table. Notes: in the attendance table, where I want to paste the name is a linked field to the student table In the students table I want to copy the primary field

Hello, Any idea how I would transform monthly totals into a cumulative total over time? I’ve tried using an aggregate transform (presumably a count operator is what would do the trick?), but it keeps telling me wherever I insert it that is doesn’t belong :neutral_face: Basically, I would like to show two different versions of the same data; displaying the number of records created on a table over time by: Total each month (bar) Cumulative total over time (line) I’m able to layer a line chart and a bar chart of the month-by-month totals like so: { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Records Created", "width": "container", "height": "container", "layer":[{ "mark": "bar", "encoding": { "x": { "timeUnit": "yearmonth", "field": "Created", "type": "temporal", "sort": "x" }, "y": { "aggregate": "count", "type": "quantitative" }, "color": {"value": "#0000aa"}

I can’t get this field to sort properly. It sorts up to a certain point then seems to give up. I tried deleting/re-creating the sort rule, even manually sorting from the customize menu. I contacted ‘Support’ with this, they did not even respond.

Are there any update plans coming soon for Airtable: for example- being able to create forms from Ipad or mobile devices? I am aware they can be done from desktop-however most of my work is from my ipad and currently no “new form” views can be displayed in the IOS app yet. Just asking for any update plans to improve the IOS versions. Thanx :slightly_smiling_face:

Hi. I have been trying to reach Airtable to upgrade my system from Pro to Enterprise. It has been 3 weeks with no response. Not quite sure what else to do. Maybe I should beg them to take my $$.

There is no text on the field that is called something like “plot”, why is it disappearing? I have already written it three times but after reloading the page the field is again empty. I have already deleted the app and installed it again, but everything is in vain.

How do you make a primary filed unique?

Hello, I’m trying to combine this formula: CONCATENATE(“Week of Mon”," ",DATETIME_FORMAT(DATEADD({Job Date},-DATETIME_FORMAT({Job Date},‘e’)+1,‘days’),‘M/D’)) With this one: DATETIME_FORMAT(SET_TIMEZONE({Job Date},‘America/Chicago’), ‘DD/MM/YYYY’) but I can’t get the syntax right. I need the timezone stipulation because when a {Job Date} is a Sunday, the Week Of formula is grouping it one week ahead (so, job date of Sunday 3/27 is getting grouped with Week of Monday 3/28 instead of Week of Monday 3/21). Thanks in advance for any help!

Hi all, I’ve setup the Sendgrid app to send automated emails. I’ve linked my sendgrid API and it’s working well. The only thing is, when it sends an email to the recipient, it comes from sender ‘AirTable Automations’ instead of my company name, even though I’ve put my company name into the right fields. Does anyone know how to fix that? Thanks in advance!

I have about 350 questions in a form, and I’d like sets of questions to show up when certain questions are selected. (Think of it like a sandwich customization form. If you select BLT, then you’ll see questions for Extra Bacon? Extra Tomatoes? Extra Lettuce? Mayo? but if you select Italian Hoagie you’ll see Extra Tomatoes? Extra Lettuce? Extra Capiccola? etc.) It’s really annoying to have to add the conditional logic to every question by the drag-and-drop interface. Is there a faster way to do it?

Hi, I have a table with quotations. Each quote have multiple items associated. How can I use page designer to print a the quote for a customer selecting some items. Keep in mind that each item has a unique reference number. Each quote could have several references each quote belongs only to one customer

How do you make a cell in a row required?

I am trying to send Google Calendar invites based on Airtable records. Will try and distill to a simplified version: I have a table for Time Slots, and want the following: When “booked”, send a calendar invite When modified, update the calendar invite When un-booked or a booked Time Slot is deleted, delete the calendar invite I’ve looked at a number of ways of doing this: iCal link - doesn’t support inviting folks, or setting a Location Automation - complicated to handle all of those cases, and no ability to delete events in Google Calendar Zapier - complicated to handle all of those cases, and there’s no trigger for deleted records (Time Slots) I’ve seen some related questions on here, but nothing that quite covers the end-to-end like this. Curious if anyone has ideas, besides coding something custom. Thanks!