Solved

I have been using this booking form template (here is the community post where I found it) to try and create a student registration form, but I'm running into some snags. I'm hoping someone may be able to help me. The basic requirement is below (once I have that established, I'll play around and try and make it a bit better). What I need is a form where:Student enters in their student ID.Student chooses a research topic from the list.When they submit, this reserves that topic for that student, assigning their student ID against the topic. I have five topics (for simplicity sake: blue, green, red, pink, brown), and each topic has 25 spaces available. My setup so far is:Table 1: Available Topics:The fields are:Primary: Topic (this is not a unique field, it will be one of the 5 colours)An autogenerated numberUnique ID using formula based on auto ID and region nameStudent ID (linked to the other table)A status field (formula tests if student ID is blank, if yes "available" i

Does anyone know why creating or linking records in elements with a linked record source is disabled (locked icon)? Right now, you see this when you mouse over those disabled buttons: This feature is not currently available in Interfaces for elements with a linked record source  Because I do need a linked, filtered, and sorted list element with a record source, I came up with the solution of adding a record picker element, just purely for the ➕ button that isn't disabled. I think the hover message means that the Airtable team is working on it, but not sure what the timing or issue is. Anyone know?

Hello. I am currently on the "Team" plan and by mistake one of our collaborators ended the available automations. Because from this workspace we manage two companies we need to resolve it urgently, although unfortunately after 24 hours of contacting the Airtable Team we still have no response.The recommended solution is to upgrade the current plan. Given that it is a specific situation that should not be repeated, what would be the best way to resolve it? It's okay if I have to pay.1 - Upgrade my current plan to the Business Plan, hoping that this will reset the automation count and then return to my current plan.2 - Since my current plan is annual, if I keep it (not upgrade) but change it to a monthly plan, will this reset the automation count?If you have any other solution I would appreciate it.It seems like a very bad idea to have to change your plan because you made a mistake. A change of plan should only be due to permanent needs of the company.Greetings.UPDATEI really feel very f

I'm having trouble updating a date field with results from a formula. Please helpMy desired outcome is the following: When the user updates the "last communication date" field, then Airtable will automatically update the "next communication date" to be 7 days after the "last communication date." This allows the user to manually update the "next communication date" if desired but doesn't make that step mandatory.What I've Created:-Editable "last comm" field-Formula field "calc next comm" with this formula: DATEADD({last comm}, 7, 'days')-Automation set to update "next comm" with the data from "calc next comm"Error from Automations Test:"Field "next comm" cannot accept the provided value: Could not convert string to date." The user kuovonne previously provided this answer to a very similar question, and it seems like it should resolve my question."If it is a native Airtable automation, the display of the time shouldn’t matter. Your formula of  DATEADD({Estimated

I have two automations set up that send me reminder emails when my records hit a specific date condition.  It is a "days remaining" type of condition.  I want to wake the base up every morning so that it can update the records and send the appropriate reminder emails.  Do I need to have the schedule automation first in the list so that it performs that first or does it not matter?

Hi,I am new to Airtable coming from Xano and using Thunkable as my mobile front end.In Xano I can create and API endpoint which will allow me to search for a specific value in a column in a table.  I see that I use the AirTable API to get a record but that is by record id.If I wanted to search by a field, email address for example, how would I accomplish this?ThanksSteve

I have synced my calendar (using sync to an external calendar option under share view) to my google calendar on my laptop. I see the events from that calendar there. On my phone, I have set up to see google calendars. When I look at a date that I know there is an event for, I do not see it. Any ideas as to why I would see it on the desktop calendar, but not on my phone?

I have created a space for the company that my clients can access to see their results (in a control panel, interface). But in order to see their results, currently, they have to create an account on airtable (which is strange for them since it is my company that provides the service)I want to know if it is possible that they can access to their dahboard (interfcae) without logging into airtable, or something similar, it is very important for me.Thank you

Hello. I have a table with a field I want to copy and paste into a new table. Seems like a simple thing to do, yet I cannot find out how. Any insight? Much appreciated.

Hi there. I am not a habitual Airtable user, nor am I much of a tech person, so I apologize if this question has been answered and I wasn't able to find it.I am developing a database for my perfume collection using Airtable, and for most parts of this project it's great. I would really like to be able to track the dates that I wore each scent (currently I do this in a hand-written notebook, and I have years of data that I'd love to input). I can't figure out if this is possible or how I might do it. I have seen both "no" and "yes?" posts but nothing definitive or for what sounds like the kind of tracking I am doing.Thank you very much in advance!

I've been trying to get this to work using a formula but haven't figured it out...What i want: I have a table that contains 1000 records, 12 of which i'm displaying on the web frontend via softr.io. Now what i want is to randomize the 12 records that will be displayed. This does not necessarily need to be randomized each time the page is refreshed/the API call to retreive the records is made. It could also randomize every minute or so.I guess randomisation on refresh/load would have to be made via the API call somehow. But if the API call always retreives records based on a static filter, I would have to randomize the results that the filter retreives on the Airtable side.Any idea how to do this?One simple solution I thought of which should semi-randomize every time the result of NOW() is updated in Airtable: Number records with autonumber. Take the seconds from NOW() and calculate based on the second (which is a value between 0 and 60) which block of 12 records should be taken. I.e. i

I have a table "Products" and a table "Artworks". The Product table has a lookup field to the Artworks table. In this lookup field, I assigned multiple Artworks to each Product (e.g. "Product 1" has assigned "Artwork A", "Artwork B", "Artwork C", and "Artwork D").Product 1 can only go into production once all Artworks assigned to Product 1 have approval status "Approved".In the Products table, I added a rollup field that shows the records from the "Approval Status" field from the "Artworks" table. By default, the values appear like this in the rollup field: "Not submitted, not submitted, Approval pending, Approved"Instead of listing all the records in the rollup field, I want the rollup field to show:IF all records = "Approved": output "ALL ARTWORKS APPROVED"ELSE: output "APPROVAL PENDING"or alternatively:IF any record is not = "Approved": output "APPROVAL PENDING"ELSE: output "ALL ARTWORKS APPROVED"I'm thankful for any tips! 

Hi,How can I set a condition in intefaces so that the chart displays data only from the last calendar year?Within the past year apparently does not count the calendar year, but the year itself. I need January 2024 not to be there anymore.Thank you for your help.

hi there,I am trying to create a nested IF that checks if four cells are blank, and if they're not, returns the value that's there.When I use the below formula, it only ever checks the first IF, and it's driving me nuts!Can anyone help? I want it to return BLANK if there are no matches. IF( ArtSaleChecker2!=BLANK(), ArtSaleChecker2, IF( PromSaleChecker2!=BLANK(), PromSaleChecker2, IF(OtherSaleChecker2!=BLANK(), OtherSaleChecker2, IF(GenSaleChecker2!=BLANK(), GenSaleChecker2, BLANK() ) ) ) )  

Hi All,I would like to be able to automatically add instructions (how to perform a subtask) when I select a certain subtask. Plain text would be sufficient here. What would work?Thanks! 

I am creating a table/form to insert log entries into a daily log. It requires a bunch of sub-item data and inserting weather info of the day when the record was created. I was wondering if there is any way to automate inserting that day's weather info (temperature, rain data etc.) into that log when that entry is created (maybe even pulling in the date field and fetching the weather for that day automatically)? I reviewing ideas about using IFTTT or other automations but none seemed to allow for that day's weather info to be inserted into a log entry on record creating easily. Also, as you can see in the screenshot, I have to create a formatted record of multiple sub-items in a longtext field eg. in trade updates. Ideally these should be some form of structured sub-items but I am not sure if there's any way to handle that in this interface or data field (without creating a separate lookup table)...Thanks!

Importing csv files with 18 digit numbers, doesn't work What I tried to import: 513267577250775049What actually got imported: 513267577250775040Simple terms: The 9 digit at the end of the number, got changed into a 0The relevant CSV file to import, is below.  name,server id,notes Ergonomic chair,513267577250775049, Wooden storage box,, Wooden pen holder,, 

Hello, Everyone!I am desperately looking for a solution for something where I thought that it's easy to do. But somehow this is beyond my thinking. 🙂The situation:I have a table, grouped by a reference ("EXA"). Several records with same reference ("EXA") go through different "status" until it's done. The "status" gets updated slice by slice for the records with same reference. So far so good.What do I want to achieve:once all records under same reference have reached the same status (for e.g. "DELIVERED to project site") I want to get an alert. Best would be an automation which sends an email saying that all is done for EXA# 24DE535529298955B6.I hope the solution is not too easy, otherwise I would be frustrated by my own skills. 🙂Kai 

Hello I have these four pieces of data: Project Name {Text Field, Primary Field} Project Start {Date} Project End {Date} Project Team (multiple people) {???} *can be separate table I want to be able to create these views: a gantt view for my projects This will show the project name and the start and end dates a gantt view for each individual team member This will show each project they are working on My team will consist of four individuals that will be working each project. Some projects will have all 4, others will only have a couple. I need to be able to see how many projects each person is working on and how long they will be busy with projects. For the Project Team data I’ve tried linked records, collaborators, and mult-selects but they aren’t being treated as individuals, they are being treated as a group in all the versions of the gantt I’ve tried.

I would like to run Automation every week on Sunday, and the purpose is to have a running change for my Pivot Tables. I would like to take the "Items", "QTY" and "Last Date/Time Updated" from Table1, and copy/ paste that data into the Table2 which has the same column names. Is this possible and how is it done? I was poking around and wasn't able to figure it out.

Hi,I am looking for help to setup a sprint workflow in my Airtable base to plan sprintdeliverables ahead in time.I want to be able to plan subtasks (statuses within tasks) in future sprints. For example, I have a task, that has multiple subtasks such as Design, Development and Deploy. I want to be able to plan Design in sprint 22, Development in sprint 23 and Deploy in sprint 24. Ideally I would have a overview where I can see all sprints with all these subdeliverables in their respective sprints.Who is able to help me?Thanks!Mark

Hey everyone, I had a quick question to see if this is possible. I view my projects in a timeline view that is grouped by what phase the projects are in. The top group are projects that are coming up, but sometimes I dont have a date for an upcoming project aka I dont see the project in my timeline view. I dont want to forget about possible projects that are coming up with no specified date and was wondering is there like some sort of an option with airtable timeline view to have records that dont have a date show up under the group name on the left bar or somewhere where I can remember like ohhhh right that needs to be scheduled? Thank you for any help!

Hello,I am trying to create a stacked bar graph in Airtable like the one I made in excel, but there's something I'm not quite understanding about how the chart extension tool works in Airtable. I cannot group the different day ranges under the record #, only the total, not the individual segments stacked. Any help would be appreciated, thanks.  

Hello - we use a formula field to create unique & automated "Activity Titles" for records.Our current formula pulls from various fields:Program (multi select)City (linked field)Type (single select)Date (date)Current formula is: Program & " - " & City & " " & {Type} & (" ") & " (" & (DATETIME_FORMAT(Date,'YYYY/MM/DD')) & ")"This results in an Activity Title that looks like: Corporate Event - Philadelphia Webinar (2024-03-21)The problem we've run into is that some of our Activities are with multiple cities - 30+.So when the formula pulls into those Cities into the title, the title then becomes unusably long - Corporate Event - Philadelphia, New York, San Francisco, Pittsburgh, Buffalo, Winchester, Miami, San Diego, Portland, Seattle, Minneapolis, Richmond Webinar (2024-03-21)Is there a way to utilize an IF formula that looks at the City (l

Hi everyone, I have created a form from one of the templates and embedded it in my joomla website What code can i add that will make it one long form so that it doesn’t scroll in the iframe? I would like just the webpage to scroll not the iframe if that makes sense. Many thanks Jim