Announcements
No record found.
Hello All Experts,
Can anyone help me in finding the formname and formid in a single query in on-premise system.
i can query in database as well.
*This post is locked for comments
Good day.
your query:
select FormId, Name, FormXml --If you need FormXml from SystemForm
Hello Joman,
How can i write a join between opportunity entity and this form, i din't find any relationship of entityform in the above table.
select FormId, Name, FormXml --If you need FormXml
from SystemForm
where ObjectTypeCode = 3
or:
select FormId, SystemForm.Name FormName, Entity.Name EntityNamefrom SystemFormleft join Entity on Entity.ObjectTypeCode = SystemForm.ObjectTypeCode and Entity.OverwriteTime = cast('' as datetime)
Hi,
in case you are only interested for a single form and you would not have access to database via SQL Management Studio, you could open this form in the form editor and click on F11.
The form id should be part of the url like
formId%3d1FED44D1-AE68-4A41-BD2B-F13ACAC4ACFA%26action
...
the form id is between %3d and %26, so 1FED44D1-AE68-4A41-BD2B-F13ACAC4ACFA in my example. The form name you can anyway see in the form editor as well.
Hth Thomas
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
ScottDurow 2
GJones 1
