Other Questions

I need to create a form that includes a dynamic table-like structures within a question, where you can input multiple rows of data (objects) and assign a different value (like a dropdown selection) to each row in a grid format, and syncs this data to Airtable with one object per row and each selection per field. Furthermore, I need the system to recognize if an object has been submitted more than once and not add another row, but rather add the 2nd requester name to an existing row. Has anyone been able to figure this out? Thank you,

Here's the context1) - Send a weekly form to the teacher to update the student's training progress.2) - allow each teacher to access student data only3) - Teachers must be able to update fields or data at any time4) Student fields should be pre-filled when the teacher selects the student (e.g. from the student's @email).5) Send a reminder message to the teacher if the weekly Feedback is not filled in (e.g.: start date+ xdays). 

I am creating a table to get a detailed look at my finances. I want to see cost per day by city and category for the following table schema:Purchasesname, cityName, cost, categoryCitiescityName, daysInCityHow do I create a table with the following fields:cityName,category,costPerDaycity1,food,$20.00city1,lodging,$100.00city1,activities,$50.00city2,food,$30.00city2,lodging,$110.00city2,activities,$60.00I want this to be automated so minimal manual work besides adding each purchase as a record is unnecessary.Currently, I am running into trouble auto-selecting the records by city and category. I have tried with automations but I am running into an unknown error:Invalid filter on Category (Invalid filter value: [ "Essentials" ])

I have a Record Review Interface that is shared publicly. As expected, the record displayed when following the public link is the one at the top of the underlying sort. I'd like to display a different record in the table as the starting point while retaining the sort for the list of records. The URLs appear to follow a predictable pattern, and the initial URL for the public interface is rewritten as a URL with an appended query (after a "?") referencing the displayed record. The query consists of a six-character string which is consistent, "=rec", and the internal record ID.When I construct a URL containing the query for the desired record and attempt to load it, I receive an "Internal error, Try refreshing the page." message. This also occurs if I simply cut and paste the rewritten URL into a browser window after following the base public link. I am using a browser session that is not signed into Airtable to test the URL strings.Any ideas?

I have an automation that sends an automatic email. There are 2 date fields in the text. This should display the date and time. unfortunately the date fields are displayed as in the attachment. how can I change this?It would look nicer if everything was like the last one. could be removed

I have a formula field that only shows me the name from a string. I would like to use this name in an automatic email. Unfortunately I can't see the name.

I have a name and the corresponding date of birth in a data field, separated by a "|" I would like to use a formula so that only the name is displayed to me. the name is before the "|" sign. I tried LEFT, but only got ERROR

I need some help with an automation.When a particular record in table A is updated, then inTable B the contents of (Planned Move-in and Planned Move-out) in the fields (Move-in and Move-out)

Dear Sir,I need help in creating rankings of products based on its quantity.We have a table with 3 fields. Name of Fruit, Quantity, Ranking. We want to rank the Fruits as 1,2,3,4... based on the quantity of that fruit. Whenever the quantity of any fruit changes, the Ranking should update itself.Any help will be appreciated.Thank youNavin

 In a few of our bases, we have either password protected the shared grid view, or we have disabled the share view link completely. However, we're finding that a different URL for that same grid view is still being accessed, even though there is no link associated. This means people with a link are able to see the contents of this grid view. We're also finding that this URL is different from the original link that was associated with the base.Is there a way to view what links are tied to the base? Has anyone else experienced this issue? We are trying to get these links offline. Hope this makes sense. Please let me know if any clarification needs to be given.

Hi,I wonder if I can somehow give a copy of a Base to another user?I have a blank Template base (with just the column names and formulas and such) and I would like to give a copy of this Base to another user. This other user is NOT part of my company or organization. I do NOT want them to be a 'collaborator' in any senses - I just want to hand off a single copy of the Base to them, and then they can do whatever they want with it, and not involve us at all (or our account at all). Is this possible somehow?thank you!-Ed

The record limit for the free plan is 1000. I am only at 500 records.  

I’m trying to use a find/update zap to automate a record update in Airtable, Some empty fields need to get new data, some get updates and others need to be cleared. The Zap correctly adds the new and updated data, but I can’t figure out how to DELETE data from the fields that I want emptied (which are date fields). With other numeric fields, it’s easy to just set the update value to “0”, but this doesn’t seem to work for date formatted fields. I’ve tried 0 =0 -1 0/0/0000 0000-00-00 =BLANK() Null Creating an empty dummy field and setting the value equal to that No luck. I asked Zapier first, thinking they might have some special formula or syntax to use for this kind of thing, but they told me it’s restricted on the Airtable side and overwriting with blanks isn’t permitted. I thought I’d ask here in case anyone else has come up with a solution/hack to clear/empty/erase a cell or make it “null”. Thanks.

In the form I have a data record field where all free rooms are displayed. All occupied rooms are not displayed. However, if I have a reservation for the future, the assigned room is immediately marked as occupied even though it is still available until the specific reservation date. So far I have no idea how to solve the problem.

Is it possible to subsequently edit an existing data record using a form, for example to change a status. without making the change directly in the table?

All:I have imported data from an excel into an existing table in a base.  The existing table is called "Income Account Transactions."  There is another table called "Profit & Loss" that links to Income Account Transactions table. It  calculates data from the table.  The imported data is not calculating into the Profit & Loss Table.  What am I doing wrong?

Hello to you all !! I’m facing an issue. I’m totally new on airtab and I’m trying to create a data base. I have a table where I will put a name of a project and a mutiple select fied with the companies that are in the project. I would like to create a data base for those companies and to be able to do so, i need to find a way to create an automation thats is going to take every company from the multiple select field and create one independant record for each one of them in my database table. I would love to do this without a script because I’m on the free subscription. I would really use your help. Thanks in advance and have a great day !!!

I'd like to buy a book (or 2) on Amazon (or other) that I can use as a decent reference for scripts, formulas and other advanced topics and would love some suggestions. Given the ever changing nature of products such as Airtable, I want to make sure I buy something that is relatively recent that would have the newest features, or at least most of them.The basic stuff (field types, etc) are self explanatory to me, so hopefully a book that has more solutions than the core fundamentals of which I've mostly been able to learn with vids and the like. I know that the basics will be covered in any book, I just want to make sure the back part of the book with the advanced stuff is relatively deep in content, if that makes sense.

I'm building a task tracking app within airtable to use with Glide. I would like to do a rollup of total hours spent on each task bucket (four in total) for the current month, week and day. I cannot figure out how to do a sum of each task for those time frames as a numeric value and hours spent on each task. Any help appreciated.

Hello everyone. I’m still new with Airtable but I’m trying to learn. I am integrated in a sports club, volleyball club. I’m trying with Airtable to make a table that updates results of games. The idea is that each team director can enter the results of a game in a simple way, and then get the complete list of results. Is there any template that does something similar? If you guys can help me I’d appreciate it.

Hi there, I've started to play with AI features (love it!) but I'm experiencing issues with the AI field allowing to generate text.I want the AI to analyse text within attachments and return structured data. It works pretty well when analysing PDFs but it doesn't seem to work with HTML or TXT files. While field HTML is properly filled with a document (HTML in that case), the AI keeps asking to fill out the field.This also occurs when using TXT files but it works with PDF. Are you aware of such limitation or can it be considered as a bug? If that's a limitation, can someone think about a convenient way to store HTML data as plain text? When converting my HTML to PDF before upload, I'm losing the HTML as text since it's rendered as webpage within my PDF. I'm using Make (ex-Integromat) for that purpose.Thanks a lot for you help!

Hi. Trying to find a calendar integration that will populate film and schedule info from Airtable for our film festivals. Basically, we schedule films in venues throughout a week and need them to be organized consistently and show info like start time, run time, end time, etc so we can share with staff and our cinemas. We're using Google sheets to create our SCREENING OVERVIEW because it doesn't work in Airtable to use the calendar. So need something that looks similar to this in the end, with the full screening schedule per day in separate tabs:Any help or ideas are appreciated. Thanks!John

I have 2 datafields, room type (single room & double room) and guests (1 to 2 names)if in singleroom and the guest (the volume is 1) should say "occupied" in the formulafield andif in room type (double room) it says and guest (the volume 2) then “Occupied” should also appear in the formula fieldMyCode:   IF(AND(room type = "double room", {client overview} = VALUE(2), room type = "single room", {client overview} = VALUE(1)), "occupied")   

I have a column that fills in the State Abbreviation from Jot Form. The form is a drop-down selection that is the same as my single select column in Airtable. Somewhere new duplicate selections are being generated with new submissions. I am trying to figure out where to even look for how this could be happening. Any help would be appreciated.

Hi, I have been trying to solve this, and I'm curious if there's a solution. Please see attached screenshot. I'm trying to add a contact within a form in a new interface that I built. How can I achieve this? I can't seem to have a + sign for users to add new contacts. It only gives me the option to choose existing contact. I want to add a new one from there. Any suggestions? Thanks!!!