Hi Community,
I have an app to capture user attendance entries.
How to have the Manager to approve in one go (as a Signature) for all the employees working under him.
Thank you.
Solved! Go to Solution.
Approvals will apply to a whole row.
Hereโs how the thing can be brought to fruition:
Add an approval column in the โattendance entryโ sheet, with type Yes/No. The initial value of it should be โNoโ.
Add a virtual column in the attendance table, which is the concatenation of all the pertinent columns, that a manager needs to see to uniquely โidentifyโ each entry. Letโs call this Att_Vir.
Make another approval sheet for the managers, with appropriate fields like โAttendance to approveโ, โuserโ, etc. You will better know which columns to use.
In the โattendance to approveโ column, use a valid_if using โSelectโ expression, that shows the Att_Vir columns in the drop-down (the type would be enum-list). Proper filtering criteria have to be used, to show entries that are unapproved (based on that Approval column) and under the liability of that manager (probably when the user enters his name in the attendance sheet, then the associated managerโs name will come up using dereference).
Get these in place, and I will guide you on what expressions to use.
I assume that you have the relation between the managers and the employees working under him within a table.
I would myself set up an โapprovalโ form, that will log the managerโs e-mail and consequently his name. There would be a column for the employees set up as reference and base type enumlist (that lets you make multiple selections at once) and a yes/no column that records whether the record is approved or not. It would be of initial value โNOโ.
Now I would set up an action available only to that manager ( I assume that you have rules set in the app to distinguish the managers) for the โapprovalโ table that will set the approval column to yes from no. Further you can set up a virtual column that shows โapprovedโ or โpendingโ based on the approval columnโs yes/no, or you can directly use an approval column with type โenumโ with values โpendingโ and โapprovedโ.
The action being available to only that manager, it kind of equates the whole thing to a signature, as no one else would have possibly approved a record, other than him/her.
Lastly in the detail view of the approval table records, you can set the โapprovalโ column as the header column, with color formatting rules that will show up big on the top of the page.
Iโm more than sure this isnโt exactly your requirement, but it will provide an overview on how to start. If you be more specific then it would be easier to fine tune this whole thing.
Hi @Pratyay_Rakshit,
Thank you for your time & effort in drafting this detailed explanation.
To give you an idea of my app,
Table Attendance Entry captures the basic associatesโ details using their IDs with their individual attendance data.
Now,
1) I assume that you have the relation between the managers and the employees working under him within a table
Yes, I have.
2) I would myself set up an โapprovalโ form, that will log the managerโs e-mail and consequently his name.
Yes. Managersโ Id/ Name is sufficient.
3)There would be a column for the employees set up as reference and base type enumlist (that lets you make multiple selections at once) and a yes/no column that records whether the record is approved or not. It would be of initial value โNOโ.
Now I would set up an action available only to that manager ( I assume that you have rules set in the app to distinguish the managers) for the โapprovalโ table that will set the approval column to yes from no. Further you can set up a virtual column that shows โapprovedโ or โpendingโ based on the approval columnโs yes/no, or you can directly use an approval column with type โenumโ with values โpendingโ and โapprovedโ.
The action being available to only that manager, it kind of equates the whole thing to a signature, as no one else would have possibly approved a record, other than him/her.
Pls correct / help in the following items,
a) In this scenario, if we consider having Enum List (I guess, itโs the Name of associates), I need to populate ONLY the entered data.
i - What would be the cut off date for the Manager to approve.(if we are to consider all dates, then,how it can be done?
ii - If not, we have to ask the manager to select date & approve.
Other steps seem doable & clear. Let me try this & get back to you.
Thank you.
P.S - If you wish to check the app & data personally, I shall share with you to your email.
Iโm not sure I caught that. Please explain.
As for your concern with the dates, any scenario is doable as far as date ranges are concerned, be it predefined in the editor, or input by users.
You have to elaborate your requirements too for this
I have a sheet with all the Associatesโ data.
In the Table Attendance Entry, the user selects the name & then, enters the attendance for that particular day.
Now, to answer your question, the Manager should be able to approve only what is entered in the above table & the same holds true for Names of associates (which we are going to show as Enum List).
But, how is this going to reflect in the original data? (I am just thinking loud)
Totally doable.
But first I need to get clear on a couple more things.
Are the โassociatesโ same as the โusersโ that you are referring to? The manager โapprovesโ the โusersโ or โassociatesโ or are they essentially the same entities?
enters the attendance for that particular day.
Whatโs the data type for this โentryโ? What do they actually enter?
1)Yes.
2)
This is how the form looks,
So for the โattendanceโ data, a manager needs to know whether the associate is โpresentโ or โabsentโ (from the [Attendance Type] column) and if heโs present then the duration of his service (start time and end time).
Based on this you need the manager to approve the โattendanceโ. Correct?
And attendances, as general rule of thumb, should be done for each day. I donโt see a date column in the form.
So when the manager approves, what does he approve actually? If I was a manager, I would approve my subordinatesโ attendances for a day. If there is no Date column then it is in no way possible to filter out unique attendance entries.
No, we have Date column also.
Itโs not visible in the above image.
Manager just needs to check & Approve the attendance.
(Probably, we might need give space for date wise, associate wise approval)
Thank you.
Approvals will apply to a whole row.
Hereโs how the thing can be brought to fruition:
Add an approval column in the โattendance entryโ sheet, with type Yes/No. The initial value of it should be โNoโ.
Add a virtual column in the attendance table, which is the concatenation of all the pertinent columns, that a manager needs to see to uniquely โidentifyโ each entry. Letโs call this Att_Vir.
Make another approval sheet for the managers, with appropriate fields like โAttendance to approveโ, โuserโ, etc. You will better know which columns to use.
In the โattendance to approveโ column, use a valid_if using โSelectโ expression, that shows the Att_Vir columns in the drop-down (the type would be enum-list). Proper filtering criteria have to be used, to show entries that are unapproved (based on that Approval column) and under the liability of that manager (probably when the user enters his name in the attendance sheet, then the associated managerโs name will come up using dereference).
Get these in place, and I will guide you on what expressions to use.
Great @Pratyay_Rakshit!
Thank you so much for your time & interest!
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |