NetTalk Central

Author Topic: NTWS UpdateForm with many potential selections  (Read 4364 times)

Johan van Zyl

  • Full Member
  • ***
  • Posts: 180
  • jvz
    • View Profile
    • Email
NTWS UpdateForm with many potential selections
« on: September 24, 2018, 11:30:08 AM »
NTWS 10.33 Clarion 10

I need help with my Locum app/db. medxinfo.co.za
When a locum is registered they fill in the normal stuff like name, cellno, email address etc.
Then I will require PreferredAreas, RegisteredWithPharmacyGroups and DispensingApplications, etc. With each there could be one or many selected.
What will be best way to achieve this in WebUpdateForm?  Because each of those could have multiple choices that could result in a very long UpdateForm.
I would think that each choice would a Boolean checkbox?
Johan van Zyl
Clarion 6.3 9058/C8 Gold/SQL/NetTalk WebServer

bshields

  • Sr. Member
  • ****
  • Posts: 392
    • View Profile
    • Inhabit
    • Email
Re: NTWS UpdateForm with many potential selections
« Reply #1 on: September 24, 2018, 09:12:11 PM »
Hi Johan,

Not knowing anything about your application, i'm really just guessing, but i'll have a go.

If each of the PreferredAreas, RegisteresWithPhamacyGroups and DispensingApplications are all known (ie, they can choose one or mnay options from an existing list - even its its a very long list). You could hide/show a Browse that acts as a multi select screen.

Maybe you can give some feedback and we could go from there.

Regards
Bill




Johan van Zyl

  • Full Member
  • ***
  • Posts: 180
  • jvz
    • View Profile
    • Email
Re: NTWS UpdateForm with many potential selections
« Reply #2 on: September 24, 2018, 09:36:52 PM »
Thx!
The Form can be sen here.
medxinfo.co.za|My Profile|Create My Own Profile
Johan van Zyl
Clarion 6.3 9058/C8 Gold/SQL/NetTalk WebServer

bshields

  • Sr. Member
  • ****
  • Posts: 392
    • View Profile
    • Inhabit
    • Email
Re: NTWS UpdateForm with many potential selections
« Reply #3 on: September 25, 2018, 02:11:59 AM »
Hi Johan,

What do the "Preferred Areas" look like: is it a list of suburbs or postal codes, or some other geographic construct like states or localities?

Is there 5 of them or 500 or 5000?

Is a Locum, likely to select 1 or 2 or 10 of these?

All these aspects matter when considering the UX.

Regards
Bill

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11158
    • View Profile
Re: NTWS UpdateForm with many potential selections
« Reply #4 on: September 25, 2018, 03:19:23 AM »
>> Then I will require PreferredAreas, RegisteredWithPharmacyGroups and DispensingApplications, etc. With each there could be one or many selected.

Sounds like these are child browses of the parent form?

cheers
Bruce

Johan van Zyl

  • Full Member
  • ***
  • Posts: 180
  • jvz
    • View Profile
    • Email
Re: NTWS UpdateForm with many potential selections
« Reply #5 on: September 25, 2018, 09:15:35 AM »
Preferred Areas can be Cities/Towns , smaller towns grouped together like Somerset West/Stellenbosch/Paarl, East Rand, West Rand  and/or Provinces specially the smaller and/or sparsely populated ones.
Areas should not be more than a few dozen.

Example:
Johannesburg, Pretoria, Cape Town, Durban, Somerset West/Stellenbosch/Paarl, East Rand, West Rand, Northern Cape, Limpopo.
A locum may choose one or more "areas". Looks like must be via a Browse, by clicking on one or more, the choices will then be written to a text field on form, maybe sorted alphabetically inside this text field.


Hi Johan,

What do the "Preferred Areas" look like: is it a list of suburbs or postal codes, or some other geographic construct like states or localities?

Is there 5 of them or 500 or 5000?

Is a Locum, likely to select 1 or 2 or 10 of these?

All these aspects matter when considering the UX.

Regards
Bill
« Last Edit: September 25, 2018, 09:21:07 AM by Johan van Zyl »
Johan van Zyl
Clarion 6.3 9058/C8 Gold/SQL/NetTalk WebServer

bshields

  • Sr. Member
  • ****
  • Posts: 392
    • View Profile
    • Inhabit
    • Email
Re: NTWS UpdateForm with many potential selections
« Reply #6 on: September 25, 2018, 04:52:33 PM »
Hi Johan,

When I have a smaller list of options where they can select more than one, I use a browse of all possible choices and let the user tick the options that apply.

I've added a screen shot (this example is outside of a form, but also works inside a form).

You could also use a multi-select list box, but I find them less flexible in case there are too many entries.

Regards
Bill
« Last Edit: September 25, 2018, 05:02:31 PM by bshields »

Johan van Zyl

  • Full Member
  • ***
  • Posts: 180
  • jvz
    • View Profile
    • Email
Re: NTWS UpdateForm with many potential selections
« Reply #7 on: September 25, 2018, 09:52:25 PM »
Thx!
Which theme are you using there?

Hi Johan,

When I have a smaller list of options where they can select more than one, I use a browse of all possible choices and let the user tick the options that apply.

I've added a screen shot (this example is outside of a form, but also works inside a form).

You could also use a multi-select list box, but I find them less flexible in case there are too many entries.

Regards
Bill
Johan van Zyl
Clarion 6.3 9058/C8 Gold/SQL/NetTalk WebServer

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11158
    • View Profile
Re: NTWS UpdateForm with many potential selections
« Reply #8 on: September 25, 2018, 09:58:50 PM »
Hi Johan,

>> the choices will then be written to a text field on form, maybe sorted alphabetically inside this text field.

why a text field? That sounds like a really bad way to store it.
It sounds to me like you have a Locum table, an area table, (and a multi-to-multi relationship between the two).

M-2-M means you should have a LocumArea table which links a locum to an area.That way you can easily list all locums for one area, or show what areas a locum belongs to.

Basically I think you are struggling because you have not designed your database correctly yet.

Cheers
Bruce

Johan van Zyl

  • Full Member
  • ***
  • Posts: 180
  • jvz
    • View Profile
    • Email
Re: NTWS UpdateForm with many potential selections
« Reply #9 on: September 25, 2018, 10:27:06 PM »
when you browse the locum table (and column search) you can see everything at a glance. Without having to click anything, unless you want to edit.

Name and all other personal info
Dispensing apps used
Areas willing to work in
Registered with which pharmacy groups
etc


They must all be selected from lookups to assure correct spelling as opposed to typing info in free hand with the inevitable spelling mistakes.


Basically I think you are struggling because you have not designed your database correctly yet.

Cheers
Bruce
[/quote]
« Last Edit: September 25, 2018, 11:04:48 PM by Johan van Zyl »
Johan van Zyl
Clarion 6.3 9058/C8 Gold/SQL/NetTalk WebServer

bshields

  • Sr. Member
  • ****
  • Posts: 392
    • View Profile
    • Inhabit
    • Email
Re: NTWS UpdateForm with many potential selections
« Reply #10 on: September 26, 2018, 01:48:06 AM »
Hi Johan,

I'm with Bruce on this.

It might be tempting to keep your database design "simple" to make working with it easier.

But, this will bite you in the end.

Its best to design your database based on how the data exists and interacts in the real world.

Sometimes I use triggers to store data in a redundant fashion to make programming easy or for speed requirements (but rarely).

The screen example I showed was implementing a M<->M relationship.

The theme is based on bootstrap but wrapped in an Admin style template.

Regards
Bill


Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11158
    • View Profile
Re: NTWS UpdateForm with many potential selections
« Reply #11 on: September 30, 2018, 10:02:31 PM »
>> when you browse the locum table (and column search) you can see everything at a glance. Without having to click anything, unless you want to edit.

I'm not sure how doing the correct database design would prevent the above?

cheers
Bruce