Hi, I have a Sharepoint list that I have modifed the form for. The main fields that I am using are:
Current Salary
Percentage Increase
Future Salary
I want to be able to set the future salary = Current Salary * Percentage increase. Also, update the percentage increase based on dividing future salary by current salary.
I currently have an onchange function on percentage increase and future state, by using variable test1 and test2. This works great on the initial save/create. Percent increase and future salary both have their default values set to the variables. The issue I have is when I open an item from the Sharepoint List, it is referencing the 2 variables in the default and not the values from sharepoint. How can I get the real-time calculations and the default value to work (when a user wants to edit this)?
Set(test1,(((DataCardValue16.Text / DataCardValue14.Text)-1)*100))
Set(test2,DataCardValue14.Text * ((DataCardValue7.Text *.01) + 1))
Solved! Go to Solution.
Hi @JasonMilwaukee2 ,
You could use below formulas to achieve this:
If(SharePointForm1.Mode=New,test1,ThisItem.ColumnName1)
If(SharePointForm1.Mode=New,test2,ThisItem.ColumnName2)
Regards,
Mona
Hi @JasonMilwaukee2 ,
You could use below formulas to achieve this:
If(SharePointForm1.Mode=New,test1,ThisItem.ColumnName1)
If(SharePointForm1.Mode=New,test2,ThisItem.ColumnName2)
Regards,
Mona
User | Count |
---|---|
227 | |
101 | |
93 | |
56 | |
30 |
User | Count |
---|---|
288 | |
116 | |
110 | |
62 | |
58 |