How to setup a Global date search field

[soma55]

Hi,

 

 I want to develop a events calendar to display Uni courses on a iPad showing the display of the courses based on current date and time. I got the events table but I am stuck here. I need help to setup the automated display of the events. Can someone guide me with scripting and global fields to achieve this.

 

Thank you for your help

 

Kind regards,

Soma55

[eos]

That's a quite general question … if you want to perform a search on global fields, you could use this common form:

Enter Find Mode [ no pause ]
Go to Layout [ Event ( Event ) ]
Set Field [ Field: Event::dateField ; Calculated value: SomeTable::globalDateBegin & ".." & SomeTable::globalDateEnd ]
Set Error Capture [ on ]
Perform Find []

which lacks basic error trapping, e.g. are both global dates filled in and is end >= begin? If not, you would want to abort the script and prompt the user to enter correct parameters.

How exactly you would script this depends on your intended workflow.