-
Instead of using the people picker you can use a repeating field and simply show the Display Name only. This will work for the read-only case, but if you did want to make it editable you will need the Account ID. Good luck!
-
I have attached an example here. When you first open the form, you will see the NaN error in the percentage field.
Once you enter dollar amounts in the Present Salary, Increase, or Other Adjustment fields, the NaN error disappears.
Perhaps a rule or a different method for calculating the percentage is needed?
I ...
-
Thanks - I think I understand now. You're a star!
-
Go take a look at the logic on the helper field - since that field is inside the repeating group, the rules it runs only affect the instances of the other fields inside the same group.
-
You can do this with a preceding-sibling formula. You'll want to hide rows where the preceding sibling agenda item and the line comment are the same. I'm attaching a simple sample - save the linked form (in the heading of the post) locally, right click the saved file, and select design. Then preview it. There are two instances of ...
-
*sigh* It works on the VM I'm running on the same computer but not on the computer itself. Don't you just love Technology?
I can see there's the hidden helper field with the rules on, so:
When you click the < button, the hidden helper field value is changed to "Back"
When the hidden helper field = "Back", the ...
-
If you have managed to open previously the template from my computer, might be it would work again?
-
It is saved as an IP 2007 template (I just double checked). When you download it, right click and select design from the locally saved file - is that how you tried to open it?
-
Yes stil the same.
Thanks for the reply Hilary.
I think I have figured it out though. The column holding the numbers in the SQL database was set to a data type of 'float'. When i changed it to an integer the form worked.
However, I need it to remain as 'float' in SQL, so to get around the problem, I changed the ...
-
What happens if you try the sum formula w/out the filter ([. != ""])? Still NaN (Not a Number)?