Setup
-----
Table : Tasks
Slice : TasksActiveOnly (used by a Detail / Quick-Edit view)
Key columns
• TaskID (Key)
• Order (Number) – used only for sorting
• Deadline, Start date, End date, Description, …
View settings
-------------
– The slice **includes** column Order, but in the view:
Show? = FALSE
Editable? = FALSE
– User opens the task, edits Deadline / Description, taps Save.
Workflow
--------
Save triggers a **Data: set the values of some columns** action.
Order is **not** listed in that action.
Issue
-----
During the next sync the backend throws:
Value '01/01/1900 00:00:00' in field 'Order' cannot be converted to type 'Number'
Audit log shows the update payload with
`"Order": ""`
—even though the database had a valid number before the edit.
Questions
---------
1. Why is Order, although present in the slice, sent as blank when it’s hidden and untouched?
2. Best practice to keep the existing Order value (without showing or editing it) when using a “set the values of some columns” action?
Any insight appreciated. Thanks!
Jee
LinkedIn
Twitter
