Controls

Re: Read only Rows for a Repeating Table in Infopath...

jvazquez — Tue, 04 Jun 2019 12:05:57 GMT

That worked like a charm Hilary. Once again, thank you for your quick responses and great explanations.

Re: Read only Rows for a Repeating Table in Infopath...

Hilary Stoupa — Mon, 03 Jun 2019 19:56:12 GMT

Ok! So the issue is the rule on submit that is setting the NotesCombined field. I think you should put that on UserNote instead - after the rules that set user / date. And you'll want it to also set NotesCombined to blank if the UserNote field is blank, just like your other rules. When the rule setting a repeating element (like NotesCombined) is outside of the group, as you have seen, it sets all instances! So in this case, they are all set to the values from the first row in the table. Not what you wanted at all. But if the control / element that sets the repeating element is inside the same repeating group (like UserNote is) it only sets the "current" instance. So, if you have 5 rows, the "edit" button only works on the row it is associated with, for example. The UserNote field only sets the fields in the same row as it is.... does that make sense?

Re: Read only Rows for a Repeating Table in Infopath...

jvazquez — Mon, 03 Jun 2019 19:03:43 GMT

Thanks Hilary - please see attached.

Re: Read only Rows for a Repeating Table in Infopath...

Hilary Stoupa — Mon, 03 Jun 2019 18:39:22 GMT

My guess is that the field with the rule is outside of the repeating table, so it is overwriting all the instances of the field. Can I see a copy of your form?

Re: Read only Rows for a Repeating Table in Infopath...

jvazquez — Mon, 03 Jun 2019 17:51:34 GMT

Hi Hilary, follow up question on this topic.

I have a repeating table which captures the user name, note type, date, (dash), and the user note.

I created another field within the repeating table section and added a formula to it within the field properties to concatenate the note type, date and user note. I promoted this field to display on SharePoint. The problem I ran into is that if the user did not enter a note, a dash was still being published to the library so I removed the formula from that field and instead created a rule to set the field with the concatenated values (when the user note is not blank).

It works okay when there is only one note added but when I add a second note and save the form, it shows the first note twice and not the second note. In my property promotions I did configure the field to go over as a merge.

Not sure what I am doing wrong or if there is a better way to accomplish what I am trying to do?

Would like to add the end result I am hoping for is that all notes from the repeating table appear on the sharepoint library.

Re: Read only Rows for a Repeating Table in Infopath...

Hilary Stoupa — Fri, 10 May 2019 16:14:56 GMT

Thank you - I learned so much from this forum when I was learning InfoPath that I'm always happy to hear that I've helped someone else. Have a great weekend!

Re: Read only Rows for a Repeating Table in Infopath...

jvazquez — Fri, 10 May 2019 12:38:00 GMT

Hilary, this is just what I needed. Thank you so much for taking the time to put that together for me. Now my form is super legit :)

BTW, I am a huge fan of yours. While I have been reading your responses in this forum for many years, I finally signed up to be a member. You have no idea how much you have helped me. You are definitely the InfoPath Queen!

Re: Read only Rows for a Repeating Table in Infopath...

Hilary Stoupa — Thu, 09 May 2019 20:55:35 GMT

This will depend on where the control is that sets the editable flag from no to yes - is it in the repeating table? Is the editable flag also in the repeating table? See attached simple sample - save locally, right click and select design and then preview. It's pretty basic, but should give the general idea :)

Re: Read only Rows for a Repeating Table in Infopath...

jvazquez — Thu, 09 May 2019 19:37:24 GMT

Thank you for this information, it works like a charm. I have a follow up question. As rows are added to the repeating table and set to read-only, is there a way to flag one row to make it editable? I tried changing the editable flag from no to yes but it makes all of the rows editable. Thanks in advance.

Re: Read only Rows for a Repeating Table in Infopath...

Qazi Anis — Thu, 13 Aug 2009 14:35:23 GMT

For the draw back. you can have one more column in the repeating table that indicates whether the comment field is editable or not, when the user saves or submits the form, change the value of the field to no. and make the comment field readonly on that condition. that should solve your drawback.

Re: Read only Rows for a Repeating Table in Infopath...

WPiersol — Thu, 23 Jul 2009 22:10:02 GMT

Here are two ways I have handled this...

In my repeating table I have the following columns:

User - Records the user who entered the comment with the userName()
Comment - Column for the user to leave a comment.

Method #1 - If you only want the user to be able to edit their comments...

On the Comment field set a condition on "If current user is NOT equal to User field".
If the result is true, make the Comment column "Read-Only"

Method #2 - If you don't want ANY comment to be editable.

On the Comment field set a condition on "If comment field is NOT BLANK "
If the result is true, make the Comment column "Read-Only"

Method #2 has a small drawback. The field is lock to read only as soon as the user presses "TAB" or clicks out of the textbox. So if they do it by mistake, they have to add another row.

But for my situation it works great.

Hope that helps.

William Piersol

Re: Read only Rows for a Repeating Table in Infopath...

aksiraj003 — Thu, 09 Jul 2009 16:43:49 GMT

Hi Hilary,

Thank you soo much Hilary, I was just looking for the solution if it is possible through code or not. I think the same, has you said it is not possible through the code. Okay I will follow the method which you have suggested me early. Had a great discussion, I'm very much thankful to you. Good day...

Thanking You,

With Regards,

Raj...

Re: Read only Rows for a Repeating Table in Infopath...

Hilary Stoupa — Thu, 09 Jul 2009 16:13:08 GMT

Why do you have to do it in code? I don't understand that requirement at all. I don't believe InfoPath gives us any programatic access to the controls on the form itself, only the fields bound to the form, so a coded solution may not be possible in this case.

Re: Read only Rows for a Repeating Table in Infopath...

aksiraj003 — Thu, 09 Jul 2009 07:15:26 GMT

Hi Hilary,

Thank you Hilary, this helped me to get to my solution. And I could able to achieve the solution. The work around is all about making it possible through the UI from the infopath, Right! (Like, Going to the properties of the control and clicking Display tab and and then selecting Conditional Formatting button and clicking add and setting the condition. Right!). I have achieved to my soultion by doing soo.

Now I have to achieve to the above solution through code ( pro grammatically, using VSTA in the Form Load event) Is this possible? Thank you in advance, please help me.

I have also seen your Blog its very impressive, I like to Thank you for sharing Knowledge...

Thanking You,

With regards,

Raj...

Re: Read only Rows for a Reeating Table in Infopath...

Hilary Stoupa — Wed, 08 Jul 2009 22:04:53 GMT

Hi, Raj!

That information helps a lot.

You can do this with conditional formatting, I think. You need to know who is opening the form -- I'm guessing you are handling that since you are setting the admin field at run time. I think what I would probably do is add another field, it can be in a secondary data source, and populate that with the name of the current user when the form loads. Then, on each control in the repeating section, you can set conditional formatting that is along the logic of 'If the current user's username (from the field populated on load) is not equal to the user listed in the field bound to the first text box in the repeating table, make this control read only'. Now, you'll probably need multiple conditions -- if the user is the admin, for example, you only want those first fields to be read only, so you'd need to add another condition for that.

As far as making hyperlinks read only -- your best bet would be to hide the hyperlinks that don't belong to the user. You can do that by putting the hyperlink control inside of a section and putting conditional formatting on the section. After all, there is no point in showing a hyperlink to a user that you don't want them to click.