Simplicty and flexibility!

Report / Procedure

Started by Darren Ludlam
You will need to Sign In to be able to add or comment on the forum!

Report / Procedure

Hi, I've been unable to find any examples or tutorials showing what I'd like to do. I'd like to add a callback date record to our customer data base then create a report or procedure that will list all the callbacks for today's date. Stay safe Darren

Written by Darren Ludlam 06/01/21 at 10:48:48 Dataease [{8}]FIVE

Re:Report / Procedure

Hi Darren.

Happy New Year and thank you for taking the time to write to us.

I have put your request on the forum and feel free to add information to your requirement there.

I can’t really tell what your problem is from the information provided but it sound like quite a standard procedural/report issue.

If you don’t have a callback record attached to your customer database simply create a callback form, add it to your customer form with a subform and you can add the information in the subform or jump into the full form with open related and complete the record there.

When you want to list out the callback list for any give date, you can do that either via a report or if this is something you are going to use interactively, you can create a call back view form, where you select the data in a field (current date can be the derivation in that field if you automatically want to view today, and then create a relationship between this view form and your callback form on the date field. It will then list all the callbacks for this date in the subform and you can call etc. You can even add an automatic call button to dial the number from the subform.

Written by DataEase 06/01/21 at 11:15:35 Dataease [{8}]FIVE

Re:Re:Report / Procedure

I'm struggling to understand, do you have any very basic tutorials showing how to do this ?

Written by Darren Ludlam 06/01/21 at 11:59:31 Dataease [{8}]FIVE

Re:Re:Report / Procedure

Written by Darren Ludlam 06/01/21 at 12:10:08 Dataease [{8}]FIVE

Re:Re:Re:Report / Procedure

When you reference the data-entry form you have to include it in the query.

For Enquiry2 
with EnCallBack = data-entry EnterCallBack ;
list records

Written by DataEase 06/01/21 at 15:35:02 Dataease [{8}]FIVE

Re:Re:Re:Re:Report / Procedure

Thanks for your help and links to the relevant support pages, I think I'm getting somewhere now. One more thing, is it possible to pre-populate a date form field with the current date?

Written by Darren Ludlam 06/01/21 at 20:18:08 Dataease [{8}]FIVE

Re:Re:Re:Re:Re:Report / Procedure



current date

You have a lot of things you can pick out like date, time etc.

The old way is simply current and property ex. current date and current time etc.

From DE8 onwards we have added dramatically to it via GetCurrent() and you can even set many of them with SetCurrent().*GetCurrent*

Written by DataEase 07/01/21 at 12:17:50 Dataease [{8}]FIVE

Re:Re:Re:Re:Re:Re:Report / Procedure

Are there any examples of it used in a form to populate a date field? Does 'current date' go in the object field of the form

PS I do try searching before I ask

Written by Darren Ludlam 07/01/21 at 14:44:41 Dataease [{8}]FIVE

Re:Re:Re:Re:Re:Re:Re:Report / Procedure

There is a couple of places you can use code in DataEase (Depending on what version you are using). 

You have DQL, You have BRL(Derivations), You have Actions (Buttons etc) and you have OML.

BRL is on every field object and will give the calculation/result in that field if it is write protected, virtual or if it is not entered manually.

if you have a date field and use the derivation:

Current date

it will fill the date when lost focus if you don't manually fill it with a date.

If you write protected or make it virtual it will fill it immediately.

current is a command/statistical variable in dataease and can be used everywhere you can code.

Written by DataEase 07/01/21 at 15:13:28 Dataease [{8}]FIVE