Other Questions

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”.

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.

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 experience with any of the portal-creation add-ons to

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!

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 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. 

Hi, I've setup a form and I'm unsure why the pretty simple directions for "Enabling form redirects with record_ID" section from https://support.airtable.com/docs/applications-of-record-functions does not function correctly. I have gotten this to work on other forms in the past, and I'm wondering if there's some obscure reason why it won't work for this one?The redirect looks like it goes to a url with an appended newly generated rec but then it is a 404. Seems odd..Thanks for any help, much appreciated!

Hi, it's been more than two weeks since I raised this issue. My issue in upgrading the base to team Plan is not resolved. I am nearing the project submission deadline. Kindly help. @dashler78

Hello,I want to upgrade my account to a Plus plan.However, I receive the following prompt:"We were unable to upgrade you at this time. Please refresh the page and try again. If you continue experiencing problems, please contact us."Please advise.

I am receiving this notice when attempting to upgrade: "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 would think a financial ticket would be considered important. 

Hi there, Looking to create a static webpage using github pages, with Airtable as a database. Has anyone here have a solution for keeping the API key out of the static files? I’ve read that using a serverless function as a proxy with a jwt can work; but not sure where to start with that. Cheers,

Hi there, Looking for some help with conditional logic in forms please. I'm creating forms with conditional logic in the main airtable base, but when I add that form to an interface the conditional logic doesn't work and isn't visible / manageable from the interface. What am I doing wrong? And how can I publish a form via an interface with conditional logic on it.  Many thanks 

I have some projects where I routinely (once a week or so) have to make a survey that fills out an fields in Airtable.  The surveys are mostly open-ended, so there are lots of long text fields.I share these externally by, currently, simply creating a view and sharing a link to that.Not the best, since it's hard to see the questions themselves (contained in the name of the field) and there is so much text that even very tall fields made quite big get unruly.And of course Airtable interfaces don't do me much good since you have to log in.  I have too many different, ever-changing clients to make anyone do that.Plus, since this is essentially new survey every single time, meaning new fields every single time, I ultimately need any setup involved to be relatively minimalAnyone have any ideas about how to display this sort of info in an easier to read manner? Or am I probably just best sticking with a shared view given the relative ease?

Hello allI know there is no "one size fits all" answer to this question - but I am desperate to get it resolved.Keen on anyones ideas / thoughts on a front end solution for Airtable.  At the moment I use lots of shared bases - which does the job, but I would love other users to be able to edit and comment on records.Requirements are :Ability to edit / update / add Airtable recordsAll data / backend to be stored in Airtable Needs to look clean / classy / professional / snappy - but I would be creating a functional website used to manage projects - not necessarily sell thingsAbility for users (that I invite) to be able to log in and add comments   Only up to about 10 users.  Log in process should be very easy (I like Glideapps method of using an email pin)Grouping a list of data essential (ie - grouping by category / type) - just like you can in an Airtable grid view.Scaleable - initially I want to use it as a simple "Maintenance log" - where users can log issues. &nb

Ok, this may be super basic, but I really need help here. I've got two sets of data: 1. Google Analytics2 aHrefsThe Google Analytics data shows values like traffic, user engagement time, pages visited per session, etc and gives all of this for a single url. The aHrefs data gives data like keywords, keyword difficulty, search volume, etc, but instead of showing all of this data on a single url, it will give 50 of the same url (this is an arbitrary number) because aside from the url, all of the other data is unique. What I would like to do is combine all of that information into a single URL, So if there is one url, it will show me all of the different keyphrases it is ranking for, an average of their difficulty, etc. I need it all in a single record. So far, I've tried de-dupe, but it won't merge the different keyword values into a single field, it will just eliminate multiple of the same, and I'm a weeny with formulas, but tried the CON

I need some way to log (or view) records that have been recently commented on (by me, ideally, but by anyone is probably OK). I go through a base and look at my employee’s work, then ask her questions about it – need to find a way to follow up on those requests I sent via comment so I can see if they have been resolved. Open to some sort of automation/trigger/integration (zapier or whatever) but I can’t seem to find a way to make it happen. Is this possible? I know i could create a separate “comments” table and do it that way but I don’t want to. Thanks!

I have a table and each record includes a name, address, email address, phone number, and relationship. The relationship field is single select, and it consists of parent, student, donor, alum, and staff. I want to generate a report that gathers all of the records that are students and creates a report of each student's name and email address. How can I do this?

Does Airtable support sandbox instances? So for example if I need to develop and test before moving those changes to production, is there a way to do that? What Airtable capabilities allow this? If not, what have people used as a workaround? 

Please community members😔, I'm new here and really need help understanding some things with airtable. In fact I upgraded for the team plan more than a month ago, it told me that my database is full yet I only have one database with 2100 records. I don't understand absolutely anything

Hi, I have a large table with many columns. But some columns are empty whilst some are full and this differs from a row to row. Is there a way to view single row that it would show only those fields which have some value in it and do not show empty fields? As to have a simpler view of the information. Thanks for suggestions!

A few months ago I received an email from product@mail.airtable.com descibing changes to handling of dates and timezones in scripting. Do I recall correctly? Can someone point me to the info it described? I’m still doing manual timezone adjustments in scripts but think this new feature can handle it properly???

Hello,I need help ☹, here a the scenario :"Real Estate" table has several fields (A1,A2, A3=( link(recordId of the "owner" table)), the "Intervention" table has several fields (B1,B2, B3=(link(recordID of the "owner" table) "Real Estate"), B4=(Lookup(recordId of the "Owner" table which is linked to the "Real Estate" table), B5=(link(recordID of the "Owner" table), . list in field B3 based on the equivalence between fields B4 and B5, and integrate this new list into a new field. Do you have any ideas for a formula or automation?I'm building an app with softr and airtable, i'm an owner and i want to create some cleaning intervention in my homes with a formula.   i would like when i whant to create a new record "intervention" with a formula, only show   the real estat list that belong to the owner (me) not all the list of real estat in the database.

Hi I cant get Airtable to load today. I cant get to my boards or even onto www.airtable.com. The page is just white!!! HELP!