InfoPath Dev

Hi Catharine, For this you would actually want to use a web service. The DBXL Web service can be used in conjunction with DBXL to submit directly to the SQL database. DBXL would allow you to take a form submission and build a database mapping to send the data directly to your SQL table, and even sub tables. Here's a link to some details ...

Hi Tom, A muti-select list box is tied to one field in your form. Once promoted as a property to you library, all of the values are concatenated because there is only on row of data. You would need to have each selection as a separate field in your form, or use default data with a repeating data structure that could then be pushed out to a list ...

Hello klink, qRules would definitely be the way to solve this. You'll need to bring everything into the main data source. You'd first query the goals list as the Parent and then use Insert to add the correct number of children to each goal, and set value to populate the children objectives text. Inserting and setting values ...

Hello John, In this scenario you will probably want to have a query trigger that functions from the user input. This would man the field would have conditions to query. You can  then also display the dropdown in the view multiple times, with different data sources and use conditional formatting to hid the dropdowns based on the user ...

Hi Catharine, I have seen this error with regards to the connection between SharePoint and your local desktop. The first think you might want to do is add the site to your local intranet. For this, navigate to your Internet Explore Internet options > security > Local intranet > Advanced > add and enter the SharePoint site. Sometimes ...

Hi Jari, What you'll want to do is use  validation rule on the text box. There are default patterns, and you can also create your own. You can set a pattern to be compared to an entry, and also give the user an error if they enter data that does not match the pattern. In this case, you could use the custom pattern: ...

Hello Phil, Attachment limits are something we deal with frequently in form design. Although increasing the limits may seem like the best rout, you may be doing your users a dis-service. The larger the attachments, the slower your forms will become and could even cause your forms to stop working properly. This is because the attachment sizes ...

Hello yurekha, For this you will need a helper field. I typically use a calculated value from a secondary data source, and set it to a custom error message. You'll also want to check "don't run the remaining rues if this condition is met". This will stop your submit actions and display the message. Just make sure to clear the ...

Hello dapklp, I world advise keeping the workflows 2010. The 2013 workflows are a bit different, especially with mail workflows. 2010 workflows function just fine in the 2013 environment, just not vice-versa. Specifically I office 365 if you try the 2013 workflow and your email domain is not joined to SharePoint, the workflows will fail with ...

Hello Steven, In this instance you will need what we refer to as a helper field. This field will have a default value, using the pc:AccountId field from the people picker. For submitting to a list, the value that is submitted needs to force a lookup to the User Profile service when submitted. Here's the ...