Other Questions

Hi all! Totally new to this, and I am struggling to set up my bases in the way I’d like. So far, I have three bases: Orders, Customers, and Books. Customers has minimal info, like name, unique customer number, email, etc. Orders has much more info: a unique order number, customer number, and survey answers to questions (the ones I’m specifically looking to utilize are genres and subjects). Books is just a database of books, with specific fields using tags for genre and subject. What I want to do: In Orders, if a customer chooses WWII as a subject, I want to see all the books in my Books table that are tagged WWII. Same with genre (example, see all books in Books tagged with mystery). Basically, I want to see suggestions for that customer (the books I already have data for that might be a good fit for that customer’s order). Then, once I choose which books to send them, I will need to add those items to a new field for that unique order. In Customers, I want to view a customer and

Over the last couple of months, i’ve shared many emails in which there is a link of an Airtable form i created and that is linked to a Base. Unfortunately, more and more people can open the form but, when they start to write in a field, the answer is immediately erased. Hence, they can’t submit it because they are compulsory fields. Where does the problem come from ? Thank you

Hi all - I know dates and timezones are complex, and I’ve tried to do my homework but I’m really stumped. My end goal is to identify records created yesterday and send off a notification. To start, I’m attempting to calculate how many days are between Created Date (w/o time) and Today (without time). Ideally, I would say if Today - Created Date = 1, then that record was created yesterday and I can filter on those records in a view. Trial 1: ‘Created Date’ is set to use GMT for all collaborators, and does not include time I created a formula variable called ‘Today’ with formula “TODAY()”, which is set to use GMT for all collaborators and does not include time. The value shows as 8/31/22. In a formula field I compared the 2 dates: DATETIME_DIFF(Today,{Created Date},‘days’) For both yesterday and today, the value of that comparison was zero with Detail: today is 8/31/22. The record created yesterday on 8/30/22 had a calculated value of 0. The record created today on 8/31/22 had a ca

Hi i was wondering if their were any specialists in London that can help a new company onboard onto airtable as our new workspace

I want to create a poll where users can vote on their favorite local X each month. It needs to: Have a name and address. Add photos and links as an added bonus for advertisers. Vendors can be added as the voting continues. The template can be changed each month. The votes are tallied by the program and can be seen, or not. What do you suggest?

Hi, Can my custom extension receive incoming teamwork.com webhook ?

First time poster! Wondering if there is a resource in existence around punctuation characters that should be avoided in Record names Single- and multi-select options Any other field types! As well as potential issues they may cause (in base syncing, linked records, fx fields etc)? For example, on my account for work, I manage/support several base syncs that involve linking records to synced records and I know that when we include any commas or quotes in record names it will create issues w/linking and syncing with duplication of information syncs through under new record groupings which will have quotes around the duplicated record name. We haven’t been able to figure out if apostrophe’s create issues but so far it seems like they may not (fingers crossed!) Additionally, I’ve observed that including commas in single- and multi-select options have created issues as well. But it seems like parentheses are fine! Right now we’re kind of just guessing and hoping what we should avoid and

I’m very formula challenged… I run a halfway house and I’m working on automation of the rule violations sheets. For each violation, there is the first consequence with a date duration and a second consequence with a date duration. Example: Late for Cewfew: 1st offense no passes for 14 days. 2nd offense no passes for 30 days. I have the duration formulas figured out, but I need to link them to another table only showing the current duration end date. I’m wanting to create a Current Offense End Date. Basically, If the 1st consequence end date is empty then I need it to enter the 2nd consequence end date. I hope that makes sense. I just have not been able to figure it out. Thanks in advance for any help Kathy

Hi, I have a base for all of our book projects. Each book get a tab in which I work with the Gantt view. Can I do a sync of all the tabs into a new tab with the same Projects base to see all the Gantt view at once or should I record link somehow? Thank you.

There was some recent update where comments from the notification bar open in the interface they were created in… when I get to that interface, there may not be a comment block for the table the comment is in, and the record may not even be in the table anymore due to filters. It is quite a big effort to read all the comments that have been directed to me, involving remembering the record name the notification cited, finding and opening that record if it is still on the interface, or tracking it down in the base if not.

Hi all. I am attempting to embed a grid into a WordPress website and it seems that there is a width limitation. Is there a way to increase the dimensions of the grid in Wordpress? Thanks in advance.

Hi! This isn’t much of a support ask as it is a request for certain features, so please bear with me. I am sure you have heard payment integration for forms a gazillion times, but that and pagination for forms would be great. I, unfortunately, must create some long questionnaires and it would be nice to have pages within the form instead of the long scroll. Thanks for all you do!

In the documentation it is provided that we can do a conditional roll up. But i can’t see the option in the tool. Attaching the image for reference.

Not sure these types of posts are cool here, I initially asked this same question over in Reddit but didn’t get much help, so I’ll try to keep this as brief as possible. Anyways, I started at a company in March assuming it would just be a part-time role as one of their drivers, however I used my Airtable skills to build a really basic driver app (AT + Softr) which helped me land a unnamed and unstructured promotion. All that was proposed was moving to the new marketing department and helping to establish structure. I now spend most of my time rebuilding internal workflows with Airtable while also creating a company knowledge base (in Coda). Recently I was asked to come up with a name for my title, but I’m kind of stumped. I don’t have a formal education beyond an Associates and I don’t have any professional credentials (eg. project manager, engineer, etc). Are there any titles you’ve come across that help clarify / showcase the value we bring with tools like AT and others. Any help / a

I can not figure out how to set the ‘Today’ date to my local time, so in my Gantt view, the blue line is always a day behind.

Hello, I have an issue with airtable calendar views: For each records of the table I have 2 event (IN and OUT), and for each event a collaborator (can be the same one but most of the time collaborators are differents from IN to OUT events) I want to have calendar view for each collaborators with only the event there are responsible for. But when I filter, it’s not working well because it’s also showing the event where the collaborator was for the IN but not concern for the OUT (not easy to explain) For exemple: I have a record: Ms Bond From (IN) 23/08/22 to (OUT) 25/08/22 For the IN event: collaborator is Tony For the OUT event: Collaborator is Elon I created a calendar view for Tony and an other calendar view for Elon In the tony view i filtered “Collaborator IN = Tony, or Collaborator OUT = Tony” In this view i see the IN event: normal Tony is in charge, but i also see the OUT event, because even if Tony is not in charge of the OUT event, he is in the record, and so airtable show the

Hi our homepage views have suddenly gone blank displaying no data - if we apply a filter the relevant data appears but without a filter nothing is showing. Personal view are not effected. This is very troubling - we initially thought our whole database was lost. Please can you help us understand why/how this is happening and how to prevent it happening in the future. many thanks Clare

I took a little break from the business. Now that we are starting back up, all the bases and information linked to my account are gone. How do I regain them?

Im looking to create an extension that shows dropdowns for various fields in my base, but I don’t know how to make the dropdowns appear within the extension. I’ve tried returning the select field as well as using it with a FormField but neither approach works. I’m unsure as to how to make the dropdowns appear in the extension

Is it possible to add day before date?

Hello, In my base I have 2 tables: Users and Emails. They are linked together because one user can have multiple emails. Users Id|First name|Last name 1|John|Doe 2|Sam|Harison Emails Id|Address|User id 1|john.doe@gmail.com|1 2|sam.harison@gmail.com|2 3|sam.harison@yahoo.com|2 I want to create a form in which user has to provide first name, last name and one or more emails. How can I achieve this in Airtable? Of course after submission data should be stored in tables with correct relationships.

A general question to the Airtable community, what is expected when email notification are switched on and a mention is done in the comment section on a record. So far I have been unable to make this work between collaborators - and not sure what I am doing wrong. I don’t see anyone else with this issue so believe it must be me. Is the email instantaneous - or with delay? Many thanks.

Good Morning! I have a project field that is synced externally and uses a formula. I wanted to use that same project field (with the formula), to link to a tasks field. For some reason, I cannot link the Project Field to my Tasks field. The Projects field does have automation as well. Any tips?

Hello everyone. I have a base with several tables and collaborators. I need to restrict viewing a complete table or several columns within a table from some collaborators, but at the same time that table or columns should be visible to other collaborators. Can anyone help me to find a solution? Thanks in advance.

Hi Everyone, I have a start date field and a duration type field and I’m trying to create an end date with a formula DATEADD({ :gear: Appointment Start Date},{Duration},‘minutes’) This doesn’t seem to do anything i.e. the end date is the same as the start. Any ideas? Cheers