Hi Everyone,
I’m using Appsheet to build a solution for a company I work for - taking our timesheets digital! One of the problems I have with this is with permissions as the timesheets go through the review process. To illustrate this, here’s basically the three stages.
To be clear, Timesheets are in one table, line items are in another table. Each line item is tied to a specific timesheet with a TimeSheetID.
In order to do this, the Line Items must be editable. HE has to be able to add, update, delete the line items in Today’s time sheet. At this point I have a Column (Status) which reads Draft.
At the end of the day, the employee clicks the Submit button.
How would I allow an employee to view his submitted timesheets, but not be able to edit any referenced line items once the status on the Timesheet has been changed to submitted?
One way is the Editable_If option. You could try to use a formula like [TimeSheetID].[Status]=“Draft”.
You probably need a grouped action… When they are looking at the detail of their time sheet, click the “submit and lock” group action… (I would put a confirmation message on it.) (I would have a column in the parent and the child table yes/no [status_employee_submitted] initial value FALSE
First action - data change - parent record employee status to flag to “TRUE” Second action - reference action - change all the children to “TRUE”
https://www.google.com/search?q=appsheet+reference+actions&oq=appsheet+reference+actions
As you can see there are lot of different ways to built that functionality. One simple way is if you hide that system EDIT action button with the same formula [TimeSheetID].[Status]=“Draft”. It will show the action button if the status is “Draft” and they can edit the inline record.
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |