Product Ideas
Share your suggestions and ideas. Vote on ideas you find valuable.
Share your suggestions and ideas. Vote on ideas you find valuable.
Do you want to play a crucial role in shaping Jet Global products?
When construction an =NL function in JFx one has to leave the Field box empty to select the whole record. Everywhere else in Jet oneuses an asterisk to indicated everything. Only in the Field box of =NL do you select nothing to mean everything. I train new users and it is hard to explain that if you want everything, you select nothing. But only in this case.
this would be a very easy programming change. Right now the logic would be IF(Field box = "", select everything ELSE select what is in Field Box). New logic would be IF(Field box = "" or "*", select everything ELSE select what is in Field Box). This construct would let all legacy Jet queries continue to operate.
Guest
Thanks to Guest Nov 9 suggestion, I shall use it. From a programming point of view, my suggested change would be modifying one line of code – not much.
I’d also be interested to hear from Kim what other problems users have with the Field box. It seems simple to long-time users so hard to put ourselves in a new user’s position. Crowdsource your issues Kim, we will try to help!
Good suggestion and discussion. We have discovered ourselves that the uses of the Field in the Jfx may not be clear to users. We will certainly keep this in mind when looking to improve the usability of our tools.
I think if your users are explained that "Fields"are the columns going across in a table, they will understand. Try explaining that selecting a field is just filtering to return only that column, but leaving out a selection will return the whole table. This is what I've found training a few Excel-savvy, non-programmers at our business anyways!