Multiple selection from database table (Form)

Issues related to label design (working with databases, data processing, RFID encoding etc.) and printing (from NiceLabel Express, NiceLabel Pro, NiceForm and NicePrint)

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
ricardo
Enthusiast
Posts: 11
Joined: Mon Nov 14, 2011 8:14 pm
Location: Porto, Portugal
Contact:

Multiple selection from database table (Form)

Post by ricardo » Fri Jun 05, 2020 2:13 pm

Hi.
I'm trying to get the result of a multiple selection in a database table but I only get the currently selected.
Is there any way to get all the check box selected rows.

Check image please. I only get the blue one not both checked.


I tried with a field variable and also tried to use "row number" variable but only returns me the currently selected row too (Although I prefer to get a specific field instead of row number).

Nicelabel 2017 & 2019
Attachments
form.png
form.png (5.66 KiB) Viewed 272 times

User avatar
Kyleodonnell
NiceLabel Support
NiceLabel Support
Posts: 568
Joined: Mon Aug 28, 2017 3:07 pm

Re: Multiple selection from database table (Form)

Post by Kyleodonnell » Mon Jun 08, 2020 4:50 pm

Ricardo,

if you need to print selected records you need to use the action "For every record" on your print button. This will loop through the actions and print selected records. your actions should look like this
foreveryrecord.PNG
foreveryrecord.PNG (12.75 KiB) Viewed 253 times

ricardo
Enthusiast
Posts: 11
Joined: Mon Nov 14, 2011 8:14 pm
Location: Porto, Portugal
Contact:

Re: Multiple selection from database table (Form)

Post by ricardo » Mon Jun 08, 2020 7:20 pm

Thank you Kyle.
The purpose is to do a change on the selected records on database.

With that function works - I think it's enough for what I need. Thank you.


Anyway, does exists any way to uncheck the boxes after this action? (I achived this reopeining the form that I would like to avoid).

User avatar
Saso
NiceLabel
NiceLabel
Posts: 2984
Joined: Mon Sep 04, 2006 8:09 am
Contact:

Re: Multiple selection from database table (Form)

Post by Saso » Fri Jun 12, 2020 2:58 pm

To uncheck the boxes in Table object, use Select Table Row action in Deselect all rows mode.
screenshot.png
screenshot.png (24.69 KiB) Viewed 212 times
Saso Fleiser
Senior Technical Product Specialist

Post Reply