GetObjectField Syntax

[#1]

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

[sorrakis01 · Accepted solution]

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

[#3]

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.

[rwunderlich]

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

http://masterssummit.com

http://robwunderlich.com

[pratap6699]

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

[#6]

Thank you for the help, Appreciate it.