Zulu - Todo Properties
| Line 3: | Line 3: | ||
==zulu_UUID== | ==zulu_UUID== | ||
| − | * | + | * Layout Object Name: UUID |
* Field Type: Text | * Field Type: Text | ||
| Line 11: | Line 11: | ||
==zulu_CREATION_TIMESTAMP== | ==zulu_CREATION_TIMESTAMP== | ||
| − | * | + | * Layout Object Name: CREATION_TIMESTAMP |
* Field Type: Timestamp | * Field Type: Timestamp | ||
| Line 19: | Line 19: | ||
==zulu_MODIFICATION_TIMESTAMP== | ==zulu_MODIFICATION_TIMESTAMP== | ||
| − | * | + | * Layout Object Name: MODIFICATION_TIMESTAMP |
* Field Type: Timestamp | * Field Type: Timestamp | ||
| Line 25: | Line 25: | ||
==Summary== | ==Summary== | ||
| − | * | + | * Layout Object Name: SUMMARY |
* Field Type: Text | * Field Type: Text | ||
| Line 31: | Line 31: | ||
==Note== | ==Note== | ||
| − | * | + | * Layout Object Name: DESCRIPTION |
* Field Type: Text | * Field Type: Text | ||
| Line 37: | Line 37: | ||
==zulu_STATUS== | ==zulu_STATUS== | ||
| − | * | + | * Layout Object Name: STATUS |
* Field Type: Text | * Field Type: Text | ||
| Line 43: | Line 43: | ||
==zulu_COMPLETED== | ==zulu_COMPLETED== | ||
| − | * | + | * Layout Object Name: COMPLETED |
* Field Type: Timestamp | * Field Type: Timestamp | ||
| Line 49: | Line 49: | ||
==DateStart== | ==DateStart== | ||
| − | * | + | * Layout Object Name: START_DATE |
* Field Type: Date | * Field Type: Date | ||
| Line 55: | Line 55: | ||
==zulu_DUE== | ==zulu_DUE== | ||
| − | * | + | * Layout Object Name: DUE |
* Field Type: Timestamp | * Field Type: Timestamp | ||
| Line 61: | Line 61: | ||
==zulu_PRIORITY== | ==zulu_PRIORITY== | ||
| − | * | + | * Layout Object Name: PRIORITY |
* Field Type: Number | * Field Type: Number | ||
| Line 67: | Line 67: | ||
==zulu_ALARM_ACTION== | ==zulu_ALARM_ACTION== | ||
| − | * | + | * Layout Object Name: ALARM_ACTION |
* Field Type: Text | * Field Type: Text | ||
| Line 73: | Line 73: | ||
==zulu_ALARM_DESCRIPTION== | ==zulu_ALARM_DESCRIPTION== | ||
| − | * | + | * Layout Object Name: ALARM_DESCRIPTION |
* Field Type: Text | * Field Type: Text | ||
| Line 79: | Line 79: | ||
==zulu_ALARM_TRIGGER_TIMESTAMP== | ==zulu_ALARM_TRIGGER_TIMESTAMP== | ||
| − | * | + | * Layout Object Name: ALARM_TRIGGER_TIMESTAMP |
* Field Type: Timestamp | * Field Type: Timestamp | ||
| Line 85: | Line 85: | ||
==zulu_ALARM_PROXIMITY== | ==zulu_ALARM_PROXIMITY== | ||
| − | * | + | * Layout Object Name: ALARM_PROXIMITY |
* Field Type: Text | * Field Type: Text | ||
| Line 91: | Line 91: | ||
==zulu_ALARM_LOCATION_TITLE== | ==zulu_ALARM_LOCATION_TITLE== | ||
| − | * | + | * Layout Object Name: ALARM_LOCATION_TITLE |
* Field Type: Text | * Field Type: Text | ||
| Line 97: | Line 97: | ||
==zulu_ALARM_COMPLEX_TITLE== | ==zulu_ALARM_COMPLEX_TITLE== | ||
| − | * | + | * Layout Object Name: ALARM_COMPLEX_TITLE |
* Field Type: Text | * Field Type: Text | ||
| Line 103: | Line 103: | ||
==zulu_ALARM_RADIUS== | ==zulu_ALARM_RADIUS== | ||
| − | * | + | * Layout Object Name: ALARM_RADIUS |
* Field Type: Number | * Field Type: Number | ||
| Line 109: | Line 109: | ||
==zulu_ALARM_LATTITUDE== | ==zulu_ALARM_LATTITUDE== | ||
| − | * | + | * Layout Object Name: ALARM_LATTITUDE |
* Field Type: Number | * Field Type: Number | ||
| Line 115: | Line 115: | ||
==zulu_ALARM_LONGITUDE== | ==zulu_ALARM_LONGITUDE== | ||
| − | * | + | * Layout Object Name: ALARM_LONGITUDE |
* Field Type: Number | * Field Type: Number | ||
| Line 121: | Line 121: | ||
==zulu_ALARM_TIMESTAMP_UUID== | ==zulu_ALARM_TIMESTAMP_UUID== | ||
| − | * | + | * Layout Object Name: ALARM_TIMESTAMP_UUID |
* Field Type: Text | * Field Type: Text | ||
| Line 127: | Line 127: | ||
==zulu_ALARM_PROXIMITY_UUID== | ==zulu_ALARM_PROXIMITY_UUID== | ||
| − | * | + | * Layout Object Name: ALARM_PROXIMITY_UUID |
* Field Type: Text | * Field Type: Text | ||
| Line 133: | Line 133: | ||
==Event ID== | ==Event ID== | ||
| − | * | + | * Layout Object Name: PKEVENT |
* Field Type: Number | * Field Type: Number | ||
| Line 139: | Line 139: | ||
==zulu_ICAL_DATA== | ==zulu_ICAL_DATA== | ||
| − | * | + | * Layout Object Name: ICAL_DATA |
* Field Type: Text | * Field Type: Text | ||
| Line 145: | Line 145: | ||
==zulu_ACTIVITY== | ==zulu_ACTIVITY== | ||
| − | * | + | * Layout Object Name: ACTIVITY |
* Field Type: Text | * Field Type: Text | ||
| Line 154: | Line 154: | ||
==zulu_DELETED== | ==zulu_DELETED== | ||
| − | * | + | * Layout Object Name: DELETED |
* Field Type: Number | * Field Type: Number | ||
A number field Zulu uses to tag an item to be deleted. You will likely need to add a new field to your event table for this. Enable indexing. | A number field Zulu uses to tag an item to be deleted. You will likely need to add a new field to your event table for this. Enable indexing. | ||
Revision as of 23:15, 30 July 2019
- These are the Todo Properties that Zulu uses when dealing with todos. For sanity, they are organized here by the FileMaker field name in the Zulu2SampleData database.
zulu_UUID
- Layout Object Name: UUID
- Field Type: Text
Text field which contains the Zulu UUID for an event. You will need to add a new field to your event table for the UUID. This field is populated by the Zulu. You should enable indexing on your UUID field, as it is searched on often.
zulu_CREATION_TIMESTAMP
- Layout Object Name: CREATION_TIMESTAMP
- Field Type: Timestamp
The timestamp on which this event was created.
zulu_MODIFICATION_TIMESTAMP
- Layout Object Name: MODIFICATION_TIMESTAMP
- Field Type: Timestamp
Modification timestamp of the event. This is used for caching purposes by calendar clients. This must be a timestamp field, not a date.
Summary
- Layout Object Name: SUMMARY
- Field Type: Text
The SUMMARY is the title or name of the todo. Do NOT use a calculation here. Switch to auto-enter calcs if you have to, once Zulu is up and running.
Note
- Layout Object Name: DESCRIPTION
- Field Type: Text
A more complete description of the event than is provided by the SUMMARY field.
zulu_STATUS
- Layout Object Name: STATUS
- Field Type: Text
This defines the current status of a to-do. Valid values are: NEEDS-ACTION, COMPLETED, IN-PROGRESS, and CANCELLED
zulu_COMPLETED
- Layout Object Name: COMPLETED
- Field Type: Timestamp
This defines when Date & Time that a to-do was marked completed.
DateStart
- Layout Object Name: START_DATE
- Field Type: Date
This specifies when the todo begins. This field is optional.
zulu_DUE
- Layout Object Name: DUE
- Field Type: Timestamp
This specifies when the todo is expected to be completed.
zulu_PRIORITY
- Layout Object Name: PRIORITY
- Field Type: Number
This represents the priority of the todo. Reminders show this as Low/Medium/High/None, but represented as a number here. You can create a calc field that translates to more human readable.
zulu_ALARM_ACTION
- Layout Object Name: ALARM_ACTION
- Field Type: Text
Alarm action to be taken. Currently only the value DISPLAY is supported.
zulu_ALARM_DESCRIPTION
- Layout Object Name: ALARM_DESCRIPTION
- Field Type: Text
Description of the proximity alarm.
zulu_ALARM_TRIGGER_TIMESTAMP
- Layout Object Name: ALARM_TRIGGER_TIMESTAMP
- Field Type: Timestamp
The date and time the alarm should go off.
zulu_ALARM_PROXIMITY
- Layout Object Name: ALARM_PROXIMITY
- Field Type: Text
How the proximity alarm should be triggered. Valid values are ARRIVE and DEPART. This will determine if the proximity alarm is triggered when arriving or departing the location described by the latitude and longitude coordinates.
zulu_ALARM_LOCATION_TITLE
- Layout Object Name: ALARM_LOCATION_TITLE
- Field Type: Text
Title of the location for the proximity alarm.
zulu_ALARM_COMPLEX_TITLE
- Layout Object Name: ALARM_COMPLEX_TITLE
- Field Type: Text
URL Encoded title, which will show as a friendly name for the location of the proximity alarm.
zulu_ALARM_RADIUS
- Layout Object Name: ALARM_RADIUS
- Field Type: Number
This field determines the distance in meters from the coordinates that should trigger the proximity alarm. This defaults to the value 400.
zulu_ALARM_LATTITUDE
- Layout Object Name: ALARM_LATTITUDE
- Field Type: Number
The latitude of the location for the proximity alarm.
zulu_ALARM_LONGITUDE
- Layout Object Name: ALARM_LONGITUDE
- Field Type: Number
The longitude of the location for the proximity alarm.
zulu_ALARM_TIMESTAMP_UUID
- Layout Object Name: ALARM_TIMESTAMP_UUID
- Field Type: Text
The internal UUID for the timestamp alarm. Zulu populates this when creating alarms in Apple Reminders.
zulu_ALARM_PROXIMITY_UUID
- Layout Object Name: ALARM_PROXIMITY_UUID
- Field Type: Text
The internal UUID for the proximity alarm. Zulu populates this when creating alarms in Apple Reminders.
Event ID
- Layout Object Name: PKEVENT
- Field Type: Number
The primary key for the todo record.
zulu_ICAL_DATA
- Layout Object Name: ICAL_DATA
- Field Type: Text
The ICal text dump of the todo from Apple Reminders. This does need to be stored in FileMaker, but you shouldn't need to edit it.
zulu_ACTIVITY
- Layout Object Name: ACTIVITY
- Field Type: Text
This field is multipurpose. A specific value in the field will be represented as an actionable icon on the Reminder. Some examples are:
- tel:7702349293 - this will allow the user to call a phone number from the reminder.
- http://google.com - this will open a web page.
- fmp://127.0.0.1/Zulu2SampleData - this will open a FileMaker database.
zulu_DELETED
- Layout Object Name: DELETED
- Field Type: Number
A number field Zulu uses to tag an item to be deleted. You will likely need to add a new field to your event table for this. Enable indexing.
