Limit data submission by user
I would like to limit the number of rows created in a table. I am planning to have a limited data entry period with 100 users where each user can only put in 10 rows of data. How would I achieve this with Airtable?
Forum Posts
Resolved! Add Dates Automatically based on Word
If there are options in a drop down menu (example Quiz or Test), start dates are entered by user, can I add a new column with a formula that detects the word 'quiz' or 'test' in the previous column and add an end date automatically based on the word?...
How to return the ealier date and the latest date from two separated columns that was groupped?
Hi ! Coleagues, I have a project in AirTable in a single table with 174 rows and 11 (eleven) categories that I can group these rows. Each of these 174 tasks has its own "Start Date" and "End Date" column, with date format in it. I want to...
Resolved! Returning values of concatenated multiselect fields in an unordered list
We have a form our users fill out that requires selecting a few entries from a long list of items, which we've managed to clean up by storing items by organization name--each organization has its own multi-select field, and they're conditional upon t...
Separating multiple data entries in field
Hey,I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!
Resolved! Counting task completion
Hi all!I've been scratching my head and couldn't solve the problem quickly, so I'm asking for your help.I need to display a progress bar with the percentage of completion of a specific task, under which there are subtasks. In order to understand the ...
Create a project Management table where start date changes based on end date of depended record
I want to create an Project Management Table with the following requirementsI have several project stageseach stage has a start date and an end date (automatically calculated based on duration for each project.)the start date of one stage should be d...
Resolved! Best way to extract one client's multiple records from a table, then list info from 3 fields.
Hi. I'm sorry if this sounds a bit vague, but what I'm trying to do is this:I conduct sessions with students and each session is a record. At the end of a month I have a table with multiple students and their sessions. Some students will have 4 or 5 ...
Formatting roll up arrays with more than 2 bits of data as dates to use in an automation trigger
Hello,I have been googling this for a few days now and really need some help!I am trying to set up an existing customer email reminder automation that uses date the next time we are going to visit a venue. The trigger will start a month or so before ...
Does ANY value from Field A match ANY value from Field B?
Hi, everyone! It's my first post, and I'm relatively new to Airtable and to databases more broadly. Hoping for some help.I'm using a base to organize staff for a conference. Volunteers are attending some sessions and working other sessions. I have a ...
