Feature Request: Bank State Branch Validator

  • shiptonc
    Asked on May 1, 2024 at 10:02 PM

    How do i best look up external records to sanity check if an account number or BSB number is valid. Is that possible in your system to apply some logic checks like this?

  • Sheena JotForm Support
    Replied on May 2, 2024 at 12:09 AM

    Hello Craig,

    Thanks for reaching out to Jotform Support. You can put all the account numbers on a spreadsheet and upload it to our Spreadsheet to Form Widget. This widget has the feature to validate codes, and by setting this field as required, the users won't be able to submit the form if they provide an incorrect code. Let me show an example:

    1. Here's ab example of the spreadsheet I will upload to the widget:1669077155 637c18a3143c8 637c18a31438a Screenshot 10
    2. Upload the sheet to the widget. You can personalize the error code that you want to show in the widget's settings.1669077287 637c1927c5191 637c1927c514e Screenshot 21
    3. Set the field as required. Now the users won't be able to submit the form if the incorrect code is provided. 1669078041 637c1c199f8db 637c1c199f89e Screenshot 32

    This guide on How to Use the Spreadsheet to Form Widget would be helpful for you.

    Give it a try, and let us know if you need any other help.

  • shiptonc
    Replied on May 2, 2024 at 12:25 AM

    So we would need all the available BSB of all banks in Australia? Is there another way of approaching this?

  • Sheena JotForm Support
    Replied on May 2, 2024 at 1:20 AM

    Hi shiptonc,

    Thanks for reaching out to Jotform Support. Unfortunately, the feature you're looking for isn't available at Jotform right now. We do not have a widget that could validate BSB  numbers. We've gone ahead and escalated your request to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

    Thanks for your patience and understanding, we appreciate it.

  • shiptonc
    Replied on May 2, 2024 at 2:45 AM

    Can you send requests to websites and get a response back? https://bank.codes/australia-bsb-number-checker/ is that available within jotform?

  • Emma JotForm Support
    Replied on May 2, 2024 at 3:05 AM

    Hi Craig,

    Thanks for reaching out with this feature request. While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. We've escalated your request to our Developers. Once we hear back from them, we’ll update this thread and let you know.

    Thanks for your patience and understanding, we appreciate it.

  • shiptonc
    Replied on May 2, 2024 at 3:08 AM

    hi Emma

    I have a long list of valid bsb numbers. Can i validate it somehow? Upload the list of 15,000 valid bsbs?

  • Emma JotForm Support
    Replied on May 2, 2024 at 3:38 AM

    Hi Craig,

    Thanks for getting back to us. If you're able to upload your valid BSBS file to an Excel sheet, you can manage the validation of the data you collect by adding a Spreadsheet to Form widget into your form, as my peer showed above.

    Also, check out our guide explaining How to Use Spreadsheet to Form Widget.

    Give it a try and reach out again if you have any other questions.

 
Your Answer