-
shiptoncAsked 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 SupportReplied 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:
- Here's ab example of the spreadsheet I will upload to the widget:
- Upload the sheet to the widget. You can personalize the error code that you want to show in the widget's settings.
- Set the field as required. Now the users won't be able to submit the form if the incorrect code is provided.
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.
-
shiptoncReplied 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 SupportReplied 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.
-
shiptoncReplied 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 SupportReplied 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.
-
shiptoncReplied 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 SupportReplied 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.