Jun 02, 2022 07:06 PM
I’m using Airtable records for individual jobs in my business.
I’d like to incorporate timesheets into Airtable and have the timesheet data link to the job records.
I’m imagining a separate table for employees and their various pay rates which links to the main jobs table and calculates the cost of the job vs the budgeted amount, but I don’t want the pay rates and job costs to be visible to non-management employees.
Is this possible in Airtable? Is there perhaps another way of approaching this problem to achieve the same outcome? I’d love to hear any feedback!
Jun 02, 2022 09:11 PM
Welcome to the Airtable community!
If someone has direct access to a base, that person can view all the data in the base. Thus you need a system where external users don’t have direct access to the base. Here are some options:
Jun 02, 2022 11:02 PM
Thanks for your reply - I’m liking the idea of your third suggestion.
Do you have an example of how I would link the employees to their pay rates via automation? I’m needing to report on the timesheet data together with the data from the jobs table.
Jun 03, 2022 05:39 AM
This sounds a bit more complicated than it is.
Also keep in mind that this system does have limitations.