- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2016 06:00 AM
I have a few custom tables that are related to each other. One of the tables has a reference list to another. This second table has a reference field to the third. When creating a new record for the first, it allows me to make new records for the second table but not for third table. The closest option I can see that is built into ServiceNow is the dynamic creation option but it only allows for one input. For the third table the record has multiple fields that should be populated differently record from record. Is there any way for the nested new record gui to bring up another one for the third table?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2016 06:54 AM
Thank you for the clarification. My brain had the ordering backwards.
My understanding is that it comes down a user experience thing. If you are in a reference view creating a new record and want to do another lookup, having multiple popups could bit a bit of a mess and start looking like the Internet browsers in the 90s.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2016 06:08 AM
Hi Andrey,
You will need to create the records on the third table and then come back and modify the reference(s) on the second table using GlideRecord queries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2016 06:13 AM
I'm trying to keep from doing that. Originally tables 2 and 3 were in the same table but a request was made for it to be split since the values entered on the fields in 3 would be repeated most of the time so an end user could just select it. However, once in a while new entries in table 3 would need to be made and the end user needs to be able to do it in the creation of a record of table 2. I've been thinking of just implementing this as a custom UI page with some popups to create the records with GlideRecords but I'm trying to stay with built in servicenow features or simpler options.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2016 06:19 AM
Hi Andrey,
Can you tell me why you are reluctant to implement the scenario I described?
A few lines of JavaScript to do a GlideRecord insert & update is easier than a UI page (which is going to include similar JavaScript + Jelly)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2016 06:23 AM
Sorry, I just went back a reread your original response and realized I misunderstood what you meant. I originally thought you meant the user creates the record on the third table elsewhere and then some background script or something would reference it. The problem with doing it is I'm not sure how to add in extra fields into the form for the new record for table 2 that would feed into the record for table 3. A dynamic creation script using gliderecords would work fine, if I could input multiple fields for table 3 into the page.
