General

Re: Edit multiple list items with one form

Hilary Stoupa — Wed, 30 Aug 2017 19:56:00 GMT

Hooray! Glad that worked for you.

Re: Edit multiple list items with one form

anh.vnn810 — Wed, 30 Aug 2017 02:10:23 GMT

Thank you so much for this. It works like a charm.

Re: Edit multiple list items with one form

Hilary Stoupa — Tue, 29 Aug 2017 22:39:11 GMT

I would add an XML file to the form's resources, with some helper fields for setting the statuses and then create a data connection to it. Then, on the Status field in your repeating group, add a rule to set the helper field, so that you can put a rule on it. That rule will then set the status fields. Easier to show than describe, so I've attached a simple sample. Save the form locally, right click, select design & preview. You'll see when you preview that I added a lot of nodes by default - that's to make sure my logic doesn't generate a looping error.

Re: Edit multiple list items with one form

anh.vnn810 — Tue, 29 Aug 2017 09:37:46 GMT

Hi Hilary,
Thanks for your reply. I have been able to fix my issue :)
I still have one more problem left that is how can I edit the repeated section in all items in just one action?
For example,
I have a field called "Status". This field is only displayed once if there are multiple items with the same Title.
When I change the Status, only the first item in all these multiple item is affected.
I would like to all these multiple items get the change too.
How can I achieve this?
I have attached the picture to describe the situation.
Thank you for your time and support.

Re: Edit multiple list items with one form

Hilary Stoupa — Mon, 21 Aug 2017 15:34:15 GMT

You have the display view set correctly in the form options? I don't understand this: "I don't know how to distinguish between Edit Mode and Display Mode so that I can use the form load rule to switch view (they seem to be the same)? " - want to attach your template?

Re: Edit multiple list items with one form

anh.vnn810 — Tue, 15 Aug 2017 09:39:27 GMT

Hi Hilary
Thank you for your great solution!
There is one thing I have trouble with is that how can I detect whether currently I'm in Edit Mode or in Display Mode so that I can display the view accordingly.
Currently, I have 2 departments, 2 views (edit and display) for each department.
I set the form load rules as follow:
1. If Title is not blank and it is from department 1, query for data.
2. If Title is not blank and it is from department 2, query for data and switch to department 2 display view.
This works perfectly in the display view, however, if I edit an item, I cannot get into the Edit View of that department, it just loads the Display View to edit.

I don't know how to distinguish between Edit Mode and Display Mode so that I can use the form load rule to switch view (they seem to be the same)?
I wonder if you can help me to find the solution for this problem!
Thank you for your help.

Re: Edit multiple list items with one form

_asp_ — Tue, 01 Aug 2017 16:01:50 GMT

Silly me! :D

You are right!

Thanks again for all you help, you were very kind and helpful :)

Re: Edit multiple list items with one form

Hilary Stoupa — Tue, 01 Aug 2017 15:52:43 GMT

I just didn't add those columns when I created my secondary data source. :)

Re: Edit multiple list items with one form

_asp_ — Tue, 01 Aug 2017 15:33:49 GMT

Please see the attached image.

Re: Edit multiple list items with one form

Hilary Stoupa — Tue, 01 Aug 2017 14:52:55 GMT

And I just tried in my test form, adding the created date to my secondary data connection, drug the field onto the form and IP used a date time control - can you maybe attach a screenshot of what is happening when you try this?

Re: Edit multiple list items with one form

Hilary Stoupa — Tue, 01 Aug 2017 14:47:40 GMT

I'm not sure what you mean.... why not just use calculated values, formatted as date time?

Re: Edit multiple list items with one form

_asp_ — Tue, 01 Aug 2017 09:47:40 GMT

Thanks a lot Hilary, I think I found my mistake.

I have to put the fields from the secondary connection in the display view (I was using fields from the main connection).

The problem is I cannot put "data and time" fields using the secondary connection and I have many of them :(

Re: Edit multiple list items with one form

Hilary Stoupa — Mon, 31 Jul 2017 23:44:15 GMT

Here's my form - take a look at the read view. I've got a form load rule to query the 2ds.

Re: Edit multiple list items with one form

_asp_ — Mon, 31 Jul 2017 16:21:35 GMT

Thanks! I'll wait for your sample file. I'm not able to make it works if I try to query from the secondary connection... I'm doing something wrong for sure

Re: Edit multiple list items with one form

Hilary Stoupa — Mon, 31 Jul 2017 16:10:54 GMT

Right - this query will always run. It doesn't matter that it always runs. It is a SECONDARY connection. You add another connection to the same list - this works around the issue of the main data source being cleared when you add a query to it on load.... I can update my sample form for this later today & attach a copy so you see what I mean (even tho you can't preview it). :)