Hello,
I am still learning about airtable and currently developing a base with different tables. My objectives are as follows;
-Link contractors with projects -done through sync with source base which hosts the projects.
-Assign projects to contractors one project at a time-once a project is completed, the contractor should be available for reassignment and previous project assignment should be removed in their profile-This has been achieved partly, pending the part of deleting previous assigned project and transfering that to another field for reporting purposes(i.e if at any given time i want to see the number of projects executed by a specific contractor.)
-Once the contracter has been assigned a project, the contractor should not be available for any other assignment until the current assignment is completed-this has been done partialy, when project status is started, contractor status changes to engaged and to available when project status changes to executed. However, am not able to stop assignment of additional project once someone notices the contracter is engaged. Kindly advise
Regards,
Nelly