Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to get a caption for a text object from a simple table. E.g.
Object Name Caption
Name1 Caption for name 1
Name2 Caption for name 2
What should the expression be? I've tried
=(if([Object Name]='Name1',[Caption],0))
But that didn't work... Somehow I need to search through the table?
Your help will be appreciated!
Eon
Your solution needs to have one value returned. Try this:
=
Maxstring(If([Object Name] = 'Name1',[Caption]))Your solution needs to have one value returned. Try this:
=
Maxstring(If([Object Name] = 'Name1',[Caption]))perfect, thanks so much!!