Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an Object with ID CH28 and i need to pull the entire column 3 (index 3 if i am not mistaken). I am having issues using the GetObjectField function. Can someone please help me with the syntax ,
eg (see below)
CH 28 [Object id and need to pull values for xyz column]
Header 1 | Header 2 | xyz | Header 4 | Header 5 |
---|---|---|---|---|
.. . . . . | 1 2 4 5 |
Thank you for the assistance,
Best,
Nik
Hi,
I think in simple table doesn't works. Change the object (try in a chart table (straight or pivot) ).
Remember the index starts at 0 in your case it's =GetObjectField(2,'CH28')
Regards
Hi,
I think in simple table doesn't works. Change the object (try in a chart table (straight or pivot) ).
Remember the index starts at 0 in your case it's =GetObjectField(2,'CH28')
Regards
Thank you. So if i write =GetObjectField(2,'Objectid') as an expression in a separate straight table or a chart , I will have the entire column with index 2 pulled in? Thanks again for your help.
GetObjectField() returns the Field name, not the contents. If you want the values in that column, something like this:
=concat(DISTINCT $(=GetObjectField(1,'CH51')),',')
-Rob
GetObjectField() returns the Field name or groupname, not the contents.
ex:GetObjectField(index,'objectid') it returns the specific field or group from index on object
Thank you for the help, Appreciate it.