You’re offline. This is a read only version of the page.
25
I received a request from a customer today that they'd like add the actual ID field to a view (the GUID) for contact. I am still awaiting why they want this in the view....
I thought originally I'd be able to do this with a calculated field but when I try to set it to "<myentity>.contactid" I get an error saying that it can't put a uniqueidentifier into a string field and it doesn't seem like there's a "toString" function that I can use there, unless I'm just unaware of the syntax I need.
I know I could do this with a plugin but is it possible do with a calculated field (or maybe a flow)?
Yes, I'm aware of that but since that's the GUID for the record it doesn't help me as I need the GUID for another field on the form. I actually think if I set up an Advanced find from Contact rather than the child entity I might be able to pull what I need (and as you said, I'd then have the GUID in that hidden column A).
Hi,
You are welcome.
By the way, when we export data to excel, there are 3 hidden columns in the file (A, B, C).
The first one (A), holds the GUID of the primary record.
To make it easier for others, please mark my answer as verified if it is helpful (select 'Yes' under 'Did this answer your question').
Thanks. The workflow would work since it doesn't really have to be real-time. They apparently just need it when they export it to Excel here and there for some other vendor to be able to import it into their system with the ID included. The link you sent won't work because it's not the GUID of the record I'm on that they need but the GUID of a lookup on the form. But interesting nonetheless.
Hi,
Thank you for your query.
Calculated fields have a limited set of functions available and do not have type conversion functions:
Define calculated fields | Microsoft Docs
Depending on the needs:
Here is another approach with calculate fields, but it is a bit risky:
How to Derive and Expose a Record GUID on Your Forms using OOB Functionality | PowerObjects
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (