Other Questions

I have a table with 5K+ rows of data as such:table1Date - Year(formula of date) - Month(formula of date) - DataPoint1/1/2020   2020                                         01                          5461/2/2020   2020                                        02                           45...I'm pulling this data occasionally to an external dashboard with paginated API calls and would rather not have that latency.....which is fine, as I don't need all 5K+ records....I really just need the grouped and summed yearly and monthly totals such as:Year  -  Month  - DataPoint (a

Hi,When we originally set up our Airtable SSO integration, it was set to match against the user primary identifier (we call it a netid) instead of using the email field. Let's say my netid is d39562b. When I log in with SSO, my account email address looks like: d39562b@dartmouth.edu.However, if I don't have an Airtable account, and someone sends me an invite to join a base or workspace, the email goes to the email address which is my "real" one - joseph.montibello@dartmouth.edu. Then if I accept the invite, my account email address will be that form (joseph.montibello@dartmouth.edu). If there's no existing account with that form, it will create an account for that.So my problem is twofold:When a user gets invited to a base or workspace, Airtable sends email to an address (

Hi all, I am new to Airtable and new to the field also. I am based in Israel and I am trying to build some tables where the Gregorian Calendar (which is the default) is linked to the Hebrew calendar. For instance, I am creating a form where the user will either input an English date of birth or a Hebrew date of birth. In both instances I will need the table to calculate either the original Hebrew date, or the original English date. When it comes to due dates also, I would like to be able to query in either the Hebrew or English dates ie. all the birthdays in September or all the birthdays in אלול. There are many sources of Hebrew dates out there, one I found on Hebcal website. Can anyone help me achieve this? Many thanks in advance

I help multiple clients so the solution I seek needs to be able to work in an environment where I have the airtable base > then I have a client > the client has prospects and customers they need to email.I'm trying to determine if it's possible to send 1-to-1 emails to prospects or customers for my clients from Airtables without having to setup a secondary email tool (lemlist, hubspot, mixmax, etc) for each client. Can I connect directly to the client's email address? Is there an integration that provides visibility on delivery, opens, and clicks for the emails sent directly from a client's email address?Sendgrid isn't an option because corporate IT or lack of knowledge on the client side will prevent the emails for ever getting sent out.I'd prefer not to set up Lemlist (or comparable tool) for each client because it's 1 more login/tool to manage (in addition to the monthly fee)...but if that's the only option I'll make it work.  Any sugge

I get this message multiple times a day across many Bases. Is there something I can check that might be causing this?

Last week,  Airtable support sent me an email saying that (as I had requested) they updated a workspace to  the team plan.But in fact the workspace is now missing and none of my workspaces are upgraded.I have not gotten a response from support in days.Needless to say, I'm extremely frusrtrated.How do I get out of this?  

I would love to learn if there is a way I can connect Airtable to social media accounts. That way, I can gather data and create graphs within Airtable that already has access to all of the social media platforms data history. Looking forward to hearing from the community!

Hello, I use Airtable for editorial management. I’ve created an automation that will send a Slack message to my team when a story is published or scheduled to be published. I would like the message to include the information (date and time) for when the story was published or is scheduled for. I know how to set up the trigger, action, and various other pieces of information I want the message to include — the part I’m struggling with is how to format the date and time for Slack. I found an article from Slack about how to format dates. I also found this Airtable community discussion about formatting dates for automated email actions. So combining the two, I wrote: Publication details: <!date^DATETIME_FORMAT(SET_TIMEZONE({Publication Date}, 'Amer

Hi, I am constantly recieving an annual team plan billing to my credit card from you guys. Which is unlucky 'cause I'm broke and there's no money left in my card. I've downgraded to free plans. Could you kindly take back the billing? Many thanks.

Hi everyone,I keep having an issue with the URL to the attachment script. It works great for some links but there's a URL that keeps having the same issue: the script runs, it shows a gray icon, and then it automatically deletes the data from those cells. The URLs are public so that shouldn't be the issue. Some examples URLs that don't work: https://www.houseoffraser.co.uk/images/products/70936105_h.jpghttps://www.houseoffraser.co.uk/images/products/70582103_h.jpghttps://www.houseoffraser.co.uk/images/products/70080203_h.jpgSome URLs that do work:

Hello,I need to send through an API call the record and base id. Please find below the script I have made, I need know to send the baseID in the payload.Can you help me guys ?  let url = "https://hook.eu2.make.com/xxxx"; // Remplacez ceci par l'URL de votre webhooklet inputConfig = input.config();let payload = {// Ici, construisez le corps de votre requête. Par exemple :"recordID": inputConfig.recordID,// Vous pouvez ajouter autant de clés/valeurs que nécessaire.

We used to have all of our employees invited to each base as a user rather than the workspace because we had some bases with sensitive info. We've now moved the sensitive bases to a new workspace and invited all of our employees to the workspace so they have access to everything. However, when we go under Account > Base Collaborators it still shows all of the individual bases that they were originally added to. For managing access it's much nicer to just see who has access to the whole workspace and who has access to only some individual bases as we still have some people that only need base access.It seems the only way to clean this up would be to remove the workspace access, then painfully remove access for each individual on each of the probably over 100 bases we have, then re-grant access to the workspace. Is there any other way to fix this? To Airtable, suggestion that if someone goes from base access to the workspace access to clean up the view for us.

Hello, I am brand newt Airtable. So far it has been very good and a pleasant experience. I am a long time user and developer in MS Access. So there is some adjustment. In Access, when you link two tables, you can tell Access that you want to link via one field, but display another. So, I have a table with a linked field to another table. Airtable is showing me the primary key. Is there a way to show a more informative field? I am so used to using primary auto numbers that I cannot break the habit. So now all I see is a record number. I would like to see say the customer last name that is part of that record. Thanks in advance for the help. Best, Scott

Hi everyone,I did see this post but since my table is a synced to google drive I can't change the primary field.Does anyone have another solution to display field data in the linked record field?@ScottWorld ?

Hello, On my Database  I have a table called "inventory".On my work spase i have two users, me as an admin and the second as an Editor user only.In the Inventory table i want that the second user will be able to create his own records and edit them, but cannot edit my records- right now he cannot delete the whole record but he can delete the values in his fields.Is this possible?

Fingers crossed that there's a solution to this! I have data coming in from interface forms that is structured with headers like this:Name 1 / Email 1 / Address 1  / Name 2 / Email 2 / Address 2.... and so on, all the way up to 100! Yes, 100!We use this data to fill in PDF forms so it must come in as 1 row (at least with the app that I am using, I am using PDF Maker by Bustbrain labs).My question is, is there a way to split this data into multiple records like this:Name / Email / Address (header)Name 1 / Email 1 / Address 1Name 2 / Email 2 / Address 2Also, I need the data to sync, so that if there's an update on the 1st table where the data is in a single row, it will also update the data in the split records.I am open to a script, automation, syncing and duplicating tables, whatever I need to do to accomplish this. All the data I need is there, I just need it in a usable format!

Hey,I'm looking for an option in the Map - Geocode addresses or coordinates on a map extension to search for addresses.Currently we don't know the US map from top of our head and we want to search for an address to see which of our pins are close by

Hello,I have two tables that I am trying to link together.One table is an instructor table called Instructors AY25 and the first column contains the instructor name and the other columns contain instructor information, including the catalog number for the course they are teaching.Another table is a course table called Courses AY25. The first column is a catalog number and the other columns contain course information.In the Instructor table, I have tried changing the catalog number to a linked field and linking it to the Course Table. This works and allows me to look up fields from the Course Table, but the new column that is created on the Course Table that should link back to the Instructor table is empty.Here's the instructor table catalog number:I have linked this to the course table:

Hi there, I've been trying to upgrade my Airtable account from the Free plan to the Team plan, but I keep getting an error message that says, ''We were unable to upgrade you at this time. Please refresh the page and try again. If you continue experiencing problems, please contact us.'' I have tried refreshing the page and attempting the upgrade again, but I keep encountering the same error. Here's the screenshot of the error: I have checked with my bank, and my card has the required transactions enabled, so I'm not sure what th

Hi I was wondering if anyone would kindly help. I am creating a form from a grid view I have created. One of my fields in the grid view allows me to link with a master data base and pull all required info through using added lookups. This doesn't seem to be something that forms allows or am I missing something? Thanks for any advice.

Hi all, I would like to create a formula field (or any other way) that takes a number field and “translates” it to a text. ex: 1053 --> One thousand and fifty three. any idea on how to achieve this?

Does anyone know if I can lock only ONE column in a grid/table so users can't sort just that one column?I understand I can lock all the columns, but I thought I would double-check if I could just lock just one. Thanks!I'm new to Airtable, so please forgive if I categorized this question in the wrong question.

Hello.I have a cell that we input text and then in another cell that text in converted to an urlIF({LINK}=BLANK(),"","https://example.com/"&{LINK})Ex:CN-349302 -------->  https://example.com/CN-349302  But what kind of formula can I create to convert the text to an url if we put more than one "string" ?Ex:CN-234398, CN-23454I'd like to convert this to https://example.com/CN-234398, https://example.com/CN-23454   T

I need to understand one thing regarding billing per user per workspace. If I am the owner and at the same time creator/editor/everything of 3 different workspaces, am I charged as “one user” or “three users”? There are three of use in the team who will need access to many different workspaces. Will we get charged per email address (even if that user uses 4 workspaces) or per number of workspaces that user uses? I hope this is clear! :slightly_smiling_face: Thank you in advance for your help!

Hi,I would like to use AirTable to store my users table for sign-up and login from Thunkable and Noloco.  How would I go about encrypting the password field?ThanksSteve