ContributionsMost RecentMost LikesSolutionsRe: Form Post API_ImportFromCSV Via PHPThanks GH. I'm not clear on how we utilize this function with the code defined above. How do we define $records_csv? The code from my description works with posting a single record; we're just unsure how to use your function with the code from the description. Thanks!Form Post API_ImportFromCSV Via PHPHello: Does anyone have an example of submitting a form post API_ImportFromCSV via PHP? We developed a scheduling form that successfully posts into QuickBase via Javascript, however, if you inspect the element, the user_token is available, which is a major security issue. We?ve solve this by creating a 2nd action page (ex. success.php), where we have this info in variables and handle the post from this page, however, we?re stuck with posting API_ImportFromCSV on this method. To add context around the issue, we added a feature that allows us to schedule recurring appointments. The form looks like this: On the form page, we have our submit function: $('#live_form').attr('action', "/success.php).submit(); On our success.php page, we have: $qb_base_url = "https://company.quickbase.com/db/"; $qb_stage_table2 = ?abcdefghij?; $user_token = ?***********?; $url = $qb_base_url . $qb_stage_table2 . "?act=API_AddRecord&usertoken=" . $user_token; $data = array( '_fid_7' => $_POST['_fid_7'], // DATEPICKER '_fid_8' => $_POST['_fid_8'], // DATE FROM '_fid_9' => $_POST['_fid_9'], // DATE TO ); $options = array( 'http' => array( 'header' => "Content-type: application/x-www-form-urlencoded\r\n", 'method' => 'POST', 'Content-Type' => 'application/xml', 'QUICKBASE-ACTION' => 'API_ImportFromCSV', // NOT SURE IF THIS IS CORRECT 'clist' => '7.8.9', // NOT SURE IF THIS IS CORRECT 'content' => http_build_query($data) ) ); $context = stream_context_create($options); $result = file_get_contents($url, false, $context); This method will only submit 1 record, since we're not including the csvdata that successfully posts via JS. Is there a way to include this into the array to post as API_AdddRecord, or a better way to post API_ImportCSV?The javascript method w/out PHP is the only way we have successfully looped through and submitted multiple records. Thoughts? ThanksRe: Automate Table CSV Export To SFTP LocationThanks Gil. I was hoping QB would have something out of the box that I didn't yet explore (wishful thinking). I was researching Qunect as a potential solution, but I'm not familiar with Business Objects / Crystal Reports. I'll have to research them further.Automate Table CSV Export To SFTP LocationI am looking for a solution where I can export a table in a CSV format in some type of frequency (e.g. every 24 hours, or after x action takes place). What I'm trying to achieve is basically the same as Quickbase Sync, but exporting a file to a specified location rather than importing a file from a location. I can write an API to download the file locally, but it would be preferred if there's an option of doing the above without any manual intervention.Code Page Style References Requiring Sign-In?My code page is blocking an external css file in QuickBase. I have no problem referencing js files like so: <script>$( document ).ready(function() { $.getScript('xxxxx?a=dbpage&pagename=jquery.min.js') }); </script> I've tried:<link rel="stylesheet" href="xxxx"; /> And it provides this error in the console:Resource interpreted as Stylesheet but transferred with MIME type text/html: When I try going to the link directly, it requires sign-in. How do I get this bypass the sign-in?Re: How To Delete Record From Report Embedded On External WebsiteThanks. I figured out the JS piece above. I just prepended the base URL onto /db like this: "javascript:if(confirm ('Are you sure you want to delete this record?')){location.assign( 'https://company.quickbase.com/db/"; & Dbid() & "?act=API_DeleteRecord&apptoken=xxxxxxxx&rid=" & [Record ID#]& "&rdr=" & URLEncode(�WEBSITE TO REDIRECT TO�) & "')}" I didn't assign a user token, since the report is public (or set to Everyone On The Internet). I need to do more reading up the link you had sent over, since I don't fully understand the difference between the different tokens and tickets. In the event that I restrict it and I choose to use an API_DeleteRecord, what is the best method to fire the delete record. For example, do I just hardcode the link (https://company.quickbase.com/db/xxxx?a=API_DeleteRecord&rid=13&rdr=WEBSITETOREDIRECTTO), which achieves the same as the JS above, or to Avi's point, would I use like a PHP POST to hide the apptoken?How To Delete Record From Report Embedded On External WebsiteI have a delete button on my report, which works fine when I'm in QuickBase, but it will not work when the report is embedded on another website. My goal is to have the capability to delete a record from an external site, so if there's other suggestions how to do this, that's ultimately what I'm trying to achieve. Here's the code I'm using on the button: ////////// ATTEMPT #1: CODE I FOUND FROM FORUM "javascript:if(confirm ('Are you sure you want to delete this record?')){location.assign( '/db/" & Dbid() & "?act=API_DeleteRecord&apptoken=xxxxxxxxx&rid=" & [Record ID#]& "&rdr=" & URLEncode("https://www.website.com") & "')}" ////////// I have attempted hardcoding the root domain since it assumes you're in QB, but had not luck. /////////// ATTEMPT #2: ANOTHER CODE I FOUND ON THE FORUMS var text URL= URLRoot() & "db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#] & "&apptoken= xxxxxxxxx"; "javascript: " & "if ( confirm('Are you sure you want to permanently delete this record ? ') == true ){ "& "$.get('" & $URL & "',function(){" & "location.reload(true);" & "});" & "void(0);"& "}" ////////// The 2nd attempt works the same, but does not have a redirect on it back to the page I'd like it to go back to. 1. Is there a way for a externally embedded report to delete a record and redirect back to the external page? If not, 2. Is there a better way of deleting records from an external Wordpress site? I looked into the API integrations, but haven't found any clear examples.Re: Post Multiselect Values From WebformHi Matthew, it's posting arguments through a php POST using the Wordpress Ninja Form plugin. I'm not sure if I'll be able to modify the plugin to post differently, but I might be able to map differently. The _fid_7 field is a multselect field. Looks something like: ([_fid_6] => ValueFromTextField [_fid_7] => Array ( [0] => AF [1] => SQ [2] => AR )) I can use Zapier to map it, but it's not great since Zapier forces you to enter each option manually and everything runs together in the call without any separators (will look like AFSQAR). I have another post where I figured out eliminating Zapier, but I just realized multiselect fields don't work. Any thoughts?Post Multiselect Values From WebformI'm trying to post multiselect values from a webform to Quickbase and it only posts the last value selected from the form. I tried changing the QB field type to multiple options, but not having luck.Web Form Post From Wordpress To Quick BaseIf you?re using Open Source frameworks like Wordpress or Drupal, you can use form plugins to post to Quick Base. There?s a 3rd party plugin called Zapier, which helps you map to Quick Base, but I discovered another method that does not use Zapier. In this example, I?m using the Ninja Form plugin. I posted another tutorial (https://community.quickbase.com/quickbase/topics/capturing-query-string-parameters-on-web-forms) if you prefer to use the Quick Base form wizard, but you may have a preference using a ?no code? plugin that has conditional logic and web hooks built in. Ninja Forms has a premium add on called Webhooks, which I?ll be using in this tutorial. If you?re using public facing forms for data collection purposes and don?t need a token: Go to your App Home Settings Create new role called ?Internet? (or whatever). Click the checkmark on the Add column next to the table you want publicly accessible. Next, go to the Users table and click the ?Share app with new user? button. Select the role ?Internet? that you just created. Next, in NinjaForms, you can map your fields like the following screenshot. The remote URL will be your action URL minus any parameters. All your field ID?s can be mapped using ?_fid_#?, which you can find in your apps table settings.