Search results

  1. D

    Validating a substring

    Hi, There are a couple of options that could help with this but I think the best approach would be to create a new field as a calculated field. This new calculated field would be defined as a string parse using the TP calc function LEFT,1. The source field for this new calc field should be...
  2. D

    TracerPlus needs temporary fields/variables

    In that case, you should be able to turn the Confirmation property to FALSE for the Done button. This will disable the prompting for "Save Data Yes/No"
  3. D

    Form Logic ShowMessage with Variable Information

    Hi Tim, Instead of using the control ID, you can use the Field Index (zero based) to fill variable info into the Show message action. For Example: "Hi [*2*]" would output a string of "Hi " followed by the value contained in Field 3 (remember zero based).
  4. D

    TracerPlus needs temporary fields/variables

    Hi Tim, This is true. We do not (yet) have the concept of variables/non-saved data. You could override the standard Submit(Save) action with a button that executes custom SQL to only INSERT the field values that you want to save and simply bypass the TracerPlus standard Submit action altogether.
  5. D

    Form Logic: Execute SQL Select Statement

    Hi Tim, The idea of outputting the result of custom SQL does have the limitation you described. Your workaround is very creative. I would also add that if you then want to distribute this concatenated string to other fields you could use the parsing calc functions to do this (LEFT, MID...
  6. D

    Empty Field in Form Logic

    Hmm. I am not seeing that behavior. Can you submit your project to us via the support forum? I would like to try to reproduce exactly what you are experiencing. You can post the project here if you like but if there is any sensitive info in there, you may want to use our support ticket system.
  7. D

    Empty Field in Form Logic

    Hi, It should be ok to leave the If evaluation empty and that should resolve as ControlID 48 != "" which should then evaluate whether the value in Control ID 48 is, in fact, empty. I did just confirm this is the case and appears to be working as expected. This appears to be working as...
  8. D

    Filtering of items from a dropdown list and hiding some

    Hi, You should be able to sync that Excel sheet to the device and only send rows where AssetID = "". This filter is settable via the TP Connect Source configuration under the Options tab. Let me know if that helps.
  9. D

    Simple validation

    Yes, you can do this in a couple of ways. 1. You can use our Smart Form feature (location in the Data Capture section for each Session). Smart Form settings allow you to direct a data input scan to a specific field based on certain rules like "BeginsWith", "EndsWith", "Contains","IsLength"...
  10. D

    Ticket ID: GWR-955-59213

    Hi, I suspect this is related to the FoxPro driver in some way. I have experienced certain issues with these file based databases. Is this still an open issue for you?
  11. D

    Validation + Incremental Calc.

    Hi, If you were using just one field to to decide uniqueness, I would recommend using our AutoFind feature available for any field. This allows TracerPlus to do an auto find of a record based on the entered value and essentially put it into edit mode. Using this in combination with an...
  12. D

    Leading Zero

    Sent. Let me know if it helps clear anything up.
  13. D

    Leading Zero

    Hi, You cannot do a TracerPlus lookup on partial data like that but custom SQL could probably be configured to do that. Another option similar to Corey's is to force leading zeros to a string to match a certain length using Calculated fields (ADD and RIGHT) by adding a static field of...
  14. D

    Can specify the Export Filename on the fly, in the Scanner?

    Hi, This is not something you would configure in the Form Designer but it is the standard Windows style application menu. In TracerPlus, it is specifically the File menu option. In most cases, this menu is visible to the user. I should note that there is an option to hide this in the TP...
  15. D

    Leading Zero

    Using custom SQL is definitely an option to return some out of the ordinary type lookup result. I haven't validated the SQL above but conceptually, that could be a 3rd option.
  16. D

    Can specify the Export Filename on the fly, in the Scanner?

    Hi, The latest version of TracerPlus allows specifying a custom file name and a selectable folder path for exporting that file. This should allow you to do what you need. This is available via the File-->Export-->Custom menu option on Windows Mobile and the Menu-->Export custom menu option on...
  17. D

    Leading Zero

    Hi, I can quickly think of 2 options 1. You can sometimes do this in the barcode scanner configuration itself. This will depend on the model of the scanner and also the barcode type you are scanning. 2. Alternatively, in TracerPlus, you can create a new calculated field that would use the...
  18. D

    Part look-up / validation

    Hi, This still seems like a straight lookup to me; though I might structure the data in the lookup table a little bit differently. I also may be mis-understanding so feel free to correct me where I am wrong. If you stored data in your lookup table as one row for each unique item in your SKU...
  19. D

    Ticket ID: GWR-955-59213

    Hi, It sounds like it may be an issue with your FoxPro driver and/or your TracerPlus Connect configuration. Unfortunately, I do not see any attachments related to your post. As a suggestion, I would try configuring TracerPlus Connect in a batch mode sync first to be able to control the...
  20. D

    Part look-up / validation

    Hi, This should be very possible in TracerPlus using our lookup feature. You would need to load the BOM info to TracerPlus via TracerPlus Connect syncing software or via text file import but once you do that, the lookup approach is a pretty straight forward way to pull this off. We have a good...
Top