NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Johan van Zyl on January 01, 2019, 12:57:49 PM

Title: NTWS Form Multi-select example app?
Post by: Johan van Zyl on January 01, 2019, 12:57:49 PM

I my locum database I would like a DROP using a table called preferredareas and it must be multi-select. An dput the selections into a column called clientpreferredareas.
Areas like Pretoria/EastRand/Johannesburg/VaalTriangle etc. I cannot get it to work - in the drop it shows me the contents of the table - but I cannot select say one or two or many/any?
Coming to think of it - maybe a drop is not the answer - the table will have too many items and it will take over my update form.
Any other suggestions?

Title: Re: NTWS Form Multi-select example app?
Post by: Jane on January 01, 2019, 02:51:00 PM

Multi-select like that is a lot like the invoice/line-items data paradigm.  One guy might have one preferredarea and another might have six.

There are NT examples of invoices with line items, or customers with multiple invoices.

Having your preferredareas in a separate table will also make searching and grouping a lot easier.

Title: Re: NTWS Form Multi-select example app?
Post by: Bruce on January 01, 2019, 10:41:07 PM

Hi Johan,

Think of this more as a "tagging" exercise. There are a list of areas, and the user can "tag" the ones they want to service.
Check out the "Tagging" example for that - perhaps that's a better visual approach than a multi-select-drop.

cheers
Bruce