Forum Discussion
ChayceDuncan2
Qrew Cadet
Where is the actual data coming from? Is it from another Quick Base table, an external source?
For clarity - you description has an odd statement about trying to call IOL from a formula-url. IOL is used when you need to run a script without user intervention. The idea being that when an image loads on the page - your browser does something with that, like run a script. So perhaps I'm misunderstanding - but those two normally aren't combined and that you have to click a formula-url.
If you're clicking a button - getScript is one option - another is to actually just use a Quick Base code page.
getScript is a jQuery function - in this case, that would call out and load your JS file, and you could have a button on a Quick Base run your function with your getScript
A Quick Base code page is similar, in that you could set up a simple HTML page, and write you own Javascript into it. The advantage being there that you're not bound by Quick Base formula syntax and it makes it 100x easier to debug on the fly.
In that case - all you do is make a formula-url that directs you to the code page like:
https://yourrealm.quickbase.com/db/appDBID?a=dbpage&pageid=2
Where page ID 2 is your code page that contains HTML and JS. What I do a lot in this is just to put a really simple spinner as the HTML body so you know the page is doing something, and then all of you JS just runs. Once its done - you kick a re-direct back where ever you want.
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
For clarity - you description has an odd statement about trying to call IOL from a formula-url. IOL is used when you need to run a script without user intervention. The idea being that when an image loads on the page - your browser does something with that, like run a script. So perhaps I'm misunderstanding - but those two normally aren't combined and that you have to click a formula-url.
If you're clicking a button - getScript is one option - another is to actually just use a Quick Base code page.
getScript is a jQuery function - in this case, that would call out and load your JS file, and you could have a button on a Quick Base run your function with your getScript
A Quick Base code page is similar, in that you could set up a simple HTML page, and write you own Javascript into it. The advantage being there that you're not bound by Quick Base formula syntax and it makes it 100x easier to debug on the fly.
In that case - all you do is make a formula-url that directs you to the code page like:
https://yourrealm.quickbase.com/db/appDBID?a=dbpage&pageid=2
Where page ID 2 is your code page that contains HTML and JS. What I do a lot in this is just to put a really simple spinner as the HTML body so you know the page is doing something, and then all of you JS just runs. Once its done - you kick a re-direct back where ever you want.
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
DougHines
5 years agoQrew Trainee
Sorry for the long wait in the reply. I don't have access to work email on the weekend.
To answer everyone's questions :
Yes. The end goal is two fold : to populate a mass of Telephone numbers and decrease the time/clicks my coworkers perform adding the records. However, would rather not have accidents occur, which is entirely possible with the import function (I'm assuming you're speaking of the "import data from a file" option)
The best case scenario would be that they're all in sequence. Unfortunately there are often times we will have a few missing phone numbers that breaks a block of numbers into multiple blocks. On the flip side, we also have instances where there are absolutely no numbers in sequence. (I handle those personally via the import method). The solution I am attempting to create would be for those instances of sequenced numbers. My coworkers would simply need to enter the first telephone number and last telephone number, and the script would handle the procedural stuff and error checking.
To answer everyone's questions :
Yes. The end goal is two fold : to populate a mass of Telephone numbers and decrease the time/clicks my coworkers perform adding the records. However, would rather not have accidents occur, which is entirely possible with the import function (I'm assuming you're speaking of the "import data from a file" option)
The best case scenario would be that they're all in sequence. Unfortunately there are often times we will have a few missing phone numbers that breaks a block of numbers into multiple blocks. On the flip side, we also have instances where there are absolutely no numbers in sequence. (I handle those personally via the import method). The solution I am attempting to create would be for those instances of sequenced numbers. My coworkers would simply need to enter the first telephone number and last telephone number, and the script would handle the procedural stuff and error checking.