In ascending order question

#1 · September 13, 2022, 5:22 pm

I have a list of customers [cust_1] to [cust_20]
Each customer earns points per transaction [points_1] - [points_2] etc

eg: Customer ONE is [Cust_1] and their points are [Points_1]

Is there a way to make a list of all customers and their points in ascending order?
In other words, is there a way to display the customers name with the highest points and then other customers (with the their points) in ascending order....list a list?

Thanks

#2 · September 13, 2022, 5:43 pm

@mbpitt are you asking for VisualNEO Web or VisualNEO Win?

Regards

#3 · September 13, 2022, 5:48 pm

Sorry, VisualNEO Win

#4 · September 13, 2022, 5:53 pm

Example attached
EXAMPLE1 is a list of names and points in random order.
EXAMPLE2 is the result that i am looking for
:)

Uploaded files:

You need to login to have access to uploads.

#5 · September 13, 2022, 6:16 pm

@mbpitt

You can sort the table by any field with command dbfSort - see plugin NeoDB (SinLios).

luishp and proforma.guyot have reacted to this post.

#6 · September 13, 2022, 6:26 pm

Thanks.
That kind of scripting is beyond my understanding...would not know where to start, hence question

#7 · September 13, 2022, 6:59 pm

@mbpitt

Look at the demonstration file (in the archive).

Plugin: https://visualneo.com/product/neodb

Help on how to install the plugin: https://winhelp.visualneo.com/InstallPlug-Ins.html

Uploaded files:

You need to login to have access to uploads.

luishp and proforma.guyot have reacted to this post.

#8 · September 13, 2022, 7:27 pm

Hi, I already have DB installed on the pc.

How do i make the text bigger in the DBase ?

#9 · September 13, 2022, 7:53 pm

@mbpitt

See the help for the plugin commands
dbfSetCellStyle
dbfSetTitleStyle
dbfSetHighlightColor

luishp and proforma.guyot have reacted to this post.

#10 · September 13, 2022, 8:05 pm

Thanks again,

Is it possible to substitute names in the DB for names produced prior?

example.... if I input a company name (using the text entry script) ex [Company_1].
Is there a way to use the [company_1] script in the db instead of having to type it in manually?

#11 · September 13, 2022, 8:30 pm

@mbpitt

Yes, of course.

For example, add this to a separate new button in the previous demo:

dbfVarToRecord "[PubDir]base.dbf" "name1,xxx"
dbfRefresh "[PubDir]base.dbf"

Instead of "name1,xxx" you can have the names of the variables that hold the data you want (e.g., read from a file).

luishp and proforma.guyot have reacted to this post.

#12 · September 13, 2022, 9:21 pm

Thanks again...... cant work out how to create more than 8 names in the DB list ??

#13 · September 13, 2022, 9:55 pm

@mbpitt

In the program itself, the user just needs to press the Tab key.

And if you do the script, you need the appropriate commands.

Look in the plugin's help, with the keywords "add entry", for example:

dbfAddRecord

There is a lot of useful information in the help ;)

luishp and proforma.guyot have reacted to this post.

In ascending order question - Forum

In ascending order question