Skip to main content
Nintex Community Menu Bar

Hi,

I created sharepoint list called Fuel reimbursement.I have customized this list using Nintex form.
Every year employee can get 1000$ for fuel reimbursement.suppose employee apply for 300$ then the remaining amount will be 700$.when employee apply for second time then he/she would be able to see this remaining amount means(700$) on the new form.I have one column called "Amount" and other column called "Remaining Amount".
"Amount" column value is coming maually entered by user.
"Remaining Amount" column value is coming from Calculated value of nintex form.
Calculated value=1000$-Amount(which is entered by user).
How i will get this remaining amount value on the new form for that particular employee who
already applied for fuel reimbursement.

 

Thanks & Regards,

Masroor

A few different ways you could do this.
The below formula looks up all the entries for an employee. It then finds the latest entry by ID. The highest ID will be the latest entry.
Once we know that, you can lookup the "remaining amount" column for the employee.

lookup("Fuel reimbursement","ID",Max(lookup("Fuel reimbursement","Employee column","Employees name","ID",true)),"Remaining Amount")

Hi Simon,



Thanks for providing me the best solution.I really appreciate your effort.Now i have stucked in one requirement for the same scenario.My requirement is employee can uitilize this reimbursement amount of 1000& for every year.
when next year will come then again employee can get the reimbursement of 1000$.
suppose employee apply first time for 300$, second time applied for 500$ and third time applied for 200$ for the year 2020. Now the remaining amount balance is 0$ for this year.I am hiding the submit button when remaining amount becomes 0$ and displaying the message sorry your reimbursement
amount limit is over please apply next year.when the next year will start then how employee can utilize 1000$ reimbursement.Because in new form remaining amount(calculating by the formula which is given by you) will display 0$.How i will implement this scenario.Employee should get the reimbursement of 1000$ every year.



Waiting for your positive reply.
Please help me to fix this issue.

Hi,



The formula you provided was great and it helped me in few scenarios . Is it possible to provide any custom message if there are no values matching for our lookup condition?



 



Thanks for your help.



 

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Check Nintex Status
Terms & ConditionsCookie settings