Have other Airtable related questions? Post here!
Recently active
I have an AirTable Form embedded on my website. But after submitting I get a message saying “You’ll be redirected to https… in a few seconds”, but it doesn’t work and the form returns. I’m receiving the form data in my AirTable, but the user is left confused. I have filled out the settings correctly as far as I can see. Stewart
I’ve setup a beautiful multi-table Airtable database system for one of my clients, and we’ve got 5 different tables that are all linked to each other & working perfectly. :slightly_smiling_face: But now — we’re interested in creating a form where our volunteers can be in the field and submit brand new data into the database. In other words, this submitted data is brand new data that will need to be spread out across the multiple tables & linked across multiple tables. I know that none of this is currently possible with Airtable’s built-in form capabilities, because Airtable forms don’t currently support: Creating new linked records from a form. Adding new data into a linked table’s fields via a form. So, I know that this can’t be done with Airtable’s native form tools. But I’m wondering if anybody has their “personal favorite solution” for automating this process? I’m thinking of a few different solutions, but I was wondering what you guys have found to be the best solution
Hi everyone,I have an automation where all field become empty everyday. So far it's ok. I made a sort by last modification to find the next day all last changes.I try now to sort (please find the attachement) by type (Légume or fruit) when the total >0 but i can't find the solution. When i sort by type, i have all the type first even the articles with total=0 and i don't know how to make it. I tried to group my table by type or multiple sort but i have the same issues.I want to have by type all products wich are not total=0 and sorted by type (fruit or légume)Thank you so much for your help 🙂
As title mentioned, I got maybe 6 sheets in my table and I'd like to share SheetA to Mr.A, SheetB/C/D to Ms.B.Wonder if possible in Airtable?BTW why im looking for this solution is I still need to collect data from SheetA and do some summation in SheetB, but dont want Mr.A to see SheetB and other sheets.
HelloLooking throughout this community for any additional insight on third party applications with AirTable. In particular exploring better Forms options and capabilities. Through looking at different program applications JotForm seems good, however limited in the ability it cannot use the linked field option to the AirTable base. The other option was On2Air which does appear to have an option to link records within its form. Limitations we are experiencing and would greatly benefit our current project and future within the company are:A form that can be accessed by any user with the link and submit directly into AirTable. Current process is using a Google Form that is manually updated into the AirTable table import feature. This process is very manual as well as the linked record fields must be completely done manually. A form that allows outside elements, fields or structure to be added to allow a more flowing form. Interface has thi
We have created a form that once completed, creates a timecard. How can I add restrictions to the form that would block someone from creating a timecard under another users name?
I have a script to generate task lists via a button trigger based on the "Create records for multiple templates" script in Marketplace Extensions. I have one extra field added.I have moved everyone in my organization to interfaces and removed them from the base. They cannot click a button to run a script from an interface.I was attempting to change it to an automation. When {Status} is updated, run a script. When I copy/paste the current script, it errors. I know next to nothing about code, so it was really challenging to create the first scenario.I suspect that the input.config are the issues, because there is nowhere to input in the automation. Also, not sure how to create the selected event.Can anyone help me with how to update to work in an automation? It's a major part of our workflow.
Hi, I work a lot on my board to avoid my user is able to change some data. I use Airtable to manage the sales and stock of my shop. For that I lock view, give specific permission and so on, but I just noticed that a user can create a Grid new view which gave him access to edit/delete any field he is not supposed to be able to, when he is on his “limited view” I have created for him. So basically, anyone can just create a grid view, change my orders/stock amount or so, then delete the personal view and that’s it, my data are corrupted. Do you know a way to avoid specific users to create a new view ? Thanks, Sébastien
Hello- Trying to add a button link that has a formula with another field that has the tracking number (FedEx) so when you click the button you are automatically taken to the page that tracks your package. Thanks, Scott
I have an airtable db and want to sync this to the WordPress custom fields I’ve created. That everytime the data inside of airtable is updated, it syncs with the WordPress custom fields and the fields are updated. Is this possible? How would you do that?
Hello, I manage a team of 6 peoples working on a data base to organize their task.Each collaborator have theur own Kanban view like this : I don't know why but since 1 week my new collaborators don't have the bue cross to add a new task. They are all editors and they can edit other bases and other tabs but not this particular tab. Can you help me ? 😁
hey everyone,I'm looking for some inputs on how to organize the data efficiently. I'm building a multi-family building and have multiple different vendors like engineering reports, carpenters, drywallers etc.we have more than 20+ different types of vendors and for every trade, we try to get at least 3-5 quotes. this is getting out of hands very quickly and we often times miss data from the emails with so many quotes to go through. I'm looking to put all of this data into airtable to sort out easily. for example, if someone asks me to compare all the quotes for a structural engineer, I should be able to tell quickly what i have received instead of going through all the emails.would really appreciate if someone could point me to any existing templates or if anyone is already doing this.
My organization has been slowly integrating Airtable into our tool portfolio, and as the bases become more critical and more complex, I don’t see a great way of developing/auditing/version control for bases. Data snapshots and exports can serve to backup the data, but it doesn’t appear that schemas/formulas/relationships are preserved. I’m looking for any ideas to put Airtable development/deployment more on a par with conventional software development, to wit: How do people handle development/acceptance test/production, or do people do that at all? It seems that the only way to do that is simply to duplicate bases and name them appropriately (eg; Mybase_DEV, MyBase_UAT, etc.) Is there any way to audit formula/relationship/schema/script/automation changes? Is there a way to build any kind of development pipeline with automated tests and the ability to fork/revert changes?
Hello,We are using Airtable to do a content audit. We are using a form to capture the assessment data. The auditors must complete the form for each page of content. We have many pages, so they have to complete the form many times. On the form, we ask them to fill in their email address manually each time they complete the form. It currently is a drop-down field. We have had several requests to have this email field populated automatically with their email address. Does anyone know if this is possible? I have read online about pre-filling fields on a form, but it seems to be possible for specific values only. For example, I can pre-populate the name field with the value "John".What I would like is the following:Auditor 1Email address: johndoe@email.comEmail field on form automatically filled in with his email: johndoe@email.comAuditor 2: Email address: janesmith@email.comEmail field on form automatically filled in with his email: janesmith@email.comAuditor 3:Etc.
Is there any way to reschedule several records at the same time? Is it possible to select these and drug and drop?
I have four selections available in a picklist. Each selection has a different set of options associated with it. I want to create a secondary list of options that users can select from that changes depending on their primary selection. For example they choose from:Selection ASelection BSelection CIf they choose Selection A, a secondary option box appears offeringOption 1Option 2If they choose Selection B, a secondary option box appears offeringOption 3Option 4..and so on. How do I construct this?
I use the Typeform integration with AirTable but when sending multi-select data where the user has chosen the “other” option and entered a custom value it doesn’t get added to my AirTable. This uses the Typeform integration on the Typeform website and not the AirTable block so not sure if anyone here can be of help.
I’m looking to reference the name of a field as a string in a formula field and can’t figure out how to do it. For example I have fields {Size} and {Formula}. I have 1 record where {Size} = 5. I want my formula field for record one to display, “Size: 5” and I want it to work dynamically so that if I change the name of the {Size} field to {height}, then result will automatically update to “Height: 5”. Basically, is it possible to reference a field name in a formula? Thanks for your help!
Hi folks, I know how to set up an automation, for example if a record is created it can/could create another/dupliacate record for me in separate table, however this only seems to be tables within the SAME BASE… so, here’s my question: Is it possible for Airtable to create a duplicate record in a table in one base if a record is created in another base? thanks
Hello, I can see that this topic was marked as solved, but I cannot see a reply/solution. I am struggling with the same issue. Has anyone manage to solve it? Thank you. Continuing the discussion from Change the Order of Fields in Embedded Card View:
Does anyone know if it is possible to track the number of page views or link clicks on a shared table view? My office maintains a database as a shared resource for our organization, and are trying to determine the level of usage/interaction.
Considering the main Airtable page (the page that lists our Workspaces etc)...it would be great if it contained a list of recent tables and/or views. Is that possible?Something similar to how Google Drive can list all the most recent docs/sheets etc, which makes it easier to access those resources again later.Some way to quickly access recently used tables would be very convenient. I'm sure I can't be the only one who has noticed this.
Google Calendar Create Event all day adds calendar input 1 day shorter than in the original airtable entry Airtable input Created event How to create an event for all 3 days?
Hey Airtable community! I have records with a start/end time field. The field is set to "Use the same time zone for all collaborators" so that, regardless of which time zone we view the records in, the time stays the same. However, when viewing these records in a calendar view, the times are 4/5 hours behind.What might be going on here? It seems that the time zone for the individual calendar view was set to some other time zone, but I don't see an option for how to change this.Thanks for your help!
Hi there!I am trying to find a way to be able to duplicate a project with linked tasks that will create new duplicate tasks instead of being automatically linked to the old tasks.Example I have Project R5 S5 Launch with all of it's tasks (Music, Edit, Filming, Sound) linked and named under that R5 S5 Launch. When I duplicate that project to a new project R5 S6 Launch it currents links all the tasks still to R5 S5 Launch tasks but I would like to be able to have the tasks duplicated and under the new project name as well. I saw that there might be a script that can do this but I have been unable to find it. Doesn't know have any suggestions? Let me know if you need any clarification.Thanks!
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.