I'm trying to create the capability for some of my co workers to update the data I load into my QVW's. The team I work with "works" accounts, and they want to be able to know which accounts they've worked. In comes the INPUTFIELD option.
I've created two fields:
Worked?
Comments
Where the analyst could enter any value for Worked?, ideally 1 or 0, to define which accounts they have "worked" so far. Also, the comments field is there in case they want to add additional comments to the account after it's been worked.
My question is, can INPUTFIELDs be used in Charts? I.E. Straight Tables? I have my INPUTFIELD's in a straight table, and I don't see the option to actual edit the field, but I do whenever I have these fields listed in a Table Box. Are Table Boxes the only "table" that has this functionality? The reason I'm asking is because I can limit the dates that the end user sees with a Straight Table, making only the latest month view-able, so it reduces the amount of fields they see significantly. I'm not sure how to do this in a Table Box, because I don't see a place to create calculated dimensions or expressions.
My second question, once this is published and on the web, if two users are accessing my QVW at the same time, and one user adds a "1" in the field Worked? for a given account, will this automatically calculate and reload the QVW so that the other user accessing the page know another Analyst has "worked" the account, and they see the 1, so we can eliminate duplicating efforts, and highlight rows that have been worked, or something to that effect. I know this isn't the most efficient way to solve this problem, but it's what I have to work with for the time being...
