ContributionsMost RecentMost LikesSolutionsBucket Channel Check Rows for Data before Download CSV Hi, I have a pipeline that searches for records based on a status. It then uses the Bucket "Add a Row" in order to put those records and respective data into the Bucket Table that is defined (see picture below). After the rows are added, I have the CSV downloading (see picture) if the list of records exist. But that is where it is not working. In essence, I only want the Download CSV to happen if there is data and rows. Is there a way to query the Bucket rows or somehow check if data exists first? ------------------------------ Lija Harris ------------------------------ External API Pipeline Webhook Request Authentication credentials not provided Hi, This will be the first time I am hoping to call an external API. So far here is my pipeline but I am running into an authorization credentials not provided. Here is the documentation but I am unable to figure it out: And an example below: Here is the error the pipeline is giving me: how do I provide the authentication credentials? Any help would be incredibly appreciated. Thank you so much! ------------------------------ Lija Harris ------------------------------ Rich Text or URL Formula output Exact Form as PDF for Mobile I have an exact form and a formula URL on the record's form that displays the data on the exact form template: var text ID=ToText([Record ID#]); "https://xxxxxxx-xxxxxxxx.quickbase.com/db/xxxxxxxxx?a=dbpage&pageID=10&rid=" & $ID&"&fullver=1" For the desktop/non-mobile form users are able to save because the exact form has: <script> setTimeout(function() {this.print()},3000); </script> But this does not happen for those using the mobile app, it keeps the user in the QuickBase app and does not easily give an option to ultimately save as a PDF. 1) is there any code to force the mobile user out of the app and into their browser? or 2) Is there a rich text formula that the mobile user can click on to either save as a pdf? or 3) Is there any pipeline where the exact form is saved as a pdf in the record? Flexible for any solutions outside of the the above 3 It would be ideal for a pdf/doc to be created but worst case am open to a web browser mobile app friendly solution. Exact Forms Plus would not be an option unfortunately. Thanks so much! ------------------------------ Lija Harris ------------------------------ Code Page with User Input to Upload Multiple File Attachments to Quickbase I was watching the video by Kirk Trachy on uploading multiple file attachments to QuickBase and was wondering if it was possible to use this in a code page and pass the Record ID as an input variable that the user would enter in. Here is some of my code for example - the Record ID the user would input. Currently I have one field as an example (Upload File Attachment) but this just allows one file per field. Is it possible to pass the user input of the Record ID (either using getElementByID or $("input[name=_fid_191]").val() )to the code that Kirk Trachy uses to attach multiple files to the project?: <tr><td style="float: right;" class=m><input type=text size=40 name=_fid_191 ></td> <td style="float: right;" class=m>Record ID#:</td></tr> <tr><td class=m>Upload File</td> <td class=m><input type=file id="recordid" size=40 name=_fid_261 ></td></tr> Java: var id = $("input[name=_fid_191]").val() or ill use depending on what works: var id = document.getElementById("recordid").value); Thank you! ------------------------------ Lija Harris ------------------------------ Re: CODE PAGE: Javascript OnInput Function with Resulting Prompt or Alert (No UPS needs to Be QuickBase/Code Page Native!I have figured out how to get the prompt to work in console, but how do I get it to work in the code page? Seems like the oninput is not working ------------------------------ Lija Harris ------------------------------ Re: Code Page: Javascript Function Prompt or AlertI figured some of this out. I have gotten the prompt to work in the console, but how do I get it to work in the code page? ------------------------------ Lija Harris ------------------------------ CODE PAGE: Javascript OnInput Function with Resulting Prompt or Alert (No UPS needs to Be QuickBase/Code Page Native!Hi, I have a code page where users can input their information and it goes directly into QuickBase in Javascript and HTML. Our clients were wondering if a prompt could be given to users if they entered in a zip code that is not in their service area - like the Zip Code is not found in their LIST. Here is what I have so far but it is not working. As can be seen below, the fid is 16 of the field users input their zip code into. Zip Code is my LIST the client gave me (I gave a couple examples). I believe the OnChange is not working and instead should be OnInput? I would like the promp to ideally happen oninput instead since its a input field. For reference zip field (fid 16) would be what the user inputs. Otherwise is ther another way to get the user's input, check if its included in a LIST, and if not have text or a Pop up or Alert?: <script lang="javascript"> function CheckForZip { var zipcode = [94602,95616] var inputzip = "<field fid='16'>" + $("input[name=_fid_16]").val() + "</field>"; if (zipcode.includes(inputzip)) { alert ('yes'); } } On the form: <tr><td style="font-family: Sans-serif;" class=m>Zip Code:*</td> <td class=m><input type=text size=60 onChange=CheckForZip name=_fid_16 ></td></tr> ------------------------------ Lija Harris ------------------------------ Code Page: Javascript Function Prompt or AlertHi, I have a code page where users can input their information and it goes directly into QuickBase in Javascript and HTML. Our clients were wondering if a prompt could be given to users if they entered in a non-valid zip code. Here is what I have so far but it is not working. As can be seen below, the fid is 16 of the field users input their zip code into. Zip Code is my list the client gave me (well a couple examples). Is it the OnChange that is not working (On the Form:)? I would like the promp to ideally happen oninput instead since its a input field. For reference inputzip would be what the user inputs. That could also be incorrect possibly and there's another way to get the user's input: <script lang="javascript"> function CheckForZip { var zipcode = [94602,95616] var inputzip = "<field fid='16'>" + $("input[name=_fid_16]").val() + "</field>"; if (zipcode.includes(inputzip)) { alert ('yes'); } } On the form: <tr><td style="font-family: Sans-serif;" class=m>Zip Code:*</td> <td class=m><input type=text size=60 onChange=CheckForZip name=_fid_16 ></td></tr> ------------------------------ Lija Harris ------------------------------ Required Field in Code Page HTML/javascriptI have created a code page with HTML and Javascript. I have the following field that is required in the QuickBase form itself: However, I would like this to translate to the code page: <tr><td style="font-family: Sans-serif;" class=m>Contractor Business Name:*</td> <td class=m><input type=text size=40 name=_fid_6 ></td></tr> How do I make the field in the code page required? or will that kind of functionality need to happen in the javascript. If so, how? Thank you so much! ------------------------------ Lija Harris ------------------------------ Re: Add Field to end of customRedirectURL Code PageSorry, i meant that i would like https://XXXXXXXXXXXXXX.quickbase.com/db/XXXXXXXXX?a=dbpage&pageID=2&VARIABLE=C-72instead...in case that makes more sense because i dont need the rid at all, just the formula-text field's value from that record. ------------------------------ Lija Harris ------------------------------