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
Hm, if all of this is done via the table, it seems like toggling “Allow linking to multiple records” off for both of the linked fields would work? This would prevent users from assigning multiple contractors to a project and vice versa
If this wouldn’t work, could you share more about the workflow?
Hm, you could make an automation that triggers when the project’s status is “Complete” or some such, and make it update the record by clearing the assigned contractor field and adding that contractor to a “Completed by” linked field?