Quote:
Originally Posted by shinykari
Is there a way to update a column only if the current value is blank? I would like to set the "kobo_read_date" to the current date, but only if the "kobo_read_date" is currently empty.
|
You can use a single-field edit with this template:
Code:
program:
if
$#kobo_read_date
then
$$#kobo_read_date
else
today()
fi
This checks whether #kobo_read_date is populated. If so, it'll return its value and remain unchanged. If it's not populated, it instead returns current datetime.