How to move data between tables from one field to another

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-27-2023 10:33 AM
So I have a question I am seeking a solution for:
I have a Idea Record that has on the catalog item to produce the record a set of questions for the submitter to answer. Once sumbitted, it creates an Idea and fills in the answers to the questions in the fields on the form.
The workflow behind it works that if the Idea is approved, it creates a Demand.
What the Demand manager wants to know if there is a way that those answers in those fields on the Idea record could auto populate into fields on the Demand record once this workflow completes.
The questions on the Idea item are mapped to the fields on the Idea form, so can they be mapped to the Demand form as well? Maybe a business rule or a client side script???
Thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-27-2023 10:35 AM
Hi,
You can instead use a BR that runs after insert on Demand table that GlideRecords Idea table and get the values.