Simplicty and flexibility!


In your CRM app, a number of fields prompt the user to insert some text i.e enter Subject. As I would like to prompt the user in asimilar way in an input form, how can I achieve the same result! Many thanks


Started by Luigi Faso
Search
You will need to Sign In to be able to add or comment on the forum!

In your CRM app, a number of fields prompt the user to insert some text i.e enter Subject. As I would like to prompt the user in asimilar way in an input form, how can I achieve the same result! Many thanks

Written by Luigi Faso 20/04/17 at 12:24:26 Dataease [{8}]FIVE

Re:In your CRM app, a number of fields prompt the user to insert some text i.e enter Subject. As I would like to prompt the user in asimilar way in an input form, how can I achieve the same result! Many thanks

In DE85 you have virtual editable fields which means you can have fields as "data-entry field" anywhere - even in reports and on the form object directly that is not saved.

You can use these fields in a number of way. You can store the value in a global variable with SetVar() or you can reference it directly.

if you want to use it for data-entry in a traditonal DQL or report you use SetVar()/GetVar() and if you want to use ExecDQL you can use it directly as one of 4 direct data-entry varaibles.

ExecDQL("MyDQL text",Data-entry1,DataEntry2,data-entry3,dataentry4)

A simple ExecDQL to test is this:

execdql("message concat(/'My Message is: /', data-entry field1) window .",MyVirtualField)

Here you also ssee how we use escape characters to allow you to have " " inside a string.
/' will automatically be translated to ".

Try to create a virtual editable field in a form and put this script on a button like this.


The best way to figure out how we do things is simply to look at the code in the sample and "steal" what you like ;-)


Written by DataEase 20/04/17 at 15:31:34 Dataease [{8}]FIVE
DG3_ForumList