Is it possible to create one form that is tied to multiple tables?

joee1
Kilo Contributor

I have three tables and I would like to have a way for users to enter and view data for all three tables in one place. Is this possible?

4 REPLIES 4

Felipe32
ServiceNow Employee

Yes, you should be able to achieve this with a DB View:



Database Views - ServiceNow Wiki


Srinivas Balusu
Kilo Guru

You can do that using two different methods.



1. Using 'Form Layout' context menu you can add fields from referenced tables.


Configuring Forms - ServiceNow Wiki


2. Creating Database views as said by felipefaraco.


Database Views - ServiceNow Wiki


Above two solution will work.



You have 2 more options.



1. Create Record producer/table and keep all tables fields in it. Onsubmit, write a code to populate all your different tables.


2. Out of 3 tables, make 1 base and extend other two. Now personalize the form layout and keep only those field that you want.


The SN Nerd
Giga Sage

Another option might be to use a UI Page.



ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022