NetTalk Central

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Johan van Zyl

Pages: [1] 2 3 ... 12
1
Web Server - Ask For Help / NTWS Form Multi-select example app?
« 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?

2
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]

3
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

4
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

5
Thx!
The Form can be sen here.
medxinfo.co.za|My Profile|Create My Own Profile

6
Web Server - Ask For Help / 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?

7
Hi

I have some Audit code that works well to write all inserted or updated info to the audit tables.
In case of Delete and I would also like to write the deleted record's details to a deletetable/archive.

In the case of Insert and Update the audit code goes into PostInsert and PostUpdate and it works as intended.
It does not work in PostDelete as the record has been deleted. Which would be the correct embed points to put the code for Audit and delete table?

NOTE:In all the Pre embeds I have "p_web.FileToSessionQueue(tpeople,false,'HIS')"

UPDATE: Ok In PostDelete the code writes to the Audit Files - it gets old values from "p_web.FileToSessionQueue(tpeople,false,'HIS')" and then writes a record for each field. For archive I would want the whole record to be written out in one go.

8
Web Server - Ask For Help / NetTalk Webinar 20180426
« on: April 26, 2018, 06:16:46 AM »
NetTalk Webinar 20180426

Clicking a button on a NetWebForm or in Emded code after Saving a Form
calling a
NetWebSource
What can and can you not do with NetWebSource
Can you just use it with some XMTML included and nothing else
or
NetWebForm
What can and can you not do with NetWebForm (except for the normal being called from a browse to Insert/Edit)
Can you just use it with some XMTML included and nothing else

Would it be possible to have web pages created by NTWS to have "rotating" content, maybe not just graphics but text as well.
You know, selling adverting space, etc
With datefrom and dateto when it must be displayed?

What is the max number of characters per XHMLT routine/procedure inside NetWebForm or NetWebSource?
Is it beter to put HTML code in a NetWebForm or NetWebSource or HTML file?

When would one use routine or procedure for XHMLT?

9
Web Server - Ask For Help / NTWS Rotating Banners and other animals
« on: April 26, 2018, 04:38:29 AM »
Would it be possible to have web pages created by NTWS to have "rotating" content, maybe not just graphics but text as well.
You know, selling adverting space, etc
With datefrom and dateto when it must be displayed?

10
Great! Thx!
Should I not get an email invitation to join the webinar?
And I have to register?

11
None of these embed points work for me.


Where can I put code that will execute when I click SendPassword button on a form.
To send and email and/or sms.
I would prefer to send sms/email from the SendPassword button and not from the Save button, if at all possible.
Then the person must enter the sent password in loc:password and be compared to the already generated tpe:password (ts.random(4)), if it is a match he can carry on, entering the rest of the fields on form and then Save?

OR - the person enters everything and clicks Save - his Username and Password is then sent to him via SMS/email.

How do I prevent a person from sitting down and registering countless phantom profiles?

Have just tried doing it from Save Button, but my embed code in validate updated is not executed? DAMN!

12
Would like to click on the Register button on NetWebForm to call a NetWebSource and at the same time pass contents of some of the already entered fields as p;arameters,

Looks like I cannot do this
'peopleguid='&tpe:guid,'peoplecellno='&tpe:cellno,'peopleemail='&tpe:email,'peoplepassword='&tpe:password
Only one parameter at a time then?

Or which embed point can I use for Register button to try and achieve this.
I would like to send SMS/email to the person busy registering use his already entered email and cellno.
Or can by clicking Register button the form can be saved and only pass the peopleguid to Source? Then with code there I get Fetch the fields from DB?

13
Web Server - Ask For Help / NTWS NetWebSource error
« on: April 24, 2018, 08:20:41 AM »
Calling this NetWebSource from button on Update - and get this error.

14
Can Insert Update in tPeople now.
1. When I update tpeople record the changes do not show when returning to browse - only when clicking Next and Previous.
2. Also locator still only works on one character only.

15
IN SQL it is char 16, in DCT string 16, so it seems that clipping should be superfluous?
And the fields are full - filled with st.makeGuid()

Pages: [1] 2 3 ... 12