InfoPath Dev

I see now how to eliminate padding. Select the cells and then right click to 'table properties'. It works best to do it before placing controls in the cells.

When you publish the form to the library, include the Year field as a promoted property. Then, add a secondary data connection to the same library that your form is published to - make sure to deselect the checkbox that automatically loads data when the form is opened - you don't need data till you get ready to submit your form. As part of ...

Hi Hilary Yes, I'm submitting the form to SharePoint. Sorry, I'm not sure how to query the list to retrieve the last record in the list base on the year field. I do have a Year field in the form, and the autonumbering field with this formula in the field "max(ReqNumber[CustPreFix = ReqPrefix]) + 1". it will look for the ...

I have a table with that is about 8 by 10, with one text box in each cell. The problem is that they are much narrower than the cells. I can drag them somewhat larger (that's a lot of tedious work) but they still don't fill the cells' width. Is there a good way to make them wider? Maybe some way to eliminate padding? Thanks Pete

Thank you Hilary, I tried the "conditional formatting" approach. Basically, I added one more rule before the submitting rule for the submit button. And added the following steps like: // Condition: State1 = "Old Dominion" // Run Type: Action // Run these actions: Set State1 = "Virginia". After the form is ...

Hello, I'll ask your help with the attached form. There are two topics. In the E-Mail e-Archive section of the form, the user must enter the e-mail address in the current format. They need to enter the e-mail address correctly. Do not accept when they enter wrong. Another topic at the bottom of the forum is that Registration ...

So - I dislike any such auto numbering sequence - I think it is fraught with the possibility for error. However, I understand that sometimes business requirements aren't as flexible as one would like! I'd probably promote the year to the library you submit to (assuming the form submits to SharePoint?) and then you can set the year query ...

I'd either use a specific email view or a little conditional formatting for this. If this is a browser form, using a specific email view is simplest. Just create a new view, and use a calculated value for the dropdown field (which will contain the value). When the form submits, switch to the email view first, then submit. If this is not a ...

Let's say I have a dropdown box with the following options - Display Name: The Golden State | Value: California | Display Name: Old Dominion | Value: Virginia | Display Name: The Lone Star State | Value: Texas | When users fill out the form, they see and pick the display name, after they submit the form the submission is ...

Hi I'm trying to create a form to capture Change and need to have AutoNumbering on the form base on Current Year and customer Prefix. The auto number need to be reset when it cross over the year. The format will be yyyy[Customer Prefix][AutoNumber], so example the form capture 2019AB01, 2019BC01, 2019BC02..2019AB35... Then in year 2020, ...