Custom widget with next alarm & calendar event

[nicsergio]

Hi Martin

I'm creating a custom widget with clock and other additional information, is there a way to get the next alarm time and next calendar event info?
Thanks

[Martin]

Hi,

Next alarm can be queried using action Init Variable System Setting and next_alarm_formatted.
Next calendar info can be queried with action Query Content Provider, however this action is quite difficult to use. There's an example to query the current calendar events. You could increase the time range in the content uri ...instances/when/{triggertime}/{addDays(triggertime,3)} to read the events of the next three days and limit the selection to begin>{triggertime} to ignore events that already started and sort order to end (untested).

Regards,
Martin

[nicsergio]

great!
I tried and both actions are working properly, with Automagic you can really do all!!

[AMChris]

@nicsergio: thanks for asking this question
@Martin: thanks for answering it

I want to add my solution for 'get next event' which maybe of use for others...

[AMChris]

the trigger is a calender event
(if an event starts - what is the next event?)

[AMChris]

now we query the calender

[AMChris]

second part of the 'query'
(I aks for a whole table because I want to get more information than only the title)

[AMChris]

now I use a script to extract the content

Code: Select all

/*
SELECT title,begin,calendar_displayName,end,eventLocation 
FROM content://com.android.calendar/instances/when/{triggertime}/{addDays(triggertime,3)} 
WHERE begin>{triggertime} ORDER BY begin
*/
global_next_event_title=getElement(getElement(event_table, 0),0);
global_next_event_begin=getElement(getElement(event_table, 0),1);
global_next_event_calendarName=getElement(getElement(event_table, 0),2);
global_next_event_end=getElement(getElement(event_table, 0),3);
global_next_event_location=getElement(getElement(event_table, 0),4);
global_next_event_day="";
if ("{global_next_event_begin,dateformat,yyyyMMdd}"!="{getDate(),dateformat,yyyyMMdd}") {
   global_next_event_day=left("{global_next_event_begin,dateformat,E}",2);
}

[angelatwork]

Hi AMchris, why don't you share your flow with us?

Would appreciate it

Best regards AngelAtwOrk