Clear a numeric field that contains ID

#1

In a workflow with an expression, how do you clear a numeric field that contains the ID of another record?
Keep in mind that each song is in column format, not JSON.

#2

Cc @tjerman, can u help me ?

#3
  1. I strongly advise not using Numeric fields to save IDs since that will lead to rounding and unexpected bugs. Always store strings
  2. What is the actual field type for the field you want to clear? The one in module edit
  3. If its a record field, setting the value to empty or “0” should do the trick
#4

In Corteza, the field is a record selector.
I then created a table and added each field as a column using the Corteza interface.
Sure enough, PostgreSQL set this field to numeric.

#5

@ANomel So this is resolved? Not sure based on your reply