Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, is it possible to include input field so that user can enter comments in the last column or any other portion of the pivot table?
Please see sample velow:
DOCNO | CUSTNO | QTY | Remarks |
---|---|---|---|
DOC01 | NO01 | 10 | |
DOC02 | NO02 | 20 | |
DOC03 | NO03 | 30 | |
DOC04 | NO04 | 40 | |
DOCNO, CUSTNO, QTY are fields from database.
Remarks shall be serve as input for user so that they can put in text they like and will be link to the table via the DOCNO.
Hope you can help me on this, you may also see the attached file.
Thank you.
Marson
Hi. This is a solution where the input field is editable in the table box, and then displayed in the pivot.
Don't think it is possible to have input fields editable in a chart/pivot.
Regards
Robert
Hi,
Use InputField Command.
Rgds
Anand
Hi Robert,
your answer is very helpful, however considering there will be thousands of lines the user has to select the document so that the comment will not be lost.
What about auto scrolling the comments table simoltaneously when i scroll on the pivot table is it possibe? say placing the comment table next to the pivot table. just a thought.
thanks again. marson
Hi Robert,
your answer is very helpful, however considering there will be thousands of lines the user has to select the document so that the comment will not be lost.
What about auto scrolling the comments table simoltaneously when i scroll on the pivot table is it possibe? say placing the comment table next to the pivot table. just a thought.
thanks again. marson
please see attached editted QVW
Hi.
THere is no trigger for scrolling in a pivot or table. So the two objects can not be syncronized in that way.
However, a vertically placed slider object can control the dimensions, and by doing this you might get a deasent result.
See attached.
Regards,
Robert