-
Hi Tom,
For cases like this, the quickest approach is to add a Boolean (default to FASLE) field to your form and name it isSubmitted. This field will be hidden from users and will only contain values which form load rules will depend on. For the submit button, before submitting the form, add a rule which sets the ...
-
Hi Jen,
When searching for values from a SharePoint site, queryFields are populated with desired values in order for dataFields to return target values. However, if you search for items again, the data on the queryFields are retained. You will need to clear all the fields at the queryFields group before searching again. In other ...
-
Hi Matt,
I understand that you are looking for a formula which adds up the sum of items having a certain type. If you are using a repeating table, then you could use a formula such as:
sum(field1[field2 = "Type1"])
where field1 is the item and field2 contains the type of item. To add this condition, click the filter button after ...
-
Hi Karen,
Apologies for not replying sooner. I went ahead and added a few things to your form. Please check the section below for the repeating table. in order for you to add a fixed/permanent row to the repeating table, proceed to the data tab and locate the Default Value button. A windows will appear showing all the fields on ...
-
Hi ShaneHarvy,
The formula below is what I use for form versions:
concat("Form Version: ", substring-before(substring-after(/processing-instruction()[local-name(.) = "mso-infoPathSolution"], 'solutionVersion="'), '"'))
If it's not working, kindly try to delete the calculated value box ...
-
Hi Jen,
You may need to add a rule on your search button to clear all query fields first before assigning query values so that the field will not retain previous search values. Please let me know if this helps.
-
Hi Sandeep,
Please check the image below for a sample validation rule to prevent users from submitting data if not all items are approved. Basically, you would just need to add a validation rule to the field which runs if not equal to Approved. Don't forget to add a screen tip message.This should now show a validation message if not ...
-
Hi snturner,
Both EndDate and StartDate are fields from the form displayed on the canvas. What was needed here was a formula to prevent the user from selecting a date 3 days after the start date.
If user selects May 29 (for the StartDate field), the Validation formula added to the EndDate field will show a validation error if the user ...
-
Hi GCTEK,
A conditional sum formula would look like the formula below:
sum(field1[field2 = "Test"])
Where field2 will have a condition that it is equal to Test. You can achieve this by adding a Filter Data as shown below:
However this approach is tedious as opposed to using an unused column.
Regards,
-
Hi Kevin,
I'm not sure if we are on the same page but if you are copying the data when creating an STP file, you will need to check the Include Content checkbox when saving a template. I hope this helps.
Regards,