- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Problem Statement:
The use case I'm working on is a form (Now Platform) with a UI Action button that would read an attachment (in a File Attachment field, not the paperclip; would be an Excel file) and after clicking this button, would auto populate the fields in the current form.
I have set up the import set and transform map to do so, but I'm unsure what to write in the UI Action button script.
Any guidance would be appreciated!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi,
You can use the GlideSysAttachment api to get the content from the excel file (GlideSysAttachment - Global) and GlideTextReader - Scoped to read the content
Then you can update your record with the values of the attachment.
You can also insert the values that you got from the attachment on the import set table and run the transform instead of updating the record directly, but it would be one step more in that case
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi,
You can use the GlideSysAttachment api to get the content from the excel file (GlideSysAttachment - Global) and GlideTextReader - Scoped to read the content
Then you can update your record with the values of the attachment.
You can also insert the values that you got from the attachment on the import set table and run the transform instead of updating the record directly, but it would be one step more in that case
