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
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 cant really tell what your problem is from the information provided but it sound like quite a standard procedural/report issue.
If you dont 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.
I'm struggling to understand, do you have any very basic tutorials showing how to do this ?
When you reference the data-entry form you have to include it in the query.
For Enquiry2
with EnCallBack = data-entry EnterCallBack ;
list records
etc...
http://www.dataease.com/dg3_HelpView/?PageID=11981...
http://www.dataease.com/static/help/DQL/HelpFile.htm
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?
Re:Re:Re:Re:Re:Report / Procedure
Simples.
Derivation:
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().
http://www.dataease.com/dg3_HelpView/?PageID=10314&field1=*GetCurrent*
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
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.