Other Questions

How can i configure Date entry to capture date entry automatically to date the form is submitted, if possible along with time.

I have two tables linked and somehow it produced duplicated new records such that Table A should just link to Table B “SKU001”, but it creates multiple Table B records “SKU001” “SKU001”. I then try to combine these duplicated records by copy-paste duplicated “SKU001” links into one, but it it didn’t work… This means now I have 1500+ Table A missing the link. How can I get these missing link Table A records without go through each record manually link them back? These Table A records all have different SKUs to link to. Is there a way to get all the “Last Edit Value” in Table A, so I can just copy paste the latest edit back to the link? All records show I did remove SKU, I hope there is a way to read that value so I can copy-paste it in bulk. Thanks,

I am working on an interview scheduler airtable base. I have an availability table which is linked to a scheduled times table. Dates in the availability table show in local time, but once a time slot is entered or selected into the scheduled times table it does not show up in local time. How can I make it do so? Screenshots are attached.

Hi All, New user here. I would like to mass-populate a column after I have filtered to only the blank rows/records. When I filter to view only the blank cells and populate the first cell, it is removed from my view because it no longer is blank. Is there a way to filter to all of the blank rows and mass-populate these cells with the same value?

I was wondering if there was a way to compare data with the chart app, between tables. I have a table that is '20, '21, and will begin a '22 one shortly. I would like to compare changes from year to year via charts. Is there a way to do this? or do I have to create 1 master table, give everything an identifier in a year field and then build the chart that way?

I just connected Vision App to my Base and have a few questions: First, my Use Case: We are entering Orders data from a receipt into Airtable, so I thought and searched if there was a way to maybe scan the Receipt and extract the text on the Receipt. Questions: I have set a field as the Attachment field, but everytime I add a new Record and add a new scanned Receipt image file to the Attachment field, and then click “Analyze” in the app window, it says it will bulk extract all the attachment field files of all Records, including existing Record ones I have already added earlier and already “Analysed”. It says it will cost x credits, which includes all the files of the existing Records as well. Is there a way to only click to Analyse new Records that have been added? Or another way to setup so we can upload a few scanned Order files and extract just those, each time? I am using Text extract, and all the text is saved into a sing

Hi, I’m trying to figure out if there are any significant differences between using the downloadable desktop app (for Windows) and just using Airtable in a browser (such as Chrome) and any advantages to using one over the other? So far (admittedly with only a little testing), I haven’t really found any except for having menu command available in the desktop app. I did see the web page, What are the differences between the desktop and mobile versions of Airtable? It seems there that “mobile” is synonymous with “browser,” but maybe not? Thanks, Stephen

Hi guys, I would like to my collaborators just see their assigned task. I dont want them to see task from other members in the same table. Is that possible?

Hi Team, I am looking to integrate airtable with process street, can you please help me with that?

I would appreciate it if anyone could help with the following scenario I have 2 tables, Table A is client lead table, Table B captures data from a form. when a clients answers are captured in Table B I need those answers to be updated for that client in Table A. thanks in advance

enviar correo de verificación a mi cuenta

Hi guys, I need help! There have been some incidents on the Airtable where I work as if a person delete the images from the base but it wasn’t her. The person didn’t touch anything but it appears with her name. Does anyone have any idea what it might be or how I fix this problem?

I need several zeros before my number in a number field. Any way to accomplish this without writing code? I numbered and filled, then changed it over to text field, but now I have to add the zeros to all the numbered cells. So two questions: Can I append zeros to the text field cells numbers automatically or Can I get a numbering field to recognize zeros before the integer? Thanks!

Hello Everyone! I would like to know if when we perform a synchronization between tables the data linked with other tables are also synchronized? For example: We have Base A which contains the table (Clientes-all) and base B which contains table (Clients-segmentB) and (Sales-segmentB). A column of table Clients-segmentB is linked with table Sales-segmentB > The sale number from Sales-segmentB is linked with the customer in Clients-segmentB. We want to synchronize table Clientes-all with table Clients-segmentB > All costumers must be in the table of their segment (Clients-segmentB) and in the general database (Clientes-all). I would like to know if in this synchronization the link with Sales-segmentB will be presented in Clientes-all or if the link will only appear inClients-segmentB and in Clientes-all the synchronization will only bring the data from Clients-segmentB to Clientes-all > The link from the custumer (from Clients-segmentB to

A large number of records were updated 3 days ago in error. They have chapters and were updated and added to the wrong chapter. I would like to undo this action add these records back to their chapters. I can do it one by one but it is a lot and would like to find an optimal solution. How do I undo this? Any thoughts? Any help Is appreciated.

I have decades of consulting experience using RBase and Access. I’m used to creating forms that display the One-to-Many relationship between two tables. For example, one form could display an Order in the upper part of the form, and then in a subform each Product for that Order could be displayed in rows, with Price, Quantity, and Extension for each Product, and totals at the bottom of the subform. The Order and the Products would be related by an Order ID field. I’m new to Airtable. I can’t see any way to do what I describe above in Airtable. Can anyone direct me to a tutorial, or tell me what I am missing? Any help would be appreciated. Carl

Hello all i have some clients the I need to send emails to, I need to send a form from formstack and I have a field with attached files after formstacks create them, I started the automation with “when the record is updated will start the automation” but I need to send emails only the record the I just updated and is different email all the time do you guys have a solution for this issue, please.

I am looking for some help. I am trying to find a script or suggestion that will help my team see when an author last ran. When an editor adds a new record, I want something that will search through one column to check the authors name and if there’s a match take the run date from the column it matches and put into a column with the new record.

Hi Community! I would like to display a record that looks like a gallery view, but that is static so you don’t have to open it in order to copy information from it. Can you think of an app that will do this? Thanks in advance for any assistance. mary

Hi, I spent the last several days reviewing each of the videos posted on your website and I am very interested in moving my work from SmartSheet to Airtable however, I’ve been unsuccessful in building invoices. To give a quick summary, I work with 30+ different organizations for 3+ academic programs. I have to track their contributions across each of these programs by different contribution categories (Labor, materials, equipment, other). Specifically, what I liked about SmartSheet was that in a sheet, I can populate all of the necessary components and have the “Dashboard” only show information that met certain criteria (i.e. auto-populate data if the Company name is “A”, Program is “Universal Media”, line item status is “Pending Submission”, etc. Currently, in Airtable, I’ve used the “Link Record” feature but, I have to manually add each submission under the correct record in the new sheet versus, having it automatically populate. I hope my challenge is clear a

I’m relatively new to the platform, so please forgive any vernacular discrepancies on my part! So I’ve got a base with two tables. One table is a static list of assets (Asset Table), the second table is a list of requests (with inputs driven by a form, Form Table) that my coworkers use to make requests relating to those assets. I use a Link’d field as one of the input of the form, so my coworkers can choose which asset they’re submit a request on I’ve got that question in the form set to use a particular grid view within the Asset Table with a few filters and a sort applied to it. Everything works really well… except the order of units in the search function? The question in the form where you pick the asset has an + Add button, and you can scroll through the assets, or start typing to search and jump to what you’re looking for. When you take the time and scroll through, the units are in the proper order - matching the order on the grid view in the Asset Table tha

I think I already know the answer to this, but is it really the case that there is no way to access the search feature within a shared view that is available from a desktop, while using a mobile browser? On one hand I love Airtable but the deeper I get the more it seems that: 1 - it suffers from glaringly obvious faults that seem like they’d be easy to fix 2 - those faults just persist over the years in spite of users pointing them out, rather than gradually being addressed. This market is getting more and more crowded with Airtable competitors. The very last thing I want is to have to reinvent everything I’ve done on a brand new platform, but the more time goes by enduring little problems like this the more inevitable that starts to seem.

Hi all! I have information in one tab on the database which is called “B12 Recipe Claim”. This value is an IF statement, where if the B12 content (specified elsewhere in the database) is above a certain value its “ :white_check_mark: High B12” So now, I want to, in another tab, add a score for “ :white_check_mark: High B12” for a specific attribute (i.e. “calm”). I’ve set up these scores elsewhere in the database. So, the formula should now be: IF({B12 Recipe Claim}=“ :white_check_mark: High B12”,{Calm B12 Score Lookup}, 0). I’ve used this formula for similar functions elsewhere in the table and it works fine. However I’ve noticed this in the table: Basically, when the value is true, it doesn’t pull the fact that the value should be 0.2, it’s just blank or returns the other value (0). It does the same for scores relating to other things that also

I am trying to use a order now form on a multiple listed items. But whenever that order now form is filled, the listed item doesn’t show up in the data base. It’s like someone filled the order form but I have no idea, which item was ordered.

Let’s suppose I have an Employee table and a Team table. In the Employee table, each row is an employee, and there is a field called “Role” that indicates their role (Engineer, Designer, Manager, etc.) In the Team table, each row is a team, and there is a field called “Members” of type “Link to Employee” that accepts multiple items. The Members field is where we put all the employees who are members of the team. I want to add a field to the Team table that contains the engineers on the team — an automatically filtered subset of the Members. And I’m stuck. I could use a Lookup field to filter the items in the Members field, specifying in the condition that the Role has to be “Engineer”. But Lookup does too much: I have to specify a field of the Employee. So I could get the names of all the engineers, for example. But I want the actual Employee records, just like they appear in the Members field. There doesn’t seem to be a way to specify that