Other Questions

Hi - I am new to Airtable and am looking to create a form that can only be completed by personnel during business hours ie: 9-5pm on Weekdays. Is there a way to automate these date parameters within Airtable? Thanks!

I'm running a handful of automations with Zapier and am now getting a 429 error for too many requests.I've turn off EVERY automation related to AirTable. Nothing has run for 4 days. But I'm still getting 429 errors, despite AirTable docs saying to wait 30 seconds. Any way to reset this? Or anywhere in AirTable to see a log of API requests so I can figure out what might still be hitting as an API request?

I can’t access my bases. When i try, I get “An error has occurred, Refresh the page” and when I click on the provided “contact us” link, a very general page opens without contact options. Now that page is not accessible and results in a 504 error. The “error has occurred” message is accompanied by an error code of  pgluwBBDyL62GtnawThere aren’t any other ways to check status of Airtable, and this is directly affecting my businesses day to day operations. What can I do?Thanks.

I’m using airtable as a project management tool amongst other things in my business. It’d be really great to have the time in a date field default to 5:00PM (EOD) for every date entered instead of the current default which is the current time. Is there a way to do this other than using a formula as I’d really like to use the new timeline feature which doesn’t seem to support formulas. Thanks for the help!

I have a requirement to delete all records from my Airtable base. Currently the documentation says I can delete only upto 10 records from a single request. Is it possible to delete all records at a time (Instead of sending multiple URL’s with 10 records id’s each)?

HiCan I get some advice on a simple Swimlane Application or tool for a beginner, I have been using sheets of paper up to now, but need something to help with a workflow that is a little bit more complicated with more stake holders.I have created a list of tasks in a google sheet, assigned stake holders, and grouped tasks for an Aircraft Maintenance Inspection input to a Maintenance Repair Organization (MRO), Pre Maintenance Input tasks, Arrival tasks, During Maintenance Tasks, Departure Tasks and Post Maintenance Tasks, I now need something to sort them out into swim lanes.

Message:Hi everyone,I use Airtable daily to manage multiple bases, and I’m looking for a simple and reliable way to back up everything, including: All tables (with data) Automations Scripts (via Scripting app) Interfaces My goal is to regularly back up my entire workspace and be able to quickly restore it in case of any issues (human error, accidental deletion, etc.).I’m open to all suggestions: tools, third-party integrations, API-based methods, best practices, etc.Ideally, the solution should be easy to automate or require minimal manual effort.Thanks in advance for your help!

Hi,I have a simple airtable-database ad datasource for my Weweb-project.Everthing worked fine until a few days ago, I get a 422-error in Weweb "insufficient permissions" for only one of my records.The Weweb-community replies this error is generated by Airtable. Here's my post with the different screenshots : https://community.weweb.io/t/workflow-axioserror-422/18932/3My question: why does this only happen with one record? And how to solve it?

As I typed this, it was 11/17 2:45 pm in my time zone (PST = GMT - 8). What I want is to get a field that return what today’s date is in my time zone. I have tried the following fields: TODAY ( ) – GMT contains the formula TODAY () with “Use the same time zone (GMT) for all collaborators” toggled on in the formatting tab TODAY ( ) – not GMT contains the formula TODAY () with “Use the same time zone (GMT) for all collaborators” toggled off in the formatting tab TODAY ( ) using SET_TIMEZONE contains the formula DATETIME_FORMAT(SET_TIMEZONE(TODAY(),‘America/Los_Angeles’),‘MM/DD/YYYY’) (with no option to set formatting available): What I get is the following (again, when it is 11/17 2:45 pm in my time zone (PST = GMT - 8)): TODAY ( ) – GMT: 11/17/2020 12:00am TODAY ( ) – not GMT: 11/16/2020 4:00pm TODAY ( ) using SET

Hi all - anyone receiving an error when trying to access a base within your workspace? 

Hi all! I’m relatively new to anything beyond simple in Airtable, but I’m learning through trial and error. I’ve ran into a problem I can’t solve though (yet) and would greatly appreciate any and all help. When using the following formula i end up getting error messages. IF( {Kontroll intervall}="Varje vecka", DATEADD({Senast kontrollerad}, '7', 'days'), IF({Kontroll intervall}="Varannan vecka", DATEADD({Senast kontrollerad}, '14', 'Days'), IF({Kontroll intervall}="En gång i månaden", DATEADD({Senast kontrollerad}, '30', 'Days'), IF({Kontroll intervall}="Varannan månad", DATEADD({Senast kontrollerad}, '60', 'Days'), IF({Kontroll intervall}="En gång per kvartal", DATEADD({Senast kontrollerad}, '120', 'Days'), IF({Kontroll intervall}="Ombyggnad, ej aktuell i nuläget", DATEADD({Senast kontrollerad}, '60', 'Days'), IF({Kontroll intervall}="Ej evenemangshemsida", DATEADD({Senast kontrollerad}, '365', 'Days'),

I’m not sure exactly what group to put this in but I am trying to build out a form that allows you to “pick a speaker” from a list to effectively vote for them. I was wondering if there was any way to show more information when trying to pick a record in a form, ideally the cover photo would be best but anything would make it easier. Here is the “speaker” in question (it’s me!):

Hello, i created a project and all was running correctly.. i had to delete it to re-create it inside "my first workspace" and now i get error "airtable team plan cannot run script on your current billing plan" ..so,first: how can i get script running again?second: why i've been billed $24 if i'm on trial team plan?third: i see 10 days left for my free trial; In case I regret the purchase, how can I get my money back?Thanks

I changed the primary field in a source table. I also want that to be the primary field in an existing synced table, but the primary field doesn’t change.If I go to “Update sync configuration” and then “Edit synced fields”, then select “Specific fields in the source...” it does not give an option to change the primary field, like you can when first creating the sync.I’m syncing a view from the source table, so I could create an identical, duplicate view there and then change my sync to point to the new view, but I worry about how that will impact all the lookups I have configured. Will I need to redo them all, even though the fields will actually be the same? So I’m hoping there’s a way for the synced table to use the new primary field from the source.

Is it possible to export a revision history? And if so, can a specific date range be specified?

Hiya! New user here, so forgive me if I’m being silly! I’d like to limit character input into forms to a certain length (let’s just say 32 characters for argument’s sake). The proposed form is for clients who want to submit product descriptions to an app (hence the need for character limits). Now I could go through and check each one individually, but it’d be great if I could just set a limit warning instead. I read this previous post: https://community.airtable.com/t/limit-characters-in-long-text-field/7353 but it still doesn’t solve the client-facing form issue. One thought I had was another app integration? I haven’t checked if this is possible yet, although I suspect I’ll fall into the same character limit problems. Has anyone got a suggestion or a neat way to make this happen? I’d be much obliged! If you don’t think it’s possible, please leave a comment saying so - it’d be great to know either way!

I'm creating a form and need to create some conditions to separate our large inventory into categories.  When I create the form view from the data table screen, and run a test the dropdown looks like the first snip below and appears to enter the data sheet with all of the correct information.  When I add a new field and link to record, choose the same table, set up the conditional formatting and run the test, the dropdown looks different (second snip) and all of the information goes into the data table except for the name.  As far as I can tell they are set up exactly the same way, the only difference is the Product ID field is automatically entered when I create the form view.   Any ideas on what I'm doing wrong or how I can properly duplicate the product ID field? 

So I have a table called Investors. Say there are 300 records here. And I have a table called Companies. Say there are 100 records here. And I have a tabled called Individual Investments. It’s the intersection of Investors and Companies. An investor can invest in any deal they choose and invest any amount. So I might have, say, 2,000 records here (but obviously I wouldn’t have more than 30,000 — which would be if every one of the 300 Investors invested in every one of the 100 companies). In the Individual Investments table I list the Investor, the Company in question, and the amount they invested. We’d like to send a report to each investor that lists all their investments and how much they invested. I once figured out how to put this together in the Page Design block and I’m sure I can muddle my way there again (or come here for help)

Hello! First time user of Airtable, so bear with me:grinning: I have a Long text field that I am trying to limit the number of characters entered into it. From reading the the posts, it looks like that is not possible, correct? In another members post they suggested using LEN and COUNT, but I’m not sure how to implement it. From what I’ve figured out so far is that I would need to create another field (a formula field) to count the number of characters (including spaces) from another field in the same record. So, let’s say my long text field was named Product Description. What would be the formula entered (in the new formula field) to do a count of characters? Also, would the character count show in the new field and change as I’m typing in the product description field? Or if there’s another way… Thanks! Sue

Hi there,I wonder whether there’s a way to bulk print selected records with a page designer template. Currently there’s only a way to print either current record or records of a specific view. The problem: When the view contains more than 30 records it ends up in a browser freeze. So I wonder what possibilities does the community see to solve that. Thanks for your help,Florian 

Has anyone successfully engaged with the Airtable sales team via email? I have submitted the "Contact Sales" form about 5 times over the last month or so, here: https://airtable.com/contact-sales?ref=htcs.prd&_gl=1*1555h4p*_ga*MTkwODg1MjkwLjE2NjY5NjkwODA.*_ga_VJY8J9RFZM*MTY5NzU2ODA3OS4xNS4xLjE2OTc1Njg3NzAuNTcuMC4w Has anyone successfully gotten in touch with a salesperson to get pricing/information about an enterprise plan?

Hello everyone,I am experiencing lag issues across the different interfaces I provide to my users.Pages take a very long time to load, which makes it difficult for my colleagues to manage their work.Do you have any solutions or advice to help minimize the loading time between pages?Best regards,Zeel

hey all,I try to render an image in page designer. It works fine for uploaded images but if I only have an Image-URL - How can this be shown on the page designer. Thanks for your helpFlorian

How many rows/columns/cells can Airtable handle at its maximum limit? For example, Google Sheets can handle up to 10 million records. What’s the limit for the Airtable?

I have 2 rollup fields in a table that are formatted to show ARRAYUNIQUE(values). I am trying to create a formula column that combines these values in an array, and only displays unique values. I was trying to use: ARRAYUNIQUE({Rollup1},{Rollup2}), but am only getting the values from Rollup1 to show up. Help?