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
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
Giga Sage

Another option might be to use a UI Page.



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