ContributionsMost RecentMost LikesSolutionsRe: Using Code Pages to Refresh with a DelayDid any one get this to work with Adding a new record? @Ryan Pflederer @Michael TamoushHow do you loop through an array on a query JSON object item in a PipelineI have a pipeline where I have a Fetch JSON and then Iterate over JSON records. After that step I create the quickbase record but it is only creating the first record in the array and does not create the remaining list items. #Pipelines #array #json ------------------------------ Ty G ------------------------------ How to width of a Multi-select Text boxIs there a way to format a Multi-Select Text box and change the width? ------------------------------ Tyrone G ------------------------------ Re: API_AddRecord Alternative URL Redirect@Mark Shnier (YQC) & @Nathan Hawe Here is the html code. <!DOCTYPE html> <html> <head> <title>Title</title> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <script> function getParams() { var idx = document.URL.indexOf('?'); var params = new Array(); if (idx != -1) { var pairs = document.URL.substring(idx+1, document.URL.length).split('&'); for (var i=0; i<pairs.length; i++) { nameVal = pairs.split('='); params[nameVal[0]] = nameVal[1]; } } return params; } params = getParams(); </script> </head> <body> <h1>Title</h1> <form action="https://company.quickbase.com/db/XXXXXXX" > <fieldset> <legend>Call</legend> <ul> <li> <input type="text" name="a" id="cmd" value="API_AddRecord" readonly hidden /> <label for="Number">Number:</label> <input type="text" name="_fid_6" id="Number" style="width:12ch;"/> </li> <li> <label for="ContactID">ContactID:</label> <input type="text" name="_fid_7" id="ContactID" hidden readonly" style="width:34ch;"/> <input type="text" name="_fid_7_hidden" id="ContactID2" disabled readonly style="width:34ch;"/> </li> <li> <label for="CallingAbout">Calling For:</label> <select id="CallingAbout" name="_fid_8"> <option value="value1">value1</option> <option value="value2">value2</option> </select> </li> <li> <label for="Case Creation">Case Creation:</label> <select id="Case Creation" name="_fid_9"> <option value="Yes">Yes</option> <option value="No">No</option> </select> </li> <li> <label for="Comments">Comments:</label></br> <textarea name="_fid_10" id="Comments" rows="5" cols="30" placeholder="Please enter your notes about case"></textarea> <input type="text" name="apptoken" id="apptoken" value="xxxxxxxxxxxxxxxxx" readonly hidden /> <input type="text" name="usertoken" id="usertoken" value="xxxxxxxxxxxxxxxxx" readonly hidden /> </li> </ul> <input type="submit" value="Submit" style="color:black; font-size: medium;"> </fieldset> </form> <script> var para1=document.getElementById('Number'); var para2h=document.getElementById('ContactID'); var para2=document.getElementById('ContactID2'); var para3=document.getElementById('CallingAbout'); para1.value = unescape(params["var1"]); para2.value = unescape(params["var2"]); para2h.value = para2.value; para3.value = unescape(params["var3"]); </script> </body> </html> ------------------------------ C G ------------------------------ Re: API_AddRecord Alternative URL RedirectThe initial URL is setup using the URL Alternative referenced in the API_AddRecord Guide https://target_domain/db/target_dbid?a=API_AddRecord&_fnm_second_year=1776&_fid_8=changed&ticket=auth_ticket&apptoken=app_token&rdr=quickbase.com I want to use the URL alternative on an html form to pass data to my quickbase table and then redirect the user back to the form that the data was sent but instead the users sees the xml response page. This XML file does not appear to have any style information associated with it. The document tree is shown below. <qdbapi> <action>API_AddRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>7</rid> <update_id>1607034415505</update_id> </qdbapi> ------------------------------ C G ------------------------------ Re: API_AddRecord Alternative URL Redirect@Mark Shnier (YQC) I want to use the alternative url so an outside application can pass the data from their form to my quickbase table with out using a pipeline. ------------------------------ C G ------------------------------ API_AddRecord Alternative URL RedirectIs it possible to add a redirect to an alternative API URL? So instead of it showing the response xml page you can redirect to another URL. https://target_domain/db/target_dbid?a=API_AddRecord&_fnm_second_year=1776 &_fid_8=changed&ticket=auth_ticket&apptoken=app_token&rdr=quickbase.com #redirect #api #api_addrecord ------------------------------ C G ------------------------------ SolvedRe: Converting Buttons to Rich Text for MobileHello @Kirk Trachy The issue is I need the button to work on mobile reports. Formula URL Buttons do not show on mobile reports. ------------------------------ C G ------------------------------ Converting Buttons to Rich Text for MobileI have several buttons that are currently formula URL buttons and I need to convert them to Formula Rich Text buttons because they do not work on mobile. The code works api_editrecord works the only issue is that it does not save the form before running the api_editrecord. How do I get the rich text button to save before running the api_editrecord. If([Daily Pilot Log Status]="Submitted-Pending Vendor Approval", var text URL = URLRoot() & "db/" & [_DBID_DAILY_PILOT_LOGS] & "?a=API_EditRecord&rid="&[Record ID#] & "&_fid_150=" & URLEncode("Approved") & "&_fid_152=" & Now() & "&_fid_151=" & URLEncode(User()); var text rdr = URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=3"; "<a style='width: 150px;border-color:black; font: Arial; text-decoration: none; background:#37a237;color:white;' class='btn btn-sm btn-primary' href='#'" & "onclick= \"window.location.replace('" & $URL & "&rdr=" & URLEncode($rdr) & "');\"" & ">Approve</a>") ------------------------------ C G ------------------------------