Other Questions

Hey Airtable Community. Does anyone know how to count how many entries are made on a particular date ie if I had 5 forms completed today and 4 yesterday I’d love a column to autocount. It would be amazing to count the week too. Each form is a lead and I want to set targets and automate my results. Help appreciated. Thank you!

Hi, I work for a youth engagment organisation. We have a community of several hundred young people in our network, and we put on various events and workshops throughout the year. I’d like to know which events young people are attending over a 12 month period, and I am hoping to use Airtable to do this. I plan to do this by having a ‘community’ sheet with an email address as a unique ID and a ‘projects sheet’ with an attendee field which links to the email field in the community sheet. I’d like to create a form which people can put their email address into on arrival at an event, and if they are already in our base it will auto populate the rest of the fields, and if not, allow them to create a new record, assigned against that particular event. Is this possible? Thanks so much for your help!

Hi all, I have two spreadsheets - one is a project tracker, and the other is a task list linked to the project tracker. I have start and end dates on the task list spreadsheet. Is it possible to link those dates to the project tracker and have the project tracker “start date” be the earliest start date of the tasks linked to it and the “end date” be the latest end date of the tasks linked to it? I want to create a Gantt chart from the project tracker but I want the start and end dates to be dependent on the dates of the tasks linked to it. Thank you!!

Hi there. I want to create a base to track my receipts for warranty purposes. I can just insert the purchase date in a column and track it myself, but what I would like to do is when the entry is one year old change its status in a dropdown column from “current” to “expired”. Thanks

Hi - I would love to make the view extend the full view of the screen - is that possible? Thanks!

Now that it is possible to specify permissions per table and field, it is desirable for an administrator to be able to generate an overview in a matrix. Is this possible?

Hello airtable community. Does anyone know a way to autofill part of a cell on a form ie when they only need to enter their instagram profile name on a form it updates my table with instagram.com/profilename? So pulling the instagram URL before it but automatically.

How can I deactivate the expand cell options in the cell.

I want to scheuled a course that runs for a date range of two months only on tues and thur - how do I do that so it only shows on the calendar on those days with a start and end date

How do I get an embedded view with horizontal cards like this? https://airtable.com/shrRJg0xh1jFLLcHF/tblsACnGQp6OOGNJl?layout=card&viewControls=on

Hi everyone, I want to have beta features to share and embed blocks on other websites. It looks like they exist and I applied it from here(https://airtable.com/shrLK2dGvhx46S6bU) a couple weeks ago, however I haven’t got any reply yet. Does anyone know what’s going on with this beta feature? Do I have to just wait to access it? Thanks

Is there a way to set up Kanban table to provide notifications of a specific status change. I.e. provide notice to a specific Slack channel of a change from status X to Y, instead of any general changes to the status overall. Thanks

Hi, community, I’m looking for advice on a better way to organize my process for clients. (new to the process) Right now I handle this in two different bases but I’m hoping I can have all info in one. I have a client base then an inventory base. I work in the interior design/real estate is the industry. I have a client base that has the job description and address of the job that I do for a client, then I have another base that has inventory for the client and the associated address of the job. Is there a way to have one base that shows the following path: client “A” info then I can drill down to client “A” particular job via address, then drill down to that addresses inventory sheet? I hope this makes sense. It seems silly to go to one base and put in all the details for the client except the inventory (which is done in another base) I’d love to handle it all in one if it’s possible then I can see all details for each client. Client “A” hired me to do “x” job the

Hi all! Working on a project where I have different tables: Events People I create an event that has a start date and an end date. After creating the event, I add the event team by adding team members (table.people) to a linked field. In order to see who is added to an event, I would like to create a Gantt view that has the following layout: Event shown from start date to end date When collapsing the event, each team member is shown separately, also with the start and end date I cannot seem to setup this view. Got as far as displaying the Gantt with the ‘full team’ (showing all team members linked to the event in one field, instead of the team showing separately). Is there a workaround for this?

Please explain the Revision and Snapshot History to me. Does this mean that in the free version, any changes that I make to my records will be lost after 2 weeks? I am using this (or hope to) to track gardening, i.e. name of plant, location, when planted, attaching picture and tag info, etc. just something simple. I’m just concerned that if I update the info with new date and such that they will disappear after 2 weeks. Is this the case?

I have a table of subtasks called subtasks. this is the todo list for the whole team. I used self-linking to get predecessors setup, and so I have: a rollup field showing the predecessor end date (PredEnd) a manual task start date (START) a manual task duration in days (LT) a formulated task completion date that adds the task duration in workdays to the start date (END) What I want to do now is create a scripting block that can load all the records in this table only, and compare each records PredEnd vs START, and if they are different, to update the START using the correct PredEnd value. But I keep getting errors and this is my first script… no idea what im doing… let table = base.getTable('subtasks'); let field = table.getField("START") let predEnd = table.getField("PredEnd"); let taskStart = table.getField("START"); // Load all of the records in the table let result = await table.selectRecordsAsyn

Where is the “undo” button? I don’t always do everything right. Of course, there should also be a redo function, as well. Thanks!

I manage base full of events that can be displayed as a grid or calendar Each event at least 1 tag (for example: event-movie tag-fun, event-yoga tag-sports) I’m looking to create a few different iCal links from this base Each link will subscribe to events contain only one tag For example: iCal link that shows only sports events Can it be done? any recommendations?

Currently I have a form, where I want to be able to limit the options in a single select, based on the option selected in the previous single selected. My example is: I am a rock climber and use a Airtable to base to log all my routes. The first single select in the form is for the style of climbing, eg sport, boulder, etc. I want the next single select (grade) to show different options, depending on the style of climbing, eg the sport grading system, the bouldering grading system. I don’t know if this is possible, but any help is greatly appreciated! Thanks!

Hey, Im only doing from Zapier using Airtable Find records as a action. My question is: What happens if 6 People at the same time request data from Airtable with Zapier Find records. Wille the first 5 go through without any error and only the 6th call will be an error? If yes what happens if I activate the Autoplay in Zapier for error Zaps in my Zap task history? Will it retry with Zapier to find record couple of seconds later and will it then be working?

Is there a method to check/un-check a checkbox field for all of the records in a base?

Following is how a formatted SendGrid email message appears in email. {Current Date} Friends of Niños Adelante, Inc. PO Box 1624 Sonoma, CA 95476-1624 Alejandra & Todd Hinkie 46 villiage Way PMB 167 Port Ludlow, WA 98365 USA Dear Alejandra & Todd, Little did we realize when we welcomed the first few students into the college beca program for the 2005-06 school year that we would be supporting 100 students in college by the fall of 2020. Thank you for your involvement and dollars which are truly making a difference in the lives of many in Zihuatanejo young people. Each year Friends of Niños Adelante utilizes general funds to cover students whose sponsors are unable to meet the total beca amount or have had to drop out of the program (approximately $10,000 this year). Our commitment, of course, is to provide full becas for all students who qualify. Since all the contributions for becas from our sponsors go to the kids, we need to be able to have funds for special needs sit

I am trying to set up a user log-in page in Adalo but where the Adalo DB lets me chose between Create a User, or Log-in a User. I am only allowed to Create a User using Airtable as my DB. I can add a Log-in action when connected to my User Table in Airtable but I am unable to remove the Create User Action so every time I try to log in it creates that same user again… What am I doing wrong? Thanks in Advance, Richard

Hi, the number of views on our airtable base is getting very unwieldy. I’d love to be able to see who created a view in order to check in with them and determine if they’re still using it or if they could make it a personal view. Is it possible to do this? Thank you.

Still putting together a Base to track my Fitness Instructor business. I have tables for Client Names, Classes Offered, and an Income table that tracks which clients attended which classes and how much each paid for each class. I also have Assistant Instructors for each class. There is one Assistant in each class I teach, but it can be any of 3 different people. I track who the Assistant was for each class in the Classes Offered table. Assistants are paid a percentage of the total income from that class. Now, with these 3 tables, I’m at a loss to figure out whether or not Airtable is able to track how much each of the instructors is owed (total and per class), and if Airtable can also track my payments to the Assistants, and keep a running balance of each of their “accounts”. I’ve not found any examples of Airtable being used for accounting tasks, so I