Hi,
I am trying to input data of contact fields from other entity with some approval process involved.
so, I need to get contact schema columns as a lookup list and a field with the datatype of the selected column in opposite to get the data of the field.
Please help me achieve this functionality.
Thanks in advance
Like
Hi Nagaraju,
You can take all the columns from a specific table using the information_schema.columns view table by selecting it:
select * from information_schema.columns where TABLE_NAME = 'contact'
Though, it's hard to have it as a lookup as it's a system view table.
But, as a workaround, you can create your custom view which will store columns with data_type, etc. from the Contact table.
You will be able to create a lookup based on your custom view table after.
Thank you.
Nagaraju,
To successfully do it please make sure that the "Indexed" option is disabled for this lookup column (since the system cannot create an index that refers to a view table). This option can be found in the advanced settings of the column in the object settings:
Best regards,
Oscar