Other Questions

I'm using a base to track my time on projects/tasks. I use these times to create estimates for clients and to create invoices. It's great to have the built in time tracking in Airtable, but I've made the mistake many times of walking away from my computer or switching tasks only to realize later that the timer is still running.Does anyone have a good solution / workaround for this?I can think of two things that would help this:1. Idle alerts. Most of the time tracking software I've used will alert me if I don't do anything for a specified period of time. If I forgot to stop the timer at the end of the day, the next morning, I get an alert that I've been idle for x hrs and a prompt to keep tracking, stop the timer now, or set the end time of the timer to when the idle period began. Currently, this is particularly tough in Airtable since the Tracker doesn't make distinctions between timed sessions. So if I've worked on a project off an on for days, the whole total is thrown (instead of o

I need some help using an IF statement within a CONCATENATE formula. I have tried many permutations but have just not found the right syntax. I have the following fields: AirtableID CompanyName Project Sub-Project Person In the Name field of a table, I want to concatenate these fields as such: If Sub-Project is not NULL, then Name = AirtableID_CompanyName_Sub-Project_Person Else (Sub-Project is NULL), then Name = AirtableID_CompanyName_Project_Person Here is as far as I got, and I know the syntax is not right: CONCATENATE({AirtableID},’’,{CompanyName},’’,IF({Sub-Project} = 0,{Project},{Sub-Project}),’_’,{Person}) Thanks!

I have a table with a linked record.  I am grouping by the link record, however the show group with no record toggle that shows up for single select is not there.Is there a way to show all groups even without records?

We put orders daily into PROJECT TRACKER.    We have reached our "limits".    Many old orders are not needed anymore.    I can go back and delete items one at a time, but it would save time to search a keyword (bench) and delete all the items with that word or just highlight all the items and delete those.

Hey friends, family, and everythign in between,So, I have a table embedded into a landing page, and like, overall, I am pretty happy with it! That being said, there is usually a footer in an embedded table that says "view larger table" in the bottom right hand corner of said table. For whatever reason, mine doesn't show up. As a workaround, I have implemented a button that brings you to the airtable website view of it, but would like that little footer back in case people need it, or to at least have an option for such both above and below the table. Any thoughts or insights as to why it might not be showing up? Let me know!

Does anyone know how to lock this feature of “view larger version” from embed on bottom row?

All of a sudden my workspace is no longer there. And i have no more bases. Trash is empty. Please help.

Hi there,I am currently using the page designer to create a document I can print to PDF, which works fine. However, in my base I have 2 tables that have identical record names; it's just the content in the records that's different. I have already made the page for one. Is there a way to simply change the table it is referencing without having to completely re-make the page?Thanks.

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.