Other Questions

Hi everyone!I'm looking for a way to automatically set the time to 00:00 for certain entries in Airtable that have a date field. The goal is to allow some entries to have a specific time (like for flight schedules) while others default to 00:00 (such as open train tickets). I’ve tried using forms to set a default time, but the options only allow me to set a specific date and time or use the current date and time, which doesn’t work for my needs. Does anyone know how to achieve this?Thanks!

Hello, I have a Airtable Table that sorts different records by release date. I want to be able to manually re-order the different records that have the same release date (as many of them do) but for some reason I can't figure out how to do that? I've tried to turn off automatic sorting and then manually re-arrange my records but as soon as I turn automatic sorting back on, it overwrites my changes. Anybody got a fix or insight for this?

I want to add rows in airtable According to Shopify order quantity,for example if quantity is 4 then 4 rows must shown in airtable with random spot numbers but unfortunately Shopify give us just one spot of order is there any automation expert here who can solve this issue

Hello! I have had a colleague leave recently who made a form that links to data that gets submitted. However, I cannot locate the workspace the data is pulling into and cannot ask the colleague. Any tips?

 I have a problem with related tables.Button 1: When you click the "Add" button, it does not automatically fill out the foreign key. However, you can cancel the form at any time, so it will not be saved in the database.Button 2: This button automatically relates the record to the parent table. However, if you do not fill out the Mailing Address and Source fields, the record is still saved in the database. Therefore, if you accidentally press the "Add Record" button, you will need to delete it manually.Questions:How can I fill out the foreign key in Button #1?If I use Button #2, how can I prevent the app from saving the data in the database if I haven't filled out the Mailing Address and Source fields?

TLDR: is there a standard format that people use to define the application they want to build so companies can bid on it's implementation?When a new person decides to farm out the work to one of the solutions companies that are part of this community, is there a standard specification document that a customer can author that allows solution architects to bid on the implementation?  Or is there another site that people solicit specialists to do the project?  I am sure that the types of customers range from a small retailer to a large company, with each solution provider geared to implement on either small, medium or large solutions.  But there is probably a cap on the "large" before a company just goes full oracle database or the like....TBH, it would probably be an interesting airtable/filltable app to allow people to define their requirements. I wouldn't be surprised if one is out there and I'm just not aware of it. 🙂Thanks.Jeff

Hello all,We have an automation set up through Zapier that searches for a record and updates the record if it finds it and creates a new one if it doesn't. The problem I am having is that duplicate records are being created that match the search criteria. I am unsure why and where to look for the issue (Work Flow: Jot Form to Zapier to Airtable).Additionally, if anyone has a fix for a dupe record created because there is an extra space in the field (where and how can I strip it out or make it part of the search criteria)Attached are my search criteria (with a fictional test person) in Zapier and the ID in Airtable.Thanks for any suggestions. 

I'm new and have watched a lot of excellent tutorials that seems to indicate that I should be able to do what I want, but I wanted to ask the user-base to confirm, and perhaps to add any "to do that, do this" comments. I'm on the free plan, but if i can get this to work, I definitely want to upgrade to the paid plan and support the service, but I've been so bad about getting started on projects and then get distracted by some other shiny object and abandon it.  But this time I'm hoping it's different, as the product seems pretty simple to use.I help run a local makerspace, and we have members that pay dues to get access to our space that has tools and stuff.  People apply for membership, and our rotating board of directors (elected by the membership) approve the members.Currently, our process is:member sends google form to apply.the board members get an email, and they reply all with "aye" or "nay".If we get 2 "aye's",  I ma

I have uploaded images as attachments to about 250 records in a base. Each one uploads without issue and I’m able to see the preview in grid view and the full image in gallery view. I checked each attachment as it was uploaded. The problem is after the fact: now, about 25% of them are coming up as empty jpg icons in both views. When I attempt to open the image within an individual record, the same thing happens - a white box with the jpg icon and the file name. Any insight? I’ve tried refreshing the base, but to no avail…

TLDR: Is dokuwiki a reasonable solution for non-airtable user account management? Or is there something better?As I'm trying to build my application for a social maker related nonprofit organization  that has about 105 members that cycle in and out, some are leaders in the group (9 board members, 4 officers, 6 area leads, etc), I want to have airtable data available to all registered members such as read only the member list and their contact information, and other people that can have access to member maintenance.  And each member would be able to update their own information (self help).  But with 100+ members, giving each an airtable account would be difficult to manage.But then I realized we have a wiki page that supports user management, and I might be able to embed forms and views in certain pages that require different access. I'm curious if any of you see a flaw with this idea, or if there's a better solution.Background: There's a free ope

Hello guys, I hope you are doing well. I was wondering if you also have this error? The letters are superimposed on the gallery cards. Could you tell me if it's a bug or if it's me?Greetings!

Hey there, I'm new here and I'm trying to access Airtable Academy (yes, we do have a Business plan), but the page doesn't open at all. Am I doing something wrong or is Airtable having issues with Airtable Academy today?Thanks,Carina.

Very new to AirTable and I'm working in a file created by someone else. Right now, I need to know how to move a row. (The data is in Alphabetical order, and one entry name has changed. I need to re-order it. I just want to drag the row to a different place but it doesn't work)Also, I have grouped the data but can't seem to UNgroup it! The chat bot said to unselect the grouping criteria, but there is no way to do that. Help!

Hi everyone,I'm having trouble accessing Airtable Academy. Whenever I try to log in, I get the following message:Sorry, you do not have access to this page.I've attached a screenshot of the message below.Has anyone else experienced this issue? Does anyone know what might be causing it?Any help or advice would be greatly appreciated!Thank you!

I want to add a button field that will open one of two page design extensions, depending on the value in a particular field.  For records with value 'INV' in that field I want to generate one page design extension; for records with value 'ILL' in that field I want to generate a different one. I have created two button fields, one for INV and one for ILL, but I cannot see how to only show the appropriate button depending on whether the record is marked as INV or ILL. I tried a formula field but this didnt work. Any ideas please?

Hello hello!Just a quick question for any tips if anyone has experience integrating Airtable with Squarespace. We're a music education programme. In recent years, we've cleaned up our data and workflows with Airtable. Now, we're upgrading our website with Squarespace and would like to bring it to parity with our data.Specifically, we're looking into integrating our CRM on Airtable with the marketing tool on Squarespace. We'd love to use this as a tool for communicating with our Students and Families.We've used similar tools, MailChimp, Mailerlite, etc., and done these without integration with Airtable.The other things I'd likely look into are the member pages for students and ways for them to find their schedules and resources. All this data is organised on Airtable already!If anyone has experience with Squarespace and Airtable some tips would be appreciated!

Hi thereI have two tables I want to link.One is a table of organisations and the other is an excel file of data that belongs to one specific organisation. Both files are uploaded. (Later, there will be other tables to link to other specific organisations).I can use the + sign to set up a new field in the organisation table. I then select Link to a new record.This is supposed to bring me up the option to select which file I want to link to,.  But every time it brings me up the attached screen shot which doesn't allow me to select an existing file.I've tried it in firefox, chrome and edge with the same result every time.Help!! What am I doing wrong?PS I don't understand how the link is going to go to a specific organisation using this method, but maybe that's the next step I can't get to.Helen Gardnerhelen@thegardners.com.au

Can someone explain how to save a table to a CSV file. I have done a search, but everything tells me to use the "save as csv file" in the dropdown for the table. I do not see that option for any of my tables. If anyone could help, I would appreciate it. Thank you.

Hey guys!I have a schedule creating Record Template that only creates half of the schedule I need it to create. Here's a quick breakdown on the set-up:Tables:Job - Contains all job information, linked to Schedule. Where the template is applied. Schedule - Contains schedule phases, no manual dates. Linked to Jobs and Tasks. Tasks - Where the dates are actually entered (but not in the template). Linked to Schedule.Template info:Creates a series of Schedule phases and Tasks. There are 65 records it's supposed to create. It worked about a month ago perfectly fine. The Problem:Currently when I apply the template from an interface it only creates 32 of the records. There doesn't seem to be anything wrong with the template, everything is entered into it correctly. Has anyone else ran into this issue? Let me know if anyone knows whats going on and if there's a fix.Thanks!

For the plus or pro plan, how many creators or editors do you get? I see that you get Up to 5 creators or editors under the Free Plan.

HelloI am new to Airtable and I am trying to create dynamic calculations in a record in my calculations table that is updated every time when a new record is created through a form for another table called Non-Title I School Tours - Virtual. I used Rollup in the calculations table to sum multiple records in a field in the Non-Title I School Tours - Virtual table. The problem I am running into is that it is not summing up multiple records it is only showing the first record and none of the records after it. Any feedback would be helpful.

We use our air table to create a database of questions that we use to answer client DDQ's or potential client RFP's.  When I need to find a specific questions and answer I'm having troubling finding it.  What is the easiest way to do a search like this?

Hi, I have a question regarding Airtable sub-categories.I have a Airtable full of products the rows are structured like this :"productName",   "price",   "category",   "productURL",   "imageURL",   "description"What I would like is to have another table inside of the workspace for the same product but different colors, or products that are slightly different Context: this table is linked to a Make.com scenario that creates dynamic carousels inside of voiceflow.If anyone could help me make a sub-category table that is linked to the main one I would highly appreciate it.

I have a table of information that is tracking music in a film.  I have the songs and their timecode of where they appear in the film.  the nature of the list is that i have a record for every time there is an edit however several records compile the total use of the song.  Here is my issue.  When i look at all the records in grid view and sort by timecode in they sort in order and everything looks great.  Then when i then group them by song title things go hairy.  It puts the groups of songs out of order.  so a song that starts in the film at 1 min 15 sec and goes to 3 min 15 sec is sorting after a song that is in the film at 15 min 3 sec.  How can i get them to go in the proper order once grouped?

Hi all, I am wanting to understand if the following scenario is currently achievable and if so, what “add ons” would be required: Ideally I would like to be able to share a “filtered” view with a clients that only shows information relevant to them for a updating various aspects of a project, while the remaining fields which are for internal purposes are hidden. Obviously this can be done by setting up a view and hiding the relevant fields. Only issue here is that when sharing this view a guest can view it and not make any changes (I am amazed that this feature is still yet to be implemented having seen discussions on this topic go back quite a long way). So, the only option is to send this information to Google Sheets (I am aware of various tools such as Airtable Importer, Coupler, Integromat etc that can do this one way). Now that the info is in Google Sheets, it can be shared with a client (either the full set of data and hide various columns and restrict edi