Other Questions

Hello, I am new here. I’m a French person, so please pardon in advance if my English is not as it should. I have been in 3 days and not managing to get to a solution. I use the template Script Create records for multiple templates from Airtable templates. It used to work super fine. I have a table called TypesMission that list all the sorts of Missions I have to manage (like Projects). Then there is a template table for the Missions, called ModelesdeMission from which the data come and generate records in the Taches (tasks) table. The script runs from a button field in the Missions table (junction table linking the clients to the tasks). I am trying to upgrade the script to enable me to copy by program 2 fields in the child table : one is a singleselect, the other a link field. This would allow me to further automatize my workflow. In singleselect I store the ‘Responsible person by default’, I would like to have it copied for each task created in the link field I store the Dependency

I’m working on an AirTable system that someone else started for me, and learning as I go. I’ve got 3 Tables. A = Staff, B = Assets, C = Access. On Table B I’ve got a Link Field to table A, so I can add a Staff Member’s name in a new record, and then add an asset against their name. I’ve also got a link field in Table A, linked to Table B, and it shows me a list of all the assets assigned to that member of staff. This was already made when I took over and works perfectly. As soon as I add a new asset and assign it to a member of staff, the asset is added to the list of assets in the Staff table. I’m trying to create the same effect in in Table C. There’s already a link field where I select the staff member name, and then I assign them access rights to certain software. I’ve created another link field in Table A, expecting it to self populate with all the different software that the employee has access to. But it just sits there empty, waiting for me to manually select the software. And

Hello - I am using a simple formula of: DATETIME_DIFF({Today},{Start Date :star: },‘days’) to calculate the number of days from the Start Date to Today. I would like to combine an IF statement to do the following: I only want to return a number IF the Field ‘SOP Status’ contains the words ‘On Ramp’, otherwise return a blank result. Any help is greatly appreciated. Thank you

A Quick Prelude This morning, I was blankly staring past my monitors in a strange state of disassociation. On my screen was the commit history of a substantial git repo. While clearing out stale branches, I went down the rabbit hole of examining each engineer’s stylistic approaches. Commenting out versus deleting old code. Writing references to previous commits in comments. How some engineers write intuitive variable and function names, while others might name them rather generically. While some of those examples get called out and corrected in PRs, it left me with a lingering curiosity about our stylistic and functional choices when working with Airtable. This is a rather open-ended discussion, but I wanted to open it up to see how everyone likes to do things. It could be anything. There are some things that I’m personally curious to know, but I’d encourage anyone to jump in and share anything that you keep in mind when you are planning, building, implementing, and working within Ai

Hi there, I run a charity with volunteers who help feed and medicate local street dogs in Thailand. I am trying to create a database to keep track of their medical expenses. There are two types of expenses at the vet: medicine and vet fees. I’ve created an “Order” table, which connects to two respective “Line Item” tables (medicine & vet fees). In main grid view, the Order table works as expected. For example, I can create a new order, then add line items for medicine and or vet fees. Then those line items are rolled up and gives a grand total. The problem is in using the Form view on the Orders table: I can add existing records, but cannot create new ones, which is necessary. I really would like to use Form view so that my volunteers can enter data easily without really having to get involved with the grid view. Also, it would be really useful if the form could display calculated fields. This could show calculations like Grand Total. These calculated fields simply do not appear at

Hi I would like to use the extension to convert URLs to PDFs. It works for sharepoint URLs but I can’t get it to work for google docs - any idea how I do this? thanks! Clare

Hey there! So I am wondering if there is a way to hide specific options within a field. For example I have one Multiple Select field which features start and end dates for film festivals (1 - 10 Sep 2022, 2 - 20 Sep 2023 for example. In my main view, I would like to view all these options as it is a handy way to look back at the years for previous festival years. However on separate views, I would like to pick and choose which options appear, for example if I am sharing a view with a client and only want to talk about 2022 dates, I would love to hide the 2023 dates to not confuse anyone. If anyone knows an answer please let me know!!! It seems you can hide lots of things including fields however hiding options within a field is very tricky. Thank you!

I have a field with multiple select; I need to get a count of EACH selection AND would like to display each response with the count. For background: the field is part of a survey and those filling out the form choose all that apply to them. I tried the linked field route and it counts everything in the field; doesn’t separate them. Do I have to do a linked field for EACH option? I’ve looked at several related items in the community but it all reads like a foreign language that I don’t speak to me…

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