Hi, I am evaluating airtable for use in our not for profit orgainisation and I’m struggling with the correct structure to start.
I have three tables:
Table Name: Trainee
Field: Trainee ID (Primary Key), Name, Address
Table Name: Courses
Field: Course...
Hi,
I have several tables within a base for example Student_Details, Course_details, Job_details. I would like to be able to run reports where for a given student I could see all the courses they attended, or how many students who attended a course ...
Hi, thanks for the reply and the steps. Tried it out and it works however I have a lot of similar data that I want to be able to report on the overhead of creating all these fields for each option seems a lot. I assume then that the basic functiona...
Hi, I have managed to complete the above sequence and that works fine. I am however having trouble with the rollup. I have a column that specified gender and I want to be able to do a count of (percentage would be even better) for the number/percen...
Hi, so I tried to do a lookup of a field in another table but I get no data returned. In the work history table I created a new column and made this a lookup of Course table to look at Course Passed. I have a Yes/No there but no data is returned. ...
