Topic: email alert

Hello,

i have a script in my project to change a table grid cell color when a date in neer, for example,  15 days before a date of a event the color of the cell will turn red.

is there a way to specify an email and send an email with a message alert 15 days before the date?

Re: email alert

Hello,


In the current version sending e-mails is not support, but soon will be.

Dmitry.

Re: email alert

so to display alerts, beside change the cell color, and display a message box for example, what other options do you recommend for example?

Re: email alert

Montenegr0

In this case, you need add a new field in DB, where you store a flag, that your alert already displayed.
For showing alert, you can use function

ShowMessage('Your message');
Dmitry.

Re: email alert

thanks,

i want to try another thing,

i have a script to change the cell color of a tablegrid 15 days before a date arrive.

how can i make a report to print only this dates? because there are many cells with a date longer than 15 days.

or other option, is there a way to print all the dates that belong to current month?

Re: email alert

Montenegr0 wrote:

is there a way to print all the dates that belong to current month?

You can use DateTimePicker for select current month for report.
Set property: Kind=MonthYear



for the correct operation of this feature, please download latest beta version
https://www.dropbox.com/s/vz1fmz5lrb6fw … 1.zip?dl=0

Dmitry.

Re: email alert

you can have a complete script for the message?

Domebil

Re: email alert

and how can i only show the items with 15 days to a certain date?


for example if i have a item with a date 01/10/2015 and the other with 25/04/2015. i want to have only in the report the item with the date 25/04/2015, because there are less than 15 days to this date.

Re: email alert

Montenegr0
You can place two components DateTimePicker for create report using date range.

DateTimePicker1
Filter =  >=

DateTimePicker2
Filter =  <=



Then just select  two dates using DateTimePicker for date range

Dmitry.

Re: email alert

domebil
Unfortunately I do not have a ready example.
You can attach your project with description, what exactly do you need. (zip file without exe and dll)


Thanks.

Dmitry.

Re: email alert

where do i put those filters?

Re: email alert

Montenegr0 wrote:

where do i put those filters?

http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&amp;item=860&amp;download=0

Post's attachments

Attachment icon filter.png 20.43 kb, 312 downloads since 2015-04-20 

Dmitry.

Re: email alert

is not what i really looking for.

i already sent to you my project with description wink is better that way.