<!here|@here> Hi All, i have a specific use case where i have to fetch records from different tables and consolidate into a custom record and push it to my external server using REST api. But i need the user to decide on the source field (from which table) that has to go into the custom record's specific field.
Eg :
Table A in netsuite contain field Name
Table B in netsuite contains field Home Address
Table C in netsuite contains field Work Address
Table D in netsuite contains field Phone number
I have a custom record named "Custom Table" with field
Name and Contact
Now i have to allow the user to pick and choose what data from where should be mapped to "Contact" field in "Custom Table". It can be Home Address from Table B or Work Address from Table C or Phone Number from Table D. And then push the consolidated data of the "Custom Table" to external website using REST api exposed.
Any guidance on which dev tools in Netsuite will hold good to achieve this use case (Suitescript or Suitflow or any better suggestion) would be appreciated. Thanks in advance.