InfoPath Dev

I haven't used SharePoint Designer Workflows for a while - but I think the workflow creates a column in the library, right? It looks like that can't be used in a calculated column, however, I just checked that on an old library that I'd had a workflow on. I wonder if in each of your different workflows, you could add a step to check ...

Oh yes, sorry, you had mentioned it worked in preview and I'd already forgotten that. I've done some additional web searches (and I'm sure you have too) but I'm not finding anything that seems applicable. I doubt a SQL Trace would provide any additional info that the logs haven't, but I might try that, just see if there is ...

Ohhhhh. Interesting. Super dumb question - you've verified the user name and password on the SQL 2016 server by logging in with that account? Like, in SSMS, or something? :)

Is this a list form? Do you mean the field is multi-line? If so - is it plain text in the list settings?

Well ick. It seems like the form is able to find the UDCX file, since it is actually logging into the database..... I think I'd probably double check the manifest file (save the form as source files, open manifest.xsf in a text editor) and see if there is anything in the SQL connection stuff or the path to the UDCX that seems off. I also ...

So, this really isn't possible, I don't think - your column 2 would have to be a multiselect, and there isn't a way in InfoPath to select all in a rules based way. You could concatenated the results using a double eval, I suppose, and store that in a multi-line column. Search the forum for double eval to find samples of that.

Ah, I guess a user could have add rights w/out edit - hopefully if someone else has seen this they can chime in.

What kind of form? List or library? I mean.... won't any user who uses the list edit form (if this is a list form) have to have edit rights?

So - my guess is that you are using a dropdown for that State, and it is set to store the ID and display Title or something in the form. You could change that to store the same value as what is displayed, so that you are submitting the text instead of the ID. Or you could add another field and set that to the text value when the user selects the ...

Hi - as long as you have the ID number of the item from List A in List B (i.e., the user selects from a dropdown) you should be able to populate values in the List B form with data from List A. You'll need to use filters on your rules to set the values in your form, but shouldn't need any additional list. Can you tell me what is happening ...