Help on Inputfield

[#1]

Hello.

I'm developing a qv application and i need the user to change certain values on an pivot table.

I Know the use of inputfiled but the problem is that i need to change the values of a calculated expresion that I can not load in the script

I Have a column (NO INPUTFIELD) with the results and i need to copy this values to another column and use inputsum in the new column

Can anybody help me?

Sorry for my English

Thanks in advance

[#2]

You have to write a macro to do that. In your case, you will cycle the first column and write the inputfield column with the corrisponding value. At the end, you will be able to manually use the inputfield as you do when its value is 0.

It is not very easy: see document "APIguide.qvw" included in standard documentation for the syntax of inputfield manipulation commands.

Bye

Paolo

[#3]

First of all, thanks for your answer.

The problem is that i need help to buildl this macro

If someboy can help me i would aprreciate.

Thanks

[#4]

Hi,

How about creating a duplicate column with different name and defining it as inputfield in the script? You can then use this column in 'inputsum'.

Example:

Inputfield Col3;
LOAD Col1,
 Col2,
 Col2 as Col3
FROM Table;

[#5 · Accepted solution]

Thanks for the answer

I try to explain the problem

Column3 is the result of an operation

[Column1+Column2/Column3] for expample

I can not do that on the script because any column has data of diferent tables

Happy new year for everyone

[#6]

Here's the macro i wrote

sub asignavalores

set fld = ActiveDocument.Fields("ventas2")
set table = ActiveDocument.GetSheetObject( "CH01" )
w = table.GetColumnCount
h = table.GetRowCount
set CellMatrix = table.GetCells2(0,0,w,h)
for RowIter=1 to h-1

valor=CellMatrix(RowIter)(2).Text


FLD.SetInputFieldValue RowIter-1, valor

next

end sub

The problem is that it does not copy the values correct, in order, and i don't kow why

The only thing i need is edit the 2 column, wich is the result of an operation

[RSvebeck]

Did you find a solution to this issue? I'm not successful in using SetInputFieldValue either.... //Robert