Ask the Community

Hello,I'm trying to create a "Sign Up Page" using an Airtable Form, however, it's not working like I want it to :).I have 1 Table which is the Available Time Slots, and 1 Table which is the SignUps & associated SignUp Form.The problem is that I want my Linked Record (Available Time Slots) to show up in a Grid Format on the Form (either Old Forms or Interface Forms), however, the only option I seem to have is a "+" sign that says "Add Record" that gives a Drop Down menu. Is there anyway I can customize this to display in a better format for folks signing up for a time slot?For example, a list with radio buttons? A grid with a column that has a "Sign Up" button?I'm exploring the possibility of building a SignUp app in Airtable, and using automations, record #s, and pre-filled forms to allow people to self-service their needs like cancelling a session.Ideas are welcome!TIA,ML

I have multiple tables that deal with budgeting, and in each one I've got a similar setup. I track the total budgeted and then how much we've spent manually, then a formula determines the difference and another formula looks at that difference and determines the status of the budget. It works great 95% of the time and looks like the below.Total BudgetedTotal SpentDifferenceStatus$100,000$100,000$0Matches Budget$500,000$650,000-$150,000Over Budget$300,000$200,000$100,000Under BudgetThe problem I'm seeing

Hi y'all,I'm trying to build an airtable base for a concert promoter. In one table (Current Shows), I have the shows they are working on, as well as fields for all the info attached (ex. artist, venue, show date). In another table (Ticket Links), I have a form for their ticketing team to add ticket links. I've built the form so it asks for the artist, venue, show date, and ticket link and it pulls from all existing artist and venues that the promoter works with, so none of the inputs are manually added (except the show date). I'm working on an automation that ideally says: whenever a ticket link form is submitted, find the record in the current shows where artist, venue, and show date match. Then, input the ticket link. Below are the steps I've taken. The automation runs successfully when I hit "Test automation" or "Run as configured" but fails to run on my Update Record step, giving me the error "Received invalid inputs".Trigger: Wh

Hello there ! 🙂I'm using a dashboard type of page in a interface I'm using to onboarding new team members. I would like to combine 2 types of things in that same page of the interface : A grid view of items they have to read / review for their onboarding process (ideally, this would be editable by them without having to open a record)A calendar view of the meetings / trainings they have to attendHowever, I can't seem to find a way to have a calendar view while using the dashboard interface. Is there any workaround for this or is it just that I can't find the way to do it? I'm still kind of new to using interfaces.Thanks so much!

I insert one field from a query as a Grid in an e-mail using Automations.  This results in a single column listing the retrieved records which is what I want.  However, the column only goes about 1/3 of the way across the e-mail.  I'd like it to go all the way across but I can't find any way to set the width of the column.  Is there a direct way (via a setting) or a workaround that would make his possible?   When I try using List instead of Grid, I get too much space between lines.

HI i want to ask some questions i have a two table Product and Category, in product i have linked to another record field with the name 'Categories' and i want to filter the record in Product table with id that i have in Category table i have tried this but it's always return empty records. https://api.airtable.com/v0/<basedid>/<tableid>?filterByFormula={Categories}='recVXBZfPO530BgxK'Do you have any solutions?

Hi,I am trying to extract text and date from subject field in gmail into two seperate fields but I can not get the formula right.The subject will be in this format  "16610 6/9"16610 should be extracted as text into seperate field and 6/9 into date field (september 9)Can anyone help?/Michael     

Hi Everyone, I’m just getting started in Page Designer and have two questions that will aid my workflow: -Is it possible to save a layout to use on other tables? -Is there a way to create pages from a selection of records in a table? I’d like to be able to use this extension to send pdfs of selected records within my table, tailored to each client. I’m still getting a feel for airtable, so if you can think of a better strategy I’d love to hear it. Thank you Josh

Hi, I am looking for some help with a formula that assigns a specific shipping box to a product based on product dimensions. I have a table for Products and Boxes. The example dimensions of 2 product are: Product 1 : 50cm x 40cm x 5cm Product 2: 80cm x 60cm x 8cm The products will be assigned to one of these two example boxes: Box Size 1: Fits products measuring (40-60cm) x (30-50cm) x (3-6cm) Box Size 2: Fits products measuring (60-90cm) x (0-70cm) x (7-9cm) I am having trouble with the IF or IF/AND formulas. Any help would be appreciated. Thank you,

I am newish to Airtable and the person that built it for us no longer works or has access to it, one of our forms is not working and comes up with a error message, how do I fix this as I have had a hard time connecting with support team.

I have a record that triggers the creation of up to 3 records. It may need to create any combination of those 3 (which is 7 possible combinations), which is proving convoluted with the options I know of with the automation options.1) Have 3 different automations with the same trigger for each of the 3 records that might need to be created - i.e. automation 1 creates record a (if required), automation 2 creates record b (if required), automation 3 creates record c (if required). 2) Create 1 automation with the 7 different combinations as conditional actions. This is the set up I have now.Option 1 is wasteful of automation runs and automation spaces for our plan.Option 2 is convoluted and time consuming to set up. It seems like there should be a more elegant way to do this? I'd like to know for future automations I may need to create, especially if they get more complex (each extra possible record to be created ve

Hi,I am new to Airtable and now very tech savvy in general so I'm sorry if this is an obvious question.I have a table with a list of my discovery calls and then I record when these turn into paying clients. I want to summarise how many sale I make per week and per month. When I did this in excel I created a separate sheet that had the weeks of the year listed by date and by week number. Then I set up a formula to capture all sales made in that specific week. How do I do this in Airtable?Thanks!

Hi everyone,I’m encountering some challenges with defining a rollup field that combines data from three tables in Airtable. Here’s the setup:Buildings (fields: name, etc.)Employees (fields: name, hourly_rate, etc.)Timesheet (fields: employee_name, building_name, day, hours, etc.)I want to create a view that summarizes the total salary for each employee in each building. The view should include the following fields:employee_namebuilding_nametotal_salaryThe total_salary should be calculated as follows:Employee.hourly_rate * (sum of all hours in the Timesheet where building_name matches the building in the view).Can anyone provide guidance on how to set up these rollup fields and calculations to achieve this view?Thanks in advance for your help!

I am building a task list where the same daily tasks are completed each day, so I have a list with around 20 tasks or so, with links and the time they should be completed etc. However, there are a couple of tasks, such as client briefings, that only occur on specific days of the week - is it possible to get it so that these tasks only show on the day of the briefing in my interface, not everyday?

Hi All,We are considering using the Embed view as HTML tab in Confluence to showcase the project data.My question is it is possible to customize the embed view (not only the height), for example not to display a certain tab?We've considered using the Interface for this task but it has Embed view only for the premade presets, which would not do the work for us.

I've seen iterations on this question, but never an answer that works for my case.I have a base for newsletter management. Two tables in the base (others omitted for clarity), one to track and manage the weekly newsletter (author, topics, etc.) and one for events and holidays in our community.I'd like to put them together into a master calendar. I have been trying to do it at the field/formula level on a new table, but can't figure it out. I only need two fields, the date of the entry, and a subject or name field.I think I could solve this if I could get a calendar view to subscribe to another calendar view's exported iCal URL, but I can't figure out how to do that either.Any help? 

Airtable

Hi everyone,On my Airtable App, I have an Admin timeline view on a page that shows all tasks, grouped by project, client, etc that only I use, which lets me see all activity. All users have access to a seperate Task dashboard that shows their assigned tasks, etc.  but if I am in my Admin timeline view, and try to assign a task from there, it won't let me as it says the Assignee doesn't have access to this interface.The only thing I am updating is the Assignee field in the task, so it surely shouldn't matter that the assignee doesn't have access to this specific view I am using to delegate tasks?Any thoughts / workarounds? For reference, when I try to do this, the 'invite user to interface' pop up window appears with all of the sharing options, etc. and it doesn't let you continue to add the assignee without sharing. If you cancel from that pop up window, the assignee window just stays blank. Thanks!Ross

Hi, I'm running an automation that monitors a table for certain fields and when any of those fields get updated, I want to run script that sends those field values to an external platform, via an API call to that platform. I know how to write this script, however I can't figure out how to reference the specific record whose field was updated. Is this possible?Here is a screenshot of my automation. 

I need to calculate the number of days a ticket was open, but excluding weekends.However, Airtable wont let me change my work days to be Sunday-Thursday.What formula can I use as a workaround, to count all days of the week minus every Friday and Saturday of the year?

Hoping someone can help, I saw in Airtable's 'What's New' update in July that if a formula returns "a boolean (true/false), a new formatting option lets you output the result as a checkbox instead of a number". This would be really useful for me, but I have tried multiple ways to do this and have not sound it possible. I know Airtable's checkboxes mostly use 1 for checked and 0 for unchecked, so have tried outputting formula as a 1 or 0 for true / false, but no luck (tried "1" / "0", "true" / "false" etc too). Here's the screenshots from the 'What's New' page, if anyone has had any luck with this, help would be really appreciated. Thanks Matti 

Is there a way we can share a link to an interface but either:1) Is password controlled but does not require registration to Airtableor2) You can register but it has to be to a custom designed pageI saw this: https://airtable.com/invite/l?inviteId=invYu3ePl9Fdnqzlm&inviteToken=4ebae32984cd6868bed1d98b72df6d7b948b05e06eed6c7fc0fa24055192010f&utm_medium=email&utm_source=product_team&utm_content=transactional-alertsIt was marked as completed but wasn't really!

We have an Airtable base that we would like to display in WordPress. It should be filterable, sortable, etc.; and we should be able to style it as we please. We do not want to simply embed Airtable as an iframe.

I am trying to send all records in a to do list base to someone once a week.  When I find the view in the automations and test its not showing all the records. It just showing ten and won't send all the records in the view that I want to send out

Hi Airtable Community.Now, I use "When a record is updated" trigger in my automation and I want to use only the data of updated field for sending notification to my team member.Concretely, my table has 3 fields which are "Assignee_1", "Assignee_2" and "Assignee_3", and when someone update one of these 3 fields, I want to send the notification to only the member written in the updated field.However, I don't know how do I get only updated field data.If you have any good solution, please let me know.