Additional Functionality

[UHNMChrisMaddock]

good morning, a few more questions about functionality please:

1. Is there an option to create a new row when editing form details rather than an update? we may need to see the old stored values for audit purposes.
2. Can we get the column definitions from the system inn a separate table or would we have to interpret the JSON output
3. If I set an item as the ID, with an identity and primary key, how do i hide the item on the form
4. Is there an option to set a default value
5. Is there an option to get version changes of a form, looks like it does an Alter Table at the moment

[LucioPelinson]

Hello @UHNMChrisMaddock

1) Is there an option to create a new row when editing form details rather than an update? we may need to see the old stored values for audit purposes.
For audit log enable:

• Audit log in Options
• Audit log in Grid Actions

2) Can we get the column definitions from the system inn a separate table or would we have to interpret the JSON output
I don't get it, would you have a example?

3) If I set an item as the ID, with an identity and primary key, how do i hide the item on the form
You can set VisibleExpression to do this "val:0"
https://md.jjconsulting.tech/articles/expressions.html

4) Is there an option to set a default value
Yes, set a ExpressionValue see too TriggerExpression

5) Is there an option to get version changes of a form, looks like it does an Alter Table at the moment
Not at the moment, but it is on the radar