I have made well, but I need to add second Approver which mean the request created by employee and I will approve it and it will go to my manger for final approve
Hi what if we have 2 approvers, status "endorsed for final approval', "fully approved". With 2 dates for the dates of the 2 mentioned? My problem is when status is "fully approved" the date on "endorsed for final approval" gets erased. Whats the get around?
Can we restrict the approver to edit only few coloumns in the request table? Like adding comments and uploading file. Also to get the email from the user who submitted the request form
Yes, there is an attribute called "Editable" for all column settings. Enter a formula there that will determine whether the field is allowed to be edited by the user. For example, if I have a column called [Approver] that stores the approver's email, I can use the formula [Approver]=useremail() to only allow the approver to edit the column. This video goes into column settings: th-cam.com/video/avv_YOHS_Ek/w-d-xo.html
Looks like you were missing a ) at the end of lookup. The following should work: and( [Status]="Pending", lookup(useremail(), Approvers, Email, Category)=[Category] )
Thanks. This solved my problem.
I have made well, but I need to add second Approver which mean the request created by employee and I will approve it and it will go to my manger for final approve
Hi what if we have 2 approvers, status "endorsed for final approval', "fully approved". With 2 dates for the dates of the 2 mentioned? My problem is when status is "fully approved" the date on "endorsed for final approval" gets erased. Whats the get around?
Excuse me, Can U help me? I tried to copy this app, but I'd met mistakes. How can I show it?
Can we restrict the approver to edit only few coloumns in the request table? Like adding comments and uploading file. Also to get the email from the user who submitted the request form
Yes, there is an attribute called "Editable" for all column settings. Enter a formula there that will determine whether the field is allowed to be edited by the user. For example, if I have a column called [Approver] that stores the approver's email, I can use the formula
[Approver]=useremail()
to only allow the approver to edit the column.
This video goes into column settings: th-cam.com/video/avv_YOHS_Ek/w-d-xo.html
and(
[Status]="Pending",
lookup(useremail(), Approvers, Email, Category=[Category]
)
Not work
Looks like you were missing a ) at the end of lookup. The following should work:
and(
[Status]="Pending",
lookup(useremail(), Approvers, Email, Category)=[Category]
)
Thanks