Mass Data Updates

Hello,
in the "Mass Data Updates" window you'll find the reference field among your data fields. Select "Calculated Value" for this one. Say you want refences to the fifth record in the other table. Find out the ID of that record. Lets say its 5, too.
So you set the "Calculated value" to 5.
Greetings
Birger - Ninox Support

in a Calculated field date (days unpaid from invoice) some records have DATE+TIME, and others only DATE, how can I have all of them with only DATE?

Hi Filippo,
the best way to calculate a date difference in days is:

days('Due Date', today())

Best regards
Frank

I'd like to use the Mass Update feature to change the value in a CHOICE field if two numeric fields are equal.

So, if A=B, then set the value of CHOICE FIELD to one of four pre-defined values.

I have the first part of the statement figured out but can't find how to change the value of the CHOICE field. Any thoughts?

Have a look at a choice field. See that each entry has a unique number. Use this to allocate values:

1 will result in "first"

2 in "other"

3 in "second"

...

Birger