Other Questions

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

I have been using this booking form template (here is the community post where I found it) to try and create a student registration form, but I'm running into some snags. I'm hoping someone may be able to help me. The basic requirement is below (once I have that established, I'll play around and try and make it a bit better). What I need is a form where:Student enters in their student ID.Student chooses a research topic from the list.When they submit, this reserves that topic for that student, assigning their student ID against the topic. I have five topics (for simplicity sake: blue, green, red, pink, brown), and each topic has 25 space

Is it possible to only show a certain Extension Dashboard based on the selected Table view? Whenever I am in Table A, I want to see only the extension dashboard for Table A without having to select and change it every time.

This was asked by another user, but closed without a response. What are workarounds, other than downloading/uploading a CSV, to copy a table structure from one base to another?

Hi,I am new to Airtable coming from Xano and using Thunkable as my mobile front end.In Xano I can create and API endpoint which will allow me to search for a specific value in a column in a table.  I see that I use the AirTable API to get a record but that is by record id.If I wanted to search by a field, email address for example, how would I accomplish this?ThanksSteve

I have synced my calendar (using sync to an external calendar option under share view) to my google calendar on my laptop. I see the events from that calendar there. On my phone, I have set up to see google calendars. When I look at a date that I know there is an event for, I do not see it. Any ideas as to why I would see it on the desktop calendar, but not on my phone?

Below is what I want to do, more specifically, what training can I consume to achieve the goals outlined below. In a perfect world, I would also be able to put this data into a form or template that allows for repeatable recreation without making it from scratch every time. I'm trying to figure out how to build a data set that manages several different parameters of a home automation system. I need to store devices by types and rooms/areas. I then want to be able to have a time reference for different time periods of the day, sunrise, 30 mintues before/after sunrise, sunset, 30 minutes before, wake event 1, wake event 2, get ready 1, get ready 2, breakfast, morning, lunch, afternoon, dinner, evening, wind down, bedtime 1, bedtime 2, night. The intent is to create a tool that can be used as a reference for creating a scope as well as documenting what should be happening throughout the day incase of a failure and need to re-program. For example wake 1

So I created an airtable app and now I want to hand it over to my client so he can do the subscription himself.Am I right in thinking the only way to do this is:create a new workspaceMake him the owner of the workspacemove the base and interface into this new workspace.It does seem overly convoluted. He is added to the current workspace but i can't see a way to upgrade his access to owner.Am I missing something?Thanks