Hi,
I am working on an update page for commission values and rather than update each individually I want to update multiple records.

I have followed the tutorial video but when it comes to selecting the expression no matter what I do I do not see what is displayed in the video? All I see are the fields contained within in the selected form? I would prefer to use Server Connect than an old Database Source (whichever way I do it it does not match the video anyway). Is there an updated video for this as all I seem to be able to find is the following video from October 2015 which appears to be redundant (call me stupid if I am missing something):

www.dmxzone.com/go/23305/update-multiple-database-records

Any help much appreciated!!

Thanks in advance.

Hello Dave,
Following the video you should be able to do this. Can you explain what exactly does not match?

Good morning Teodor,
I added a Data Source (would prefer to use Server Connect but followed the video). Followed all steps up to 3m 23s in the video and this is what I see (no Data Array):



I have repeated it a dozen times and still do not see the Data Source Array?

Many thanks for your help once again.

Well the data source should indeed be added through the server connect.

I initially did it through Server Connect but had the same result. But to stick to the video tutorial I went back and used a Data Source as shown in the video. I will do it again with Server Connect (allow me 5 minutes).

Sorry but the same result is achieved? No Data Array is displayed.

I just tested this locally and everything works fine.
1. Create a database action, which contains a database connection and a query, which displays the products data on the page.
- Create an executor for it, which runs on dom ready
- Add a repeat region around your field(s) which will be repeated
- Bind the id to the input.name inside the repeat region
- Bind the value as input.data.value inside the repeat region
2. Create another database action, import the page with the form and sync form fields
- Create a database connection
- Create a repeater, the array is now visible under Globals - Post ....

Just beat me around the head with the manual Teodor!!

I had overlooked binding the input.name as I tend to name these manually (and like all developers/designers I thought I knew better than the manual).

I have since learned, once again, that I am not better hahaha..

Thanks once again for your patience and kind assistance. You are probably too polite to call me stupid so I shall do it. I AM STUPID.

Have a great day!

Hi Dave,
input.name binding is required, when doing a multiple update. You can name them manually, in any other case, except in multi update/delete
I'm happy to hear you had this fixed.

Thank Teodor.
I am really appreciating everything that goes in to Server Connect. It is a great extension. Now that I know the above I can't see me having any further issues. Being able to organise my Server Actions in to folders is also a fantastic feature. Everything is stored nicely and very easy to locate. Such a simple feature yet so helpful.

Thanks again!