Zulu - Todo Properties
From 360Works Product Documentation Wiki
(Difference between revisions)
| Line 6: | Line 6: | ||
* Field Name: zulu_UUID | * Field Name: zulu_UUID | ||
* Field Type: Text | * 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== | ==zulu_CREATION_TIMESTAMP== | ||
| Line 11: | Line 13: | ||
* Field Name: zulu_CREATION_TIMESTAMP | * Field Name: zulu_CREATION_TIMESTAMP | ||
* Field Type: Timestamp | * Field Type: Timestamp | ||
| + | |||
| + | The timestamp on which this event was created. | ||
==zulu_MODIFICATION_TIMESTAMP== | ==zulu_MODIFICATION_TIMESTAMP== | ||
| Line 16: | Line 20: | ||
* Field Name: zulu_MODIFICATION_TIMESTAMP | * Field Name: zulu_MODIFICATION_TIMESTAMP | ||
* Field Type: 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== | ==Summary== | ||
| Line 21: | Line 27: | ||
* Field Name: Summary | * Field Name: Summary | ||
* Field Type: Text | * 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== | ==Note== | ||
| Line 26: | Line 34: | ||
* Field Name: Note | * Field Name: Note | ||
* Field Type: Text | * Field Type: Text | ||
| + | |||
| + | A more complete description of the event than is provided by the SUMMARY field. | ||
==zulu_STATUS== | ==zulu_STATUS== | ||
| Line 31: | Line 41: | ||
* Field Name: zulu_STATUS | * Field Name: zulu_STATUS | ||
* Field Type: Text | * Field Type: Text | ||
| + | |||
| + | This defines the current status of a to-do. Valid values are: NEEDS-ACTION, COMPLETED, IN-PROGRESS, and CANCELLED | ||
==zulu_COMPLETED== | ==zulu_COMPLETED== | ||
| Line 36: | Line 48: | ||
* Field Name: zulu_COMPLETED | * Field Name: zulu_COMPLETED | ||
* Field Type: Timestamp | * Field Type: Timestamp | ||
| + | |||
| + | This defines when Date & Time that a to-do was marked completed. | ||
==DateStart== | ==DateStart== | ||
| Line 41: | Line 55: | ||
* Field Name: DateStart | * Field Name: DateStart | ||
* Field Type: Date | * Field Type: Date | ||
| + | |||
| + | This specifies when the todo begins. This field is optional. | ||
==zulu_DUE== | ==zulu_DUE== | ||
| Line 46: | Line 62: | ||
* Field Name: zulu_DUE | * Field Name: zulu_DUE | ||
* Field Type: Timestamp | * Field Type: Timestamp | ||
| + | |||
| + | This specifies when the todo is expected to be completed. | ||
==zulu_PRIORITY== | ==zulu_PRIORITY== | ||
| Line 51: | Line 69: | ||
* Field Name: zulu_PRIORITY | * Field Name: zulu_PRIORITY | ||
* Field Type: Number | * 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== | ==zulu_ALARM_ACTION== | ||
| Line 56: | Line 76: | ||
* Field Name: zulu_ALARM_ACTION | * Field Name: zulu_ALARM_ACTION | ||
* Field Type: Text | * Field Type: Text | ||
| + | |||
| + | Alarm action to be taken. Currently only the value DISPLAY is supported. | ||
==zulu_ALARM_DESCRIPTION== | ==zulu_ALARM_DESCRIPTION== | ||
| Line 61: | Line 83: | ||
* Field Name: zulu_ALARM_DESCRIPTION | * Field Name: zulu_ALARM_DESCRIPTION | ||
* Field Type: Text | * Field Type: Text | ||
| + | |||
| + | Description of the proximity alarm. | ||
==zulu_ALARM_TRIGGER_TIMESTAMP== | ==zulu_ALARM_TRIGGER_TIMESTAMP== | ||
| Line 66: | Line 90: | ||
* Field Name: zulu_ALARM_TRIGGER_TIMESTAMP | * Field Name: zulu_ALARM_TRIGGER_TIMESTAMP | ||
* Field Type: Timestamp | * Field Type: Timestamp | ||
| + | |||
| + | The date and time the alarm should go off. | ||
==zulu_ALARM_PROXIMITY== | ==zulu_ALARM_PROXIMITY== | ||
| Line 71: | Line 97: | ||
* Field Name: zulu_ALARM_PROXIMITY | * Field Name: zulu_ALARM_PROXIMITY | ||
* Field Type: Text | * Field Type: Text | ||
| + | |||
| + | How the proximity alarm should be triggered. Valid values are ARRIVE and DEPART. | ||
==zulu_ALARM_LOCATION_TITLE== | ==zulu_ALARM_LOCATION_TITLE== | ||
| Line 77: | Line 105: | ||
* Field Type: Text | * Field Type: Text | ||
| − | + | Title of the location for the proximity alarm. | |
| − | + | ||
| − | + | ||
| − | + | ||
==zulu_ALARM_COMPLEX_TITLE== | ==zulu_ALARM_COMPLEX_TITLE== | ||
| Line 86: | Line 111: | ||
* Field Name: zulu_ALARM_COMPLEX_TITLE | * Field Name: zulu_ALARM_COMPLEX_TITLE | ||
* Field Type: Text | * Field Type: Text | ||
| + | |||
| + | URL Encoded title, which will show as a friendly name for the location of the proximity alarm. | ||
==zulu_ALARM_RADIUS== | ==zulu_ALARM_RADIUS== | ||
| Line 91: | Line 118: | ||
* Field Name: zulu_ALARM_RADIUS | * Field Name: zulu_ALARM_RADIUS | ||
* Field Type: Number | * Field Type: Number | ||
| + | |||
| + | This field determines the distance from the coordinates that should trigger the proximity alarm. This defaults to the value 400. | ||
==zulu_ALARM_LATTITUDE== | ==zulu_ALARM_LATTITUDE== | ||
| Line 96: | Line 125: | ||
* Field Name: zulu_ALARM_LATTITUDE | * Field Name: zulu_ALARM_LATTITUDE | ||
* Field Type: Number | * Field Type: Number | ||
| + | |||
| + | The latitude of the location for the proximity alarm. | ||
==zulu_ALARM_LONGITUDE== | ==zulu_ALARM_LONGITUDE== | ||
| Line 101: | Line 132: | ||
* Field Name: zulu_ALARM_LONGITUDE | * Field Name: zulu_ALARM_LONGITUDE | ||
* Field Type: Number | * Field Type: Number | ||
| + | |||
| + | The longitude of the location for the proximity alarm. | ||
==zulu_ALARM_TIMESTAMP_UUID== | ==zulu_ALARM_TIMESTAMP_UUID== | ||
| Line 106: | Line 139: | ||
* Field Name: zulu_ALARM_TIMESTAMP_UUID | * Field Name: zulu_ALARM_TIMESTAMP_UUID | ||
* Field Type: Text | * Field Type: Text | ||
| + | |||
| + | The internal UUID for the timestamp alarm. Zulu populates this when creating alarms in Apple Reminders. | ||
==zulu_ALARM_PROXIMITY_UUID== | ==zulu_ALARM_PROXIMITY_UUID== | ||
| Line 111: | Line 146: | ||
* Field Name: zulu_ALARM_PROXIMITY_UUID | * Field Name: zulu_ALARM_PROXIMITY_UUID | ||
* Field Type: Text | * Field Type: Text | ||
| + | |||
| + | The internal UUID for the proximity alarm. Zulu populates this when creating alarms in Apple Reminders. | ||
==Event ID== | ==Event ID== | ||
| Line 116: | Line 153: | ||
* Field Name: Event ID | * Field Name: Event ID | ||
* Field Type: Number | * Field Type: Number | ||
| + | |||
| + | The primary key for the todo record. | ||
==zulu_ICAL_DATA== | ==zulu_ICAL_DATA== | ||
| Line 121: | Line 160: | ||
* Field Name: zulu_ICAL_DATA | * Field Name: zulu_ICAL_DATA | ||
* Field Type: Text | * 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== | ==zulu_ACTIVITY== | ||
| Line 126: | Line 167: | ||
* Field Name: zulu_ACTIVITY | * Field Name: zulu_ACTIVITY | ||
* Field Type: Text | * 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== | ==zulu_DELETED== | ||
| Line 131: | Line 177: | ||
* Field Name: zulu_DELETED | * Field Name: zulu_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. | ||
Revision as of 17:53, 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
- Todo Property: UUID
- Field Name: zulu_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
- Todo Property: CREATION_TIMESTAMP
- Field Name: zulu_CREATION_TIMESTAMP
- Field Type: Timestamp
The timestamp on which this event was created.
zulu_MODIFICATION_TIMESTAMP
- Todo Property: MODIFICATION_TIMESTAMP
- Field Name: zulu_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
- Todo Property: SUMMARY
- Field 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
- Todo Property: DESCRIPTION
- Field Name: Note
- Field Type: Text
A more complete description of the event than is provided by the SUMMARY field.
zulu_STATUS
- Todo Property: STATUS
- Field Name: zulu_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
- Todo Property: COMPLETED
- Field Name: zulu_COMPLETED
- Field Type: Timestamp
This defines when Date & Time that a to-do was marked completed.
DateStart
- Todo Property: START_DATE
- Field Name: DateStart
- Field Type: Date
This specifies when the todo begins. This field is optional.
zulu_DUE
- Todo Property: DUE
- Field Name: zulu_DUE
- Field Type: Timestamp
This specifies when the todo is expected to be completed.
zulu_PRIORITY
- Todo Property: PRIORITY
- Field Name: zulu_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
- Todo Property: ALARM_ACTION
- Field Name: zulu_ALARM_ACTION
- Field Type: Text
Alarm action to be taken. Currently only the value DISPLAY is supported.
zulu_ALARM_DESCRIPTION
- Todo Property: ALARM_DESCRIPTION
- Field Name: zulu_ALARM_DESCRIPTION
- Field Type: Text
Description of the proximity alarm.
zulu_ALARM_TRIGGER_TIMESTAMP
- Todo Property: ALARM_TRIGGER_TIMESTAMP
- Field Name: zulu_ALARM_TRIGGER_TIMESTAMP
- Field Type: Timestamp
The date and time the alarm should go off.
zulu_ALARM_PROXIMITY
- Todo Property: ALARM_PROXIMITY
- Field Name: zulu_ALARM_PROXIMITY
- Field Type: Text
How the proximity alarm should be triggered. Valid values are ARRIVE and DEPART.
zulu_ALARM_LOCATION_TITLE
- Todo Property: ALARM_LOCATION_TITLE
- Field Name: zulu_ALARM_LOCATION_TITLE
- Field Type: Text
Title of the location for the proximity alarm.
zulu_ALARM_COMPLEX_TITLE
- Todo Property: ALARM_COMPLEX_TITLE
- Field Name: zulu_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
- Todo Property: ALARM_RADIUS
- Field Name: zulu_ALARM_RADIUS
- Field Type: Number
This field determines the distance from the coordinates that should trigger the proximity alarm. This defaults to the value 400.
zulu_ALARM_LATTITUDE
- Todo Property: ALARM_LATTITUDE
- Field Name: zulu_ALARM_LATTITUDE
- Field Type: Number
The latitude of the location for the proximity alarm.
zulu_ALARM_LONGITUDE
- Todo Property: ALARM_LONGITUDE
- Field Name: zulu_ALARM_LONGITUDE
- Field Type: Number
The longitude of the location for the proximity alarm.
zulu_ALARM_TIMESTAMP_UUID
- Todo Property: ALARM_TIMESTAMP_UUID
- Field Name: zulu_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
- Todo Property: ALARM_PROXIMITY_UUID
- Field Name: zulu_ALARM_PROXIMITY_UUID
- Field Type: Text
The internal UUID for the proximity alarm. Zulu populates this when creating alarms in Apple Reminders.
Event ID
- Todo Property: PKEVENT
- Field Name: Event ID
- Field Type: Number
The primary key for the todo record.
zulu_ICAL_DATA
- Todo Property: ICAL_DATA
- Field Name: zulu_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
- Todo Property: ACTIVITY
- Field Name: zulu_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
- Todo Property: DELETED
- Field Name: zulu_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.
