Using the FileMaker Barcode Add-on for New Records with Unique Serial Numbers

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ม.ค. 2025

ความคิดเห็น • 11

  • @gdeadtoo
    @gdeadtoo 3 ปีที่แล้ว

    Imagine my surprise when I was surfing the latest videos, and this popped up. Many thanks for the answer!

    • @ProductiveComputing
      @ProductiveComputing  3 ปีที่แล้ว

      Glad we could help Steve! (obviously, you inspired an entire video with a good question). Best of luck with your development. 👍

  • @crystalwhistle24
    @crystalwhistle24 2 ปีที่แล้ว +1

    Hey Mark, I'm running into some strange behavior with this solution - where putting the generate as configured script in an onRecordLoad script trigger fails to generate a bar code if the go to record is happening in a script (ie a loop to generate barcodes for a bunch of existing records.) I do have a pause with in the loop between goto record commands and within the onrecordLoad before calling the generator script. I also notice the call stack in the script debugger is stacking up with multiple calls to the generate as configured script and there is an error 5 getting thrown somewhere inside the java script where I can't get to it. any ideas what's going on with this?

    • @ProductiveComputing
      @ProductiveComputing  2 ปีที่แล้ว

      Hello @crystalwhistle24 you may have fallen into a small bear trap here. The technique demonstrated in this video assumes you have a single button and you are adding one record at at time (not in a loop). For creating barcodes in mass via a loop, you're going to have to deploy a slightly different technique. You can't use a loop in the traditional sense. This is because of the way the javascript does call backs to FileMaker (long story).
      Instead, you are going to have to first create your records and their IDs. Then, once the records are created, you can populate the barcodes. However, you can't use any of your existing FileMaker experience to solve this puzzle. You going to need some out of the box thinking. Luckily, others have run into this same sticky wicket and we already solved that puzzle. We have an entire video on it here in fact which should help you out with your situation if you haven't already watched it: th-cam.com/video/FyzxfYH3PTw/w-d-xo.html
      Please report back and let us know how it went for you! - Marc

    • @crystalwhistle24
      @crystalwhistle24 2 ปีที่แล้ว +1

      @@ProductiveComputing Thanks, Marc I figured I wasn't the first person to run into this challenge. the work around with the install ontimer script seems to work fine. I'm going to set it up to run after hours since it has over 14,000 barcodes to make and a one second pause between will put us up over 4 hours. moving forward we'll only need to make a few dozen at a time. :-)

    • @ProductiveComputing
      @ProductiveComputing  2 ปีที่แล้ว

      @crystalwhistle24 We love hearing small success stories like these. Good job. And wow, 14,000 barcodes - nice! Going forward it will be a snap to keep them updated once the big batch is complete. And the beauty of this is that you don't need to install barcode fonts on a bunch of machines for those using the system. Keep in touch if there are more questions/discoveries.

  • @Mega_Casual
    @Mega_Casual 3 ปีที่แล้ว +1

    Love your Filemaker series tutorials. I have Filemaker 19.4.1. Trying to use add Portal and choose add-on database. I don't find that in this version like there is in Version 18. Is it hiding somewhere else or is there a work around for it in Ver 19.x ? Thank you.

    • @ProductiveComputing
      @ProductiveComputing  3 ปีที่แล้ว

      Hello @Casual_Logic so happy to hear that you love the FileMaker series tutorials. We are about reference all those TH-cam videos inside of a new combined free course found at Productive Computing University (htts://www.ProductiveComputingUniversity.com). We're doing this to give people and opportunity to watch all these videos in a way that will track their progress and where they are far more organized allowing the student to better focus on the content. We're also going to make the FileMaker files used for those videos available for free download completely unlocked.
      Now back to your question. So, the original tool called "Add-on tables" is still available but closer to the bottom of the add-on list (you have to scroll down in 19). There are now two types of add-ons. Ones that are "JavaScript" and ones that are simply called "Tables". Also note you don't see this until you click the plus button.
      Good luck with your development and continue to enjoy FileMaker 19.4 - it's their best version yet!

    • @Mega_Casual
      @Mega_Casual 3 ปีที่แล้ว

      @@ProductiveComputing Still don't see it. It's not as user friendly as version 18 where it had the clickable option to use "New add-on Table" then offered a list of different pre-made forms to use. I can create the Portal just fine but then I can't find where to go for the new add-on table. I don't see a plus button. Scrolling down further where? Thanks so much for the reply.

    • @Mega_Casual
      @Mega_Casual 3 ปีที่แล้ว

      @@ProductiveComputing I found "add-on table" in the left side panel. Don't have to create a Portal first anymore. Thanks so much. Excited to try out your updated series.

    • @ProductiveComputing
      @ProductiveComputing  3 ปีที่แล้ว

      Oh good, glad you found it! Sounds good and stay tuned for more...