HOW TO INSERT DATA FROM FRONT END TO BACKEND TABLE THROUGH PORTAL? PLEASE HELP .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-11-2020 09:58 AM
Dear Developers,
I want to show end user a form and when they submit it , it will save on backend table. please let me know how can i achieve this through portal?
As a service portal learner, want to achieve this but couldn't. Some code will be helpful to achieve this.
Regards,
Gudu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-11-2020 10:10 AM
Hi Gudu,
there are multiple ways you could achieve this. You could use a workflow, a flow, or even a simple business rule.
As using a business rule would be the easiest for a beginner, I'd suggest you to take a look into them.
You could do something like
After insert business rule
table: sc_req_item OR sc_task table (depending what you want to achieve)
condition the RITM's item is your current catalog item from portal
You can also script business rules - what you would need is an easy insert glide record query.
There is a very useful cheatsheet even more experienced devs use out of habit. I'd advise you to check out the snippet for the insert and update gliderecords
https://www.servicenowguru.com/scripting/gliderecord-query-cheat-sheet/