I'm using the PO Approvals template and I would like to automatically add an approver if the =[Amount] is over $500.
In the process there are two steps I don't know how to do.
What do I put in the expressions field to trigger if dollar amount is greater than $500?
How do I add an additional approver automatically once the conditions are being met?
Overall this is an exciting program. I consider myself a horrible coder, but would love to get into this and gain another skill.
Any help would be greatly appreciated.
Thanks for building apps with Honeycode, and happy to help out with your app. These are the steps you will need to take to build the functionality you need:
Create a table with an Approver and Amount column. Format the Approver column to Contacts and the Amount column to Currency.
Next create an app and in the example I created, I added a list. Set the source of the list to the above created table. Show the Approver and Amount columns in the list. I have made the Amount editable, which means an app user can change the amount.
Next select the content box for Approver and go to its visibility properties. You will need to write an expression to show/hide this field depending on the amount entered.
The expression is: =IF(Table2[Amount] >"500.00", TRUE, FALSE)
You can also write =Table2[Amount] >"500.00". Either of these should work for you.
Thank you for the time and effort you put into this explanation. It is excellent if I simply wanted to hide the approver if the amount was less than $500, but what I'm trying to do is keep the existing workflow shown in the template. The only change is to automatically add an additional approver if the amount is over $500.
For example...
If Item is under $50 = Auto Approve (The template is already set up for this)
If Item is over $50 = Approval required by Department Head (The template is already set up for this)
If Item is over $500 = CFO is automatically added to approval list regardless of department
The addition of the CFO could potentially be 3 or 4 approvers down the line.
There could be a way places do this but I just tried the following. I added a new automation that adds the CFO once the status has changed to Approved by the final approver.
The condition for automation would be change of status and it should run if:
=AND([Status]="Approved", [Amount]>=500, FINDROW(M_Approvers,"M_Approvers[Project]=[Project] AND M_Approvers[Approver]=[Approver]")[Next Approver]="")
This is checking for 3 conditions: Status was set to approved, the approver is the last one in the chain and lastly the amount is >= 500.
Thank you for your help on this! I'm new to development so my ignorance will be very apparent here. But I have a couple of questions just so I can understand this correctly...
This statement you gave me simply triggers the automation and I still have to add an action that changes the approver to the CFO? Correct? Or does this command do that as well?
If I have to add an action, what would that be? My guess is to replace the approver cell to be the CFO instead of the first approver?
The trigger for the automation is still change in the status tracked by the [Status] column. This expression I provided performs additional checks to make sure the automation will only run when all of these conditions are true.
Yes, the action would be to update the Approver to your CFO. If this a single person, then you can directly update it from the automation rather than reading it from a table.
Please let me know if you have additional questions.
