Table linked to itself
I have a table linked to itselfA Lookup field type still works fineBut a Count field type always returns the value 1 when in some cases it should be more than 1
Forum Posts
add +100 on each new row
Hey,Something super basic to do in any excel, python script etc. but how to get in in Airtable?I want to create some kind of ID for each customer. First customer has number 900100, and each new one (this is a child table) should get the number +100, ...
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?
test scoring formula
Hoping someone can guide me with setting up a formula to score tests that are reported on another table.Here's the current setup:Table 1 - record of all test takers by session ID, including fields for all of their question responses.Table 2 - questio...
How to search for what's missing?
Hi all, I'm working on a donor management system for a non-profit org. Donors make pledges to give $x on x recurring basis, usually something like $50 a month.I've got a table for Donors, one for pledges, and one for donations.I need to have a way t...
Resolved! Template help
Hello everyon, so I have created this project management based on the template. I have got around 10 people in the group and how can I do that when each person logs into that base it will show tasks by name individually? Cuz for now you have to do it...
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...
Filter rollup field by created date
I have rollup field that sum all the records from a table. I want to limit the sum from all to sum for current month only.How can I do it?
Resolved! Loom content in formula field
Hi! Wondering if there's any way to make this work...I have a formula field that pulls info from multiple fields & concatenates it all together to create an email (content) to be delivered to the person associated with that record.I want to include a...
Combining fields in table into formula
Can someone assist me with writing this formula? I'd like to basically have a column in which the staff or faculty nominee column is combined with the value. For example: Cameron, Ali - Innovative SpiritI'm running into an issue were if the staff col...
