Hi,
I have a CDT and it is linked to a form and fileds are linked to CDT columns.
Now, when user submit the form, data should save in the main table as well as another Audit table.
Any idea how can I achieve this requirement.
Discussion posts and replies are publicly visible
Hi there,
You can try to add triggers to your audit table.
Regards,
Acacio B
This I can do at database end.
But, I would like to know if there is any mechanism to copy source CDT field values to the destination CDT Audit fields and call Write to Data Store Entity.
Trigger is the best option.
But, if you need to execute this in Appian, then create an expression rule.
a!forEach(
items: ri!sourceCDT,
expression type!targetCDT(
param1: fv!item.value1
param2: fv!item.value2
)
Farnaz
Thanks