Question

I'm trying to maintain an edittable in which the first column is a topic name, and the second column is a field of that topic name, pulled with $FORMFIELD{}%. This means that I need to use :

%CALC{"$T(R$ROW():C1)"}%

In the topic="" parameter of my $FORMFIELD{} expression, and then I need to use this generic pattern as a label in the edittable format to reproduce this for every new row.

I've struggled with this for ages now - is there any way to get this to escape properly ? Is there a simpler way to achieve this ?

My goal is to use edittable to change the topic in first column, and to have the second column automatically update with a value of the form attached to the topic I've just set in column 1.

Thanks for any advice.

Environment

-- SteveJonesST - 23 Mar 2006

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

I have not tried, but something like this should work: %CALC{"$NOP(%)FORMFIELD{\"Foo\" topic=\"$T(R$ROW():C1)\"}$NOP(%)"}%. The trick is to delay the FORMFIELD evaluation.

-- PeterThoeny - 23 Mar 2006

Hi Peter,

I really appreciate your time. I can see what you're saying - we need to process CALC before FORMFIELD, but I can't get your idea to work on my testcase, having tried many variations on your helpful suggestion. The two lines in this table should read the same when I get it right :

Any further advice is welcome.

-- SteveJonesST - 24 Mar 2006

You need to trim the whitespace, a topic=" UseCalcInTopicName " does not exist. I fixed above example.

-- PeterThoeny - 24 Mar 2006

Thanks. This is exactly what I needed. I appreciate your help very much.

-- SteveJonesST - 27 Mar 2006