37 ms·
No offense but if you're not currently implementing this the way the guy suggested you can make the product a ton better if you take his suggestion (I'm guessin
by frig 17y ago
No offense but if you're not currently implementing this the way the guy suggested you can make the product a ton better if you take his suggestion (I'm guessing you yourself aren't a power user, again no offense intended).
It sounds like what you're doing is generating a new worksheet and populating it with (static) data generated by running the user's SQL query.
This is fine for sharing static data but b/c you're apparently not using excel formulas in generating the 'resultset' worksheet (it's just raw data, again) the 'resultset' sheets aren't going to be auto-updating if the underlying data got changed (on the 'sourcedata' worksheet, if you follow).
If you can compile SQL queries into excel formulas that'll stay updated as data change this goes from an A to A+ produce.
You should start by looking at the documentation for Vlookup and Hlookup, as those are the built-in functions people use to (fake) selection.
- caffeine 17y agoYep, exactly what I meant. Thanks for explaining it better.
- samh 17y agoThanks caffeine and frig. I now understand what you is being suggested. Yes it's true, that is not how QueryCell currently works. I will have a think about this idea. My first impression is that it would be quite complicated to implement and get right but very powerful if done well. Thanks Guys.
- amih 17y agoAnother idea - viral marketing. You should at the bare minimum add a link in a cell under the result set so that the user who gets the result set created with QueryCell will know about it. You might consider a special landing page for those links
- samh 17y agoThanks again Amir, I appreciate all your ideas. What do you think about this : http://www.querycell.com/captionMe.html http://www.querycell.com/captionMe.html I need help with my Comic Ad.