Ask the Community

Good day! I just got upgraded to Plus for a month. May I ask what happens to my records if I decided to downgrade to free plan? Thank you!

Hi,I am trying to generate an OAuth token via servicenow and I am running into some issues. When trying to get my OAuth token I am faced with the follow error:"error=invalid_request&error_description="state"+parameter+is+invalid.+Note+that+it+is+required.&state=-68948287"I am reading through the documentation of OAuth reference just now (OAuth reference - Airtable Web API) and see the state parameter should follow certain rules and I believe I am not breaking them with the below state value:'Jt8WzfnT7dSbXn2xL1dY.mJq3-UvN4Kz0oGcRbH6pEjViI9Xy_OgZAkCs5lPuehr' I have created a rest message and application registry record for this integration and using the 'Get OAuth Token' ui action withing servicenow to do this. If anyone can provide any help or has integrated sn with airtable using oath tokens before, tha

I have two tables in airtable from the same project in JIRA.1 - Named: "Aurora EPICS [NL]".I made an export (.CSV) from JIRA and uploaded it in Airtable.All registers (139) and its columns (288) was uploaded: I want to update these registers from now on, adding new registers when they created in JIRA and update existent registers when they modified in JIRA. Is it possible?  How?2 - Named "Aurora EPICs - [JQL]".I used the extension "Jira Cloud" (by Airtable) and obtained the same 139 registers but with less columns, only 11.Four doubts:A - Can automatize the connection between AirTable and JIRA in the table #1.B - Can I bring more columns to the "Aurora EPICs - [JQL]" table?C - I trying to use Automations in both case. Is it possible?  If yes, how?D - I'm also trying to use Zapier. Is it a good idea?(for doubts or more details, just answer me back)Thank you all in advance.

Good afternoonStill a newbie to Airtable so I appreciate the help.I have a series of tables that have a "next follow up" column and I'd like to be able to create a table that would show only those with the due date of today.  In other words, it would only show all of my task for that day in the table but the records/tasks would come from multiple other tables within my base.  Hoping that makes sense.Thank you!

I have ordered my fields in a specific way so the most important few fields are shown when looking at the linked record preview, however, I've noticed that this isn't reflected in the mobile app. See examples below (I've blocked out the data for confidentiality).Desktop linked recordMobile linked recordIs there a way to make these the same? It's defeating the purpose of organising them a certain way.Any help would be much appreciated. 

My company has been trying to reach someone from Sales to manage our upgrade to Business but has been having no luck hearing back. Does anyone have a way to get someone from Sales ti get in touch with us?

Whenever I open our Airtable calendar, it opens on July 2018. I realize the solution is as simple as clicking the “Today” button. But does anyone know how to set the default to always open to the current month?

Is it possible to hide the year in a field with the date field type? Right now entries show “4/8/2018” I just need the “4/8”.

Hello,I am trying to make the process of time tracking more user-friendly. Instead of using the duration field and writing manually each time record, I would like to use two single select fields as StartTime and EndTime pickers, each containing values 00:00, 00:15, 00:30, 15:30, 15:45, 16:00, etc.But I am stuck with a formula that makes a magic difference between these two times.Is it even possible with a formula, or does it need to be done with some sort of script?Thank you 

Hey, I have seen many people asking for amazon and airtable data connector which can help them get thier amazon seller data like inventory, sales, orders, etc into airtable. But those posts were almost year old. Does anyone needs this? I am looking to build this if there is enough demand. You can show your interest by filling your email in this form and can also ask for feature request to be included.

How to create a form that adds data to existing records, rather than creating a new record?For further context; in my table, each record is a Client and their contact details are noted. I want to use a form to add their email subscription status (single select field) without doing it through a filtered grid view.I tried setting up a form in the Client table but it added a new Client record and didn't allow me to select an existing client. Any help would be much appreciated.

Hi,I'm new to Airtable and using it to connect a number of various data sources, add additional data, and create custom views.  I know how to create linked/lookup fields for data I've created in Airtable, but I'm trying to figure out (essentially) how to do that dynamically from an integration.  In particular:* I have a Jira project (PROJ) with parent tickets (e.g., epics) and child tickets (e.g., stories).  The tickets have different types within Jira.* In Jira, the child has the Parent Link field so they are clearly connected.* I made a table in Airtable for the parent and have it synced to Jira.  The ticket ID is the primary field.* I made a table in Airtable for the children and have it synced to Jira.  Ticket ID is again the primary field.* Parent Ticket ID is a field in the child table, and it shows data like PROJ-1234.I would like to automatically connect that with the parent table so that I can add oth

In the iOS app, I can edit all types of fields in the interfaces except the "Link to another record" fields. I can view related fields, but I can't link or unlink them, although I can do that on the web. Is this a bug?

Hey All.Curious how I might set this up.  Here's what I need.I have a form that interested parties need to fill out, an application.We review the potentials, and start the first pass of approvals/denials.The next stage is taking those that enter the next pass to be reviewed by instructors(who have their own base with info that can be a linked record to draw from)So we have a list of of records/attendeesWhat I want to be able to do is have each of the instructors to see the applicant, and make their ratings on each person/attendee/record.I'd thought of setting up like dynamic tables:Then I want an interface that makes it easier for the instructor to quickly rate each individual/potential attendee.  I think I'm almost there, but not sure.Thanks!Sean 

I've got a project where I am designing a set of similar interfaces, accessible to different users.  I would like to reuse page layouts and expanded record layouts (when you open a record from the element on the interface page). I can initially reuse by copying the page, but that doesn't keep them in sync. Having to redesign the same expanding record form layout is also really painful.Is there some kind of template that can be used for the page layouts and expaded record forms?

I manage a very large grant program (100+ active grant recipients ongoing), and we're doing most of our data tracking in Airtable.  We want to add a customer/grantee portal, and I have seen various Airtable add-ons mentioned. (We do not want to add each grantee as an Airtable user.)Our main need in this portal is something that can handle/track communications between our team and grantees. We need something that threads or lists all the communications that went to that particular grantee, regardless of which team member sent the message.  ie: Sometimes one team member starts a conversation, then others pick up and continue the conversation. This needs to be clear and easy to follow (no massive "original message" bits tacked onto the bottom of every reply like happens when clients using ZenDesk hit "reply" in email.) It would also need some sort of notification when the grantee sends us a message. Has anyone had direct exper

Hi all,A couple of users on my bases are making edits on the base, such as ticking a check box or adding a comment to a record, then when they return to that record the next day their changes have been removed, ie the checkbox is unticked and the comments are gone. This is causing some quite serious issues as we rely on these manual check boxes for quality checking. Anyone come across this issue or have any advice? Thanks. 

Hey Guys, Know of any resources on how to establish and maintain this sync? Can via code in python or a 3rd party solution. Preferably w/ MySQL. Thank you and cheers!

Bonsoir,Je souhaite lier la colonne case à cocher : Classée, avec la colonne Prix, pour que dans la colonne : Prix collection, apparaître le prix uniquement si j'ai coché.J'ai mis la formule : [SI ( {Classée} = 1 ,

I used to be able to allow users to create new records on linked fields but now I can't find this functionatlity. There was a toggle, editible and allow users to create a new field. This also applied to single select or multiple select categories. Is there a way to turn this feature back on? 

Hi, I'm trying to track accounts added or lost over time. I want to be able to view this data by week, month, quarter, or year and compare it to the previous period. How can I set this up? Base contains Customer Name, Added Date, Lost Date among other information. 

mainly a tiny rant. but i pretty much always create a new table from scratch. and Every. Single. Time i have go in and delete the extra fields that airtable always includes. i don't want Notes, and user, and status and whatnot.if it is "from scratch" it should have just the primary field. 

I work with a team and we have a field that we write notes in it (I don't like the comments section), the field type in Long text. It is very easy to accidentally delete contact from it. I want to defend it from this by demanding the user to manual saving the changes in the field, i mean like without auto save, that a user will have to hit Save button in order to modify the content. Is it possible? and if so, is there any built-in tool that i can do it with or we will need code / other external tool. By the way i know that we can Undo actions with Ctrl+Z but the problem is that we are not always notice that we've accedantlly deleting something. 

I have a problem with the embedded view where I cannot show more details from a second table that I have more detailed data in.My workspace has two main tables:1. master view of all data at a high level and2. components view - records linked to records visible in the master viewI have embedded the master view on a webpage, but can't show any of the details from components view on this embed.Only the title of the record is visible. It is not clickable.I want the record to be clickable so that an additional layer of data is visible to users.This quick screengrab video might help:https://share.descript.com/view/yNRTx9z4mRu Any help would be greatly appreciated. 

Good afternoon everyone! I’m trying to create custom currency conversions for a project I’m involved with. We’re traveling around the world selling concert tickets at the door of the venues, and each country has a different currency. I want to be able to take the ticket price for each country’s currency and convert to USD which will then be displayed on that record. I’ve seen this script is available to convert currencies, but I don’t know how to make the currency type dynamic as it only seems to show a single currency in the example. How can I edit line 7, where is says “GBP” to take the currency abbreviation from a field that exists within the record (ex, EUR,NZD,AUS). Any help is appreciated!!