Other Questions

I am using Airtable as a Health and Safety Database for my Organisation. I have one Table to record all the Prestarts my teams do, regardless if they are electronic, by paper, or a mix. (Prestarts) I have another Table that essentially is a form for the Electronic Prestart. (Prestart Form) I also have an Automation set up that when a new record is created in Prestart Form, it creates a new record in Prestarts, and inserts the data such has Date, Site, Team Leader. This is working well with the exception of the date that is created in Prestarts is a day behind. I could just change the date manually… but that defeats the purpose… HELP!!! (Initial Form that is filled out) (Table Created from form) (Automation Trigger) (Automation Action) (Prestarts Created Entry)

Hi All, I made a Zap for sending a new rows in a view by Zapier email. In my Airtable row is a column with files. My problem is that I could not figure out how to send an email with attachement. The only possibility i found was to send the file in the coulumn via airtable url to the file? Does anybody know how send an email by zapier mail as attachement? This are the options given by Zapier, none of them is an attachement option??

Hi, I use Airtable forms embedded on a website, we seems to be havng a real issue with the load time of the form which has been ebedded (regardless of hosting, who the site is designed with etc). Is there an option other than say embedding the form into an iFrame that could produce a faster experience for our clients using the front end? Thanks in advance

Hi everyone, I have this problems when i use GG docs to manage my data i create multiple choice option for drop down list in code like this So now when i import my GG Docs to Airtable all my optional choice are become 1 option How can i convert them into 1 single option in Airtable ? Like this one because i have tons of data , it will be consume hunreds of hours to do it manually. Thank you for reading my topic !

I feel like I’m possibly missing something but it appears there’s no way to get markdown/rich text out of the field/table that it’s in? If I add a LOOKUP field that references a rich text field, the text comes through but all formatting is stripped. Is there a way around this?

I have set up a number of Tasks within different Design Projects, but for some reason I can’t seem to move the Tasks up and down the list within each Design Project. I try to drag them from the left side of the Task row where the numbers are, but they don’t seem to move up or down the list. I would really like to order them in terms of priority… does anyone know what I am doing wrong, or why it is not working? Thanks in advance!

Hi, can someone help me with a formula? This is what I have now: DATEADD(DATESTR(“2021-04-25”),-{Indoors Weeks Prior},‘week’) I want to add something so that if nothing is in the Indoors Weeks Prior column, it will show nothing. How do I do that? Also, currently, it displays DATE and then time. How can I omit the time part?

Because we control serial numbers for much of our products, I have one separate line for each purchased item. This means for the majority of items I can’t have qty>1. But I want to generate a Purchase Order pdf showing the sum of each product, to send to my provider. I can’t figure out how to show this sum for the items in a Purchase Order. Does anyone know how could I do it? These are the basic connections I have between some of my tables.

I am using the CSV Import app to import spreadsheets (always formatted with the same columns, no headings). The first couple months I’ve used Airtable, it always remembered the mapping so that each column references the correct Airtable field. Now, it’s never remembering the mapping. I have to re-map every time I import a new CSV. I’ve looked for settings that I could have changed by accident, and I’m sure this is something I’m doing wrong, but I am at a loss trying to figure out what/where to look. Any thoughts, suggestions? This is starting to eat up my time remapping every time.

Hey friends! Jesse Parker from Zapier here. :slightly_smiling_face: I manage the Zapier Experts Program, where agencies and consultants who help automate client workflows, can become certified and join a community of other Experts as well as take advantage of exclusive resources and co-marketing opportunities. If you use Airtable and Zapier and are savvy with workflow automation, you may want to check this out! Zapier Zapier | The easiest way to automate your work Connect the apps you use everyday to automate your work and be more productive. 1000+ apps and easy integrations - get started in minutes. Additionally, if you’re looking for help creating and automating large workflows with Airtable, we’ve got certified Experts around the world who can help: https://zapier.com/experts/ Cheers!

Hello everyone! I’m a newbie and just curious about an easy Facebook messenger chatbot integration to Airtable Thank you!

Hi, I’ve got an ‘‘Email addresses’’ column in a base. When I send emails, I go on this base , copy the email addresses and paste them into the sender section of the composed email. This works well when I select email addresses that are in a continuous order in the column, however, I’m not able to select multiple fields for email addresses that aren’t in a continuous order. In an excel spreadsheet, you can select different cells by pressing ‘‘ctrl’’ on the keyboard. Is there a similar function on airtable or do I always need to copy/paste the emails one-by-one?

I’m trying to link my products to my sales records to mark which of my products I’ve sold. Every time I try to link the tables I either get an ‘unnamed record’ across the board or duplicated data across the top of my sheet, depending on which one I try to link from. All fields have name so I do not understand why it would say unnamed. nor why it would add new data instead of linking matching Product IDS I’m trying to link.

Hi. I manage several social media accounts for a marketing agency and use Airtable for my content calendars, etc, however, I would also like to use it for keeping track of and reporting social media analytics to my clients. Something that I can embed on the agency’s website. Has anyone created a table that does this successfully? Thanks in advance.

Hi, I’m using a function to check for how long people had registered with my group. It’s working like a charm. DATETIME_DIFF(TODAY(), {Position (since)}, 'days') On the screen below, you can see it works great. It’s all good. But when I change the view, the same cells aren’t updating… What am I missing? What do I need to do to see it updated alone? On the screen below, you can see it’s not displaying what was entered on the main view.

I’m trying to figure out an easy way to open each photo entry (large-scale) and navigate to the next, the same way you would navigate using arrow keys on your keyboard. I’m not sure this is possible but I’m finding it very cumbersome to open full-scale images for each entry and quickly compare with adjacent entries. Has anyone found a quick, no fuss way to do this? Thanks

We use Airtable to keep track of meetings and interviews. I am a personal secretary and I usually create a gallery view containing the Contacts who have meetings on day X so that my boss can easily find those records and make notes of the meetings. However it seems that this functionality has changed, but I am not sure when. I created a gallery view of the Contacts who have meetings today and created a link with the first 2 options enabled (‘Allow viewers to copy data out of this view’ and ‘Show all fields in expanded records’), but when i try to test the link or send the link to my colleague to test (before sending to my boss), the link doesn’t allow us to edit the associated records. This is the case both if we are logged in to Airtable and if we are not logged in, behavior that is different from what previously was working. Did something change with Airtable? As the app currently is functioning, my boss has to log in and navigate to the base, table, and view to get to group of today

For example, we have a table and would like some information reviewed, updated, and/or entered for one row?

Hello everyone, I need help with my problem. I haven’t found a solution so far. I have an airtable where we include currency rates. Those are in this format #.##### (always five digits after the decimal point) I’m using this formula to switch the decimal point to comma to convert the number to EU standard: SUBSTITUTE(CONCATENATE({currency rate},""),".",",") This works fine so far, unless there is a number like this: How it should look like: 0,02580 What it looks like: 0,0258 The formula omits the final 0 I tried using VALUE to change it to a number field to use “formatting”, but this made things worse. It turns the number into “258”. Any idea how to fix this? Kind regards, Heike

Hi, I have a field which is a formula field for a due date group. I have 'due tomorrow set to → DATETIME_DIFF({Due},TODAY(),‘days’)=1, “ :yellow_circle: Due Tomorrow” But screenshot shows ‘due tomorrow’ for things which are actually due 2 days from now (today is 21st), not tomorrow. I assume its a timezone issue? But not sure what I need to change to fix? Or maybe I have done something else wrong? ?

Is is possible to calculate the Median of a group of values in Airtable?

I’m using a chart block to track number/type of events over time. Some months we’ll have 2, some months we’ll have none. In the current chart block, months with no data do not appear, making it impossible to tell the overall timeline at a glance without reading the x axis. Is there a workaround I’m not seeing here – a way to see the “empty” months?

hello i need some help to understand if its possible to do it like I want I have a database in excel that I want to upload to airtable and use to fetch data for users and trigger automation when a user asks for it. user that wants to get data will go to the form page user will log in using 2 fields from the table that will need to go to a table and validate it’s true. if the true user will be asked for his mail. (if it’s false he will ask to add the correct values again.) when adding his email he will get thank you message and now 2 things will happen: a. one email with several fields from the table will be sent right away to the admin of the system to notify him about this user request. b. after 1-hour the user will get the email with his requested data. I will love to know if it’s possible and what is the best way to do it thanks aviv

For consistency, I would like to have user be able to select an item from a list. However, if an item is not listed I would like them to be able to add it by typing it in. Is that possible? Individuals are using a from to add records, by the way.

I have a country column and a rating column, each with multiple options. I wish to apply a filter to see only “a, b and c” countries that have “x” rating. This does not seem possible with Airtable, which blows my mind a bit? I apply "Where country is “a” " at the top, then “Or b,” then “Or, c”, but I’m then unable to apply an “And” function to apply the single rating I wish to see for those countries. Is anyone able to explain why this seemingly simple function isn’t available? Many thanks in advance.