Topic: message for birthday

Hi
Is there an script to show a Birthday Message in a specific date?
I recorded information for 100 employees of a company as well as their spouses and children.
is it possible that a message pops up on his/her  birthday, showing that person's name and when I click on his/her name, it refers me to that persons page.
thank you

Re: message for birthday

Hello, I saw a topic on the forum that did not get an answer.
This subject concerns birthday dates and may be interesting to apply it to other subjects, in particular to stocks or other archives.
Has an answer been posted?
-------------------------------------------------- ----------
Here is the message in question:
'message for birthday'

Hi
Is there a script to show a Birthday Message in a specific date?
I recorded information for 100 employees of a company as well as their spouses and children.
is it possible that a message pops up on his/her birthday, showing that person's name and when I click on his/her name, it refers me to that persons page.
thank you

Destiny

Re: message for birthday

Hello,

Here's an idea. Hope it can be a start to what you want to do with it.

Post's attachments

Attachment icon CheckBday.zip 549.47 kb, 84 downloads since 2022-11-27 

brian

Re: message for birthday

Thanks Brian, this example can be adapted for several programs.

Destiny

5 (edited by sparrow 2022-11-28 14:41:38)

Re: message for birthday

Hi all,


Slight modification of Brian's solution. By the way, I didn’t find solutions on the forum with launching with parameters, maybe I don’t see it well.
You can try, provided that there are not very many forms in the program. The more forms, the longer the launch.
If run at computer startup with the "bday.exe /min" parameters, it will display only information about the birthday, if not, then nothing. Message timeout 3 sec.
In normal startup mode, fully working.

Post's attachments

Attachment icon CheckBday mod1.zip 336.31 kb, 35 downloads since 2022-11-28 

Re: message for birthday

Hi Destiny, Brian, Sparrow,
Hope you're all well.
There are lots of ways to achieve this sort of thing - here's a very simplified option (based on Brian and Sparrow's examples) that doesn't require a script.
Regards,
Derek.

Post's attachments

Attachment icon CheckBday mod2.zip 336.79 kb, 68 downloads since 2022-11-28 

Re: message for birthday

Thanks to Brian, Sparrow and Derek for the examples they provided. That's great.
Thanks

Destiny

Re: message for birthday

Hi guys
thanks a lot for different approaches.
is it possible that an alert in shown a day or a week before someones birthday?
for example when you click on a bottom, an alert says that tomorrow is Tom's Birthday?
or a bottom show an alert that during the next month there will be 4 birthdays?
thanks

Re: message for birthday

There are lots of different ways you can do something like this - at it's simplest, you could just sort a 'next birthday due' column.
Attached is an option that colour codes the table grid depending on whether a birthday is due in the next 5 days (highlighted in red) or in the next 14 days (highlighted in yellow).
Derek.

Post's attachments

Attachment icon birthdaybash.zip 371.93 kb, 36 downloads since 2023-01-07 

Re: message for birthday

Hi everyone
Thank you all for your help
I created a project with many workers and their relatives.
and I have attached the sample project.
is it possible that when you click on the bottom "btShowBday" in the form "frmMain" all the workers and their relatives are shown on the form "frmBDayList" and an alert in shown for the birthday?
because in my sample When I click on that bottom only the worker is shown and his wife and children are not shown on the tablegrid.
please don not change the tables and forms

Post's attachments

Attachment icon CheckBday mod3.zip 336.97 kb, 33 downloads since 2023-01-08 

Re: message for birthday

Form frmBDayList - btSearch (SQL query)

SELECT name,                        
strftime('%m/%d/%Y',birthdate) as Birthdate,                                        
date('now') - birthdate + (case when strftime('%m-%d', 'now') < strftime('%m-%d', birthdate) then -1 else 0 end) as AGE 
FROM emp
WHERE strftime('%d-%m', birthdate) = strftime('%d-%m', 'now', 'localtime') 
UNION
SELECT fistname || '  ' || lastname,                        
strftime('%m/%d/%Y',birthdate) as Birthdate,                                        
date('now') - birthdate + (case when strftime('%m-%d', 'now') < strftime('%m-%d', birthdate) then -1 else 0 end) as AGE 
FROM wife
WHERE strftime('%d-%m', birthdate) = strftime('%d-%m', 'now', 'localtime') 
UNION
SELECT name || '  ' || lastn,                        
strftime('%m/%d/%Y',birthday) as Birthdate,                                        
date('now') - birthday + (case when strftime('%m-%d', 'now') < strftime('%m-%d', birthday) then -1 else 0 end) as AGE 
FROM children
WHERE strftime('%d-%m', birthday) = strftime('%d-%m', 'now', 'localtime') 
ORDER BY AGE DESC   

Re: message for birthday

Thank you sparrow for your help.
When I used this script in the sample project that I have attached, it works fine but when I insert it in my own project it shows the attached error message.
what am I doing wrong?

Post's attachments

Attachment icon Untitled.jpg 29.04 kb, 5 downloads since 2023-01-08 

Re: message for birthday

Check the ORDER BY line

Re: message for birthday

thanks a lot
I found the problem and solved it with your help.
It works great