I created an action chain to collect some data.
Haha, I'm still mulling over the school library project. I have this, and it copies the data to the column, but I get this error: User: 2112 | Loan: March 29, 2025 | Return: BAD DATE
Code:
program:
user = field('#user');
loan = format_date(field('#loandate'), 'dd MMM yyyy');
dev = field('#return');
if dev == '' then
return = 'no date'
else
return = format_date(dev, 'dd MMM yyyy')
fi;
'User: ' & user & ' | Loan: ' & loan & ' | Return: ' & return
User field: Text
loandate: date
return: date