-
Based on a comma delimiter? I'm not sure if that's going to be possible out of the box....Any reason to use a rich text field for this? Wouldn't it be easier to use a repeating field so that you can just count those?
-
Have you removed the column that was the lookup from the list? There should a button someplace on the form in design mode (I think under data) that refreshes the form data source - I'd guess if the lookup column is removed from the list, refreshing the fields would remove the data connection.... have you tried that?
-
Hmmm... Do you mean count each time the field changes? So, Jane enters some text, and that gives you a count of one, then Jane goes back and enters more text and the count is two, then John enters some text and that's three and so on?
-
Right click the link and download the file. Right click the saved file and select design - then you will have the form opened in designer.
-
Ok. So these are list forms, and it sounds like you are using SharePoint on prem. So you may be able to do this with CAML (whether it works in the browser will depend on the server, so unfortunately you'll end up doing the work without knowing for sure if it will work until published). You should be able to find some posts / samples on this ...
-
You've checked the ULS logs for any additional info?
-
I find default values really problematic in a lot of circumstance. Have you considered using a form load rule instead? Just leave the list column without a default and add a rule in the form load rules to set the field to the default value you want if the field is blank - or if you only want to do this in a new form, if the ID field is blank.
-
I'm having a little trouble understanding - but my guess is that ID isn't equal to what you think it is. If you look in the list, what are the values in the ID column? Are any of them "Others" or "Any Others"? You can always attach a copy of your form or a screenshot under the options tab in a reply to help explain the ...
-
Glad you have it working & thanks for the compliments - have a great day!
-
I didn't realize the field in question was in your repeating table - your hidden field also needs to be in the repeating group, because if there are 15 rows, you might have 15 different values for the SHIP Plant, right? I've attached an updated file here - save it locally, right click and select Design to open in InfoPath Designer. The ...