InfoPath Dev

Hello,

Is it possible to hide certain column in repeating table based on conditional formatting?

I have a repeating table and I want to hide several column from user to see. The column will only visible after is it approved by the manager.

Can anybody help?

Thanks.

do you have any (kind of) static value within your repeating section on which you can determine if the section should be hidden or not ?

static value?i don't think i have it..

what i mean is on which value or what ever do you decide if the section should be shown or not. my proposal then would be to add on additional control to your repeating section. then i would use conditional formatting on the repeating section like "if fieldToDecideIfIShow == false AND additionalField == blank then hide this section. last step required would then be to fill the additionalControl with any value after the manager approved the document. like this additionalField would not be blank anymore and the section would show up. does this help ?

thanks for the solution..

but your solution is for the whole repeating section,right?

what if i want to hide certain column in repeating table?

depends on how many controls are in your columns. if it is only one or two just use the same trick for conditional formatting on the control itself. if there are many more then i put all of them into an extra section within your repeating section and hide the complete section.

Thanks for the solution nukkumati but sorry to say that it still did not solving my problem.

You see, in repeating table there are rows and columns right?We can hide certain row using filtering, but how can we hide certain cloumn in a repeating table?For example I have a repeating table with 5 columns which are stockno, stockname, stockdesc, stockprice and remarks.I want to hide the remark column so that user cannot see it. The remark column can only be viewed by approver.

Is it possible to do that? 

i wouldn't know a way how to do this. my proposal would be that you have two different repeating tables. one which shows all columns and one where the remark column/fields are missing. then put conditional formatting to the repeating sections to show the one with all columns only when a manager opens the page. would that be possible for you ?

Hi nukkumati

Seems that your suggestion solve my problem.

Thanks a lot! 

you welcome. glad i could help