Other Questions

Alright, so, I'm asking for help because really i've just tried to do the 100th formula and it just doesn't work, so i'm taking my chances by asking for help. 😭See, what i'm looking for is this:I need to have a calendar view to control a car workshop. The idea is that my call center will receive the calls from my clients, and then, in a record, upload the information of the client (regulars such as which work has to be done, which mechanic will do the job, and so, and so) and the idea of this calendar is:To use this view to see if there's any open gap in the workshop, so if there's a gap between 11am and 1pm (for example), and the client in the phone is asking for a job that can be done in whitin that time span that's available, then the girl helping me can offer that space for the client. That way the mechanics will have more productive hours. I've tried this:Using one grid and doing manually about 36 columns (each one represents 15 minutes), and asking for my c

Howdy,I noticed that since yesterday, when I open a single record and try to "tab" down fields, it takes additional presses of the tab key.I would expect that it would take one tab keypress to go between one field and the nextInstead, I am witnessing it is CONSISTENTLY taking three tab keypresses. I tested this across multiple user accounts, Firefox and Chrome, and multiple AirTable bases. All Windows machines.Related documentation: https://support.airtable.com/docs/airtable-keyboard-shortcuts From here:Is anyone else experiencing this behavior?Does anyone have any suggestions for how to restore the expected "one tab keypress, one field" behavior?

We're trying to help an Airtable user on our team to log in for the first time.He had been invited originally back in Feb. 2020. I'm not sure that he had signed up to get a password—probably not but maybe.When he tries to access his account, he appears to be taken through loops that are dead-ends. When he has clicked on Continue, he got a blank page. So, we deleted his account and created a new one (with the same email address), and sent him a link.When he clicked it, he got an "Email already in use" message. Please help. Thank you!

- I have a report that I am trying to create that will take all my dates request and I can sort by month. Below is my table and I am needing to run a report for the month of march. So what I want is for the provider name to show all the data that happen only in March by the dates in the date requested which is a look up field for the file number that is attached. - Next is 

Like the title says can you add a subscript into text in an automation email.    I have tried the following "CO<sub>2</sub>  but it doesn't work.   I have found that you can add lots of other HTML tags like <b></b> for bold and <p style:"blah blah;"></p> to achieve other formatting outcomes but the <sub></sub> tag doesn't seem to work.Is there a way to do this? 

Hi all, I'm trying to configure a cell to show status "complete" when all conditions are met, and "incomplete" when they're not, using nested IF-statements and an OR statement within that. The formula is not returning anything, i.e. the field stays blank. Any ideas why this could be? I tried both these variations (and also only single conditions to see if it works at all, but the value returned isn't correct - I only got "incomplete", no matter whether the condition was met or not.) Background: {Confirmed? (from Location)} and {Confirmed} are checkbox formats, {Status (from Menus)} is a single value field. I want the return value regardless of whether Status (from Menus) is "Done" or blank. Thanks so much for any hints! IF(AND({Confirmed? (from Location)} = "CHECKED", {Confirmed} = "CHECKED", {Status (from Menus)} = OR("Done", "BLANK"()), "complete", "incomplete"))  IF(AND({Confirmed?&nb

Hi everyone, I have an Airtable base with 17 collaborators. 2 of them are admins that check if everything is good on the base, update records, etc., and the rest of them put each day their working time through airtable forms. These times automatically generate an invoice for each of them at the end of the month with Zapier & Docupilot. The users are all able to edit their personal times during the month so they can adjust the invoice before it’s generated & sent to the client. But they should not be able to see other’s people times. The fact is, in Airtable, as long as you are part of a table (even in read-only), you can see ALL the views and ALL the tables. So I cannot hide the hours of John for everyone except for him with personal views. I partially solved this problem with Stacker, as I configured an interface which is different for every user. John will only see his clients and edit his own hours, and he will never see the clients nor the hours of Alex. It’s pretty good ac

I need help with a date calculation. In a table I have two fields, one with a ‘start date’ and the other one with an ‘end date’. Now I need a third field that gives me all the dates that fall into this timespan including start and end date. For example my start date is May 5th and my end date is May 10th. In the range field I want to have ’ May 5th, May 6th, May 7th, May 8th, May 9th, May 10th’. Going on from there I would need to make a lookup or rollup in an other table to combine all those days from different records belonging to an item. I’m trying to achieve a rental and availability table for our equipment and need people to see at what days something is out of our storage. I wish there was a multiple date select field that would make this so much easier. I’m sure the Airtable veterans have a solution for my problem. Thank you very much for your help!!!

Hello I am attempting transfer checkbox data from webflow form using checkbox fields for multiple selects it returns a value of TrueTrueTrueFalseFalseFalseFalseFalseFalse via webhook what is the best approach to convert the true false value to multiselect - Thank you  A  very good tutorial Webflow to Airtable Easy - Webflow Logic! https://youtu.be/ET2d7hG_DnM  

When I copy and paste a date and time value between 1/04/2023 16:00:00 and 2/04/2023 01:00:00 from Excel to the Airtable, it automatically moves it by one hour (i.e. 1/04/2023 16:00:00 becomes 1/04/2023 17:00:00). The values are being pasted correctly for any other value that is not between the mentioned range. The field that I am pasting is to has a 'Date' field type and there is not day light savings scheduled at my location during that time. 

Hey there. I am wanting to make a field auto-fill depending on whether another field is empty or not. E.g. If someone enters a voucher number in the ‘voucher number’ field, the field ‘cost’ is automatically $0. If the voucher number field is left blank, the ‘cost’ is $100. I’ve tried using the IF function and making it blank but it is saying invalid. Thanks!

All the records in the table are gone.Sad, it is true. But before you suggest that someone made them disappear, I notice that at the bottom of the page, the tracker marks the presence (absence) of 235 records.Are these Schroedinger's records, present and absent at the same time?Has anyone experienced the same problem? Do I turn it off and on again?Best+Dario 

When I sign in with my credentials all i get is the "You Need Access" window. I'm an Editor. I have many views. I need help to get signed back on to my active workspace. I've asked access from the Owner. If she grants me access will I lose all the views I've created???When I request to change my password, it pulls up a very simple and old and practice workspace.Please Help me ASAP. The views I've created are critical to me doing my job!

Facing a CORS error with Chrome it's working yesterday but now stopped working I have already tried on Mozilla and disabled cors for chrome facing the same issue Please provide me the solution for this ASAP

Hi, I am currently tracking the number of people who has RSVP for an event. The view is currently set up:The first column is the nominee's name The next column is Student RSVP (single select with the option of Accepted, Declined, Pending). This column is the supervisor's name who nominated the studentThis column is Supervisor RSVP (single select with the option of Accepted, Declined, Pending)Additional Guest (this is a single line for us to enter info e.g., +1 )Dietary requirement (this is a single line)When I filter "Student RSVP is "Accepted", it spits out the records showing students who have accepted the invite but it does cover the case where if the student "Declined" and Supervisor "Accepted". I also tried grouping them by Student RSVP and Supervisor RSVP. But we still need to calculate ourselves manually to confirm how many accepted, including the additional guest.My question to the community is - is there a way I can better set it up so that I can instantly

Hello! We at Clockworks have done some custom workflow automation work for a handful of clients. Several of them have asked for improvements in approval request flows. Today, we’re sharing three Airtables in the Universe that are derived from some of our work. Feel free to take them and use them for your use case as you see fit! We’re also launching a prototype automation integration service. You can supercharge any of the Airtables we shared by connecting them to this service. Clockworks will pull in data from the Airtable, assemble it into an approval request, and manage the approvals process automatically so you don’t have to shuttle emails or text messages back and forth to get feedback and gather approvals. The final approval results will automatically flow right back into your Airtable. Here are the links to the bases: Clockworks Asset Tracker: Manage digital assets, gather feedback, handle multiple serial approvers. Clockworks Approvals: Handle any kind of approval requests with

Hi Today , Our company lost access to account As a result , our company can’t work at all There are lots of financial data / customer data / lead information and report , documents , server details and lots of other important information of our company Our company send more than 100+ emails and connected them , but there is no reply yet The business loss is terrible today can you please just restore account even 15 min , so we can just download our company data ? Our lawyer and manager is about to sue against this company , airtable , about the business loss Let me know please There is no reply from them we called them as well

I’m not able to find an Airtable example of a simple checkbook register. Balance = Previous Balance - Debit + Credit. How would you do that in Airtable?

I have updated my credit card details but i am unable to upgrade my airtable plan.Following is the error screenshot: Getting this error message 

Dear all, I am new to Airtable and am trying to recreate a simple design I had in google sheets. In short, I have in one table: Days of the week as rows And for each day/row a column with time spend per part of my job (e.g., research, education, management); i.e., three columns. Like this: Now I would like to create a stacked barplot of these three columns. Like this: However, all documentation for both the chart-app and vega-lite app I read so far seem to assume that there is a separate grouping variable, rather than multiple columns being stacked. Is there any way to make this work? Hope it’s clear, thanks in advance! all the best, Frank

Hello Is it really not possible to have the weekday shown in a date field? Seems an odd omission - and the ‘friendly’ date format not that friendly. I know I can use a formula field to format it how I like but a) that’s a workaround and b) I am grouping by date and grouping by a formula field means I drag move records between groups / add new records directly to the group. Airtable DW WOW>NML>Install Schedule (Shared) - Airtable Explore the "DW WOW>NML>Install Schedule (Shared)" view on Airtable. Any other ideas / suggestions greatly received

Testing

Hi! I'm posting this as recommended by Airtable!So we have outgrown our current Airtable Pro plan, yeyy!We contacted for Airtable Enterprise, and as you most know - it's waaaaay out there. I will respect AT and not post here any numbers.Look, I get it - big companies with hundreds of seats are what it's all about for any SAAS.However --- our business is in fact big enough and could easily pay that.But - we don't need 20 seats for what we need airtable right now, and the exorbitant $XYZAB min yearly cost is much more than the value we would get out of the subscription.Just because Elon Musk has the money doesn't mean he would pay thousands for a carton of eggs, right?Anyways - the RESULT and the BIG PROBLEM for Airtable is that our company cannot scale with them and because the data does not fit anymore - we will have to go to another solution.And who knows, maybe it's something amazing and we won't come back when we have the amount of seats that enterprise airtable wants?Just throwing

Can you import your personal fonts? Or is there a way to use specific font types? (Brand Specific) Thanks

Hello Community,I'm needing more brain power to solve an issue filtering a table view.Background: I have field technicians submit a log from their field work.These logs are each pulled into Airtable and have a view that filters to a specific group of questions/answers so that we can use an automation based on how those questions are answered to address any issues.We recently added some new questions to one of these groups.I tried updating the filter to include these new questions, and it behaves unexpectedly.I've attached a screenshot of the filter for the table.The logic would say that if any of the 4 conditions in the condition group were not empty then the records that match would show up in the view, but that's not what happens.As it is now with those conditions set like in the screenshot, I'm missing three records.If I remove the first condition from that grouping (Did a Soiling...), then the missing records are all that show in the view.That follows the logic, as these three reco