-
Sure. I sent an email to you via the forum.
-
So you need total chars to be 16? And we'd trim any extra off the SetOfBooks field?
-
You may need to rebind the repeating table to the other data source first. Basically, the repeating table needs to be bound to the correct data source - then you can change the control inside it.
-
A layout table can be added from the Insert menu - Custom table - I selected a single row, single column table. Then I cut & pasted the table into the cell. :)
-
You had conditional formatting on the control inside the repeating table to hide it, but not on the table itself. So I copied that rule to the table. Also I put the table inside a layout table cell - perhaps this will now look the way you want it to.
-
I think if you put the repeating table in a layout table cell, and format that layout table cell to have a white background (and auto-height), this might display as you wish. But can I see your form? I'm not sure why you have the gap, as you aren't using a layout table in the last copy I have (which is a common cause of this).
-
Here's a link to a download: https://spaces.hightail.com/space/0oVmqQfv73
You can install the full trust form on a machine with InfoPath installed. Instructions are in the qRules Full Trust Form Installation Guide.pdf in the zip file. This is a trial version - if you hit the limits and decide the tool will work for you, let me know ...
-
I wonder if the field is just not returned if it is blank - I know SharePoint does that, but don't know about SQL. An easy way to test this would be to change the conditional formatting to color the row instead of hide it. Then add another formatting rule to turn it a different color if it is not present.... I suppose it could also contain a ...
-
I don't see any screenshots, sorry, just the form you attached. The rule to hide the row was to hide anything where the value was blank - which is what you are saying you want hidden.
-
Well - I took your copy and changed it, just to add conditional formatting. Here's the copy I posted the other day with the same format change - I haven't walked through the data connection, so I'm not sure what would have changed there.