Using a service to 'Retrieve' a previously created record (by date field) and then copy table entries from this record to the current

I've had a go, but am struggling.

I'd like to use the 'retrieved service' service to retrieve a previous records table entries - all entries to be created in the current document (not all columns).

Has anybody done this, or do I need to get into JavaScript?

Kind regards

Yes you can do this.

1. Create a service configuration, select the "retrieve" service for the form that contains the data.

2. You need to retrieve the record by unique identifier, so map that to a field on the form where you will enter the uid.

3. On the output tab. link the table columns that you want to display from the source to the table on your form.

4. Trigger the service in the onItemChange of the field where the uid will be entered (could be programmatically)

In the attached image I am showing that I have returned only 2 of the columns from the table in the submitted document.

Perfect, I added the service to a click event on a button - it also works when the unique reference is a date field.

:)