URL button to populate a field with the current user
Hi There, I currently have a url button that populates a certain field with the user that last modified the record. I need some help to change it from the user the last modified the record to the current user that pushes the button. is there anyway to modify the below for the above requirement? var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_30=" & URLEncode([Last Modified By]); "javascript:" & "$.get('" & $URL & "',function(){" & "location.reload(true);" & "});" & "void(0);"42Views1like12CommentsScroll Down Automatically on Mobile Form
Hello Quickbase Community. Is there a way to get a Quickbase mobile form scroll automatically to a specific place after having reloaded the page? We have a very long form, which will be used from Android phones, the form contains questions which will be answered with two different buttons each, as the user answers the questions they will have to keep scrolling down and answering. I need a way to make Quickbase scroll down to wherever the user was before pressing one of the buttons, so that he doesn't have to manually scroll after each answer. I tried using fragment identifier, by adding for example "#tdf_362" at the end of the redirect URL (see 2nd screenshot), which worked nicely for the desktop view, but didn't work for the mobile view. The buttons update a checkbox field in the background and then reload the page on edit mode, here's the code of one of those buttons. URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=xxxxxxxxxxxxxxxxxxx" & "&_fid_206=1"& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#]) Here's a screenshot of the form in mobile view: Here's second screenshot which shows error when trying to use the fragment identifier: Just in case this is useful, the error I'm getting in console says: qb.mobile.js:1 Uncaught TypeError: Cannot read property 'is' of undefined at Object.isPageLoaded (qb.mobile.js:1) at qb.mobile.js:1 at Object.execCb (require.js:29) at $.check (require.js:18) at $.<anonymous> (require.js:23) at require.js:8 at require.js:23 at z (require.js:7) at $.emit (require.js:23) at $.check (require.js:19) Thank You for taking the time for reading this post, any thoughts and ideas are appreciated! ------------------------------ Alberto Tablada BlueWell Group ------------------------------8Views0likes6CommentsQuickBooks Online APIs & oauth
Hey all, I'm in the very beginning stages of setting up a couple of API calls (send via "make request" step in pipelines) to QuickBooks Online. I have searched for an example of a successful implementation somewhere in the forums but can't find one. The article on Base-Books pipelines makes a reference at the very end to more information regarding using API calls to add sub-customers and rates, but I haven't been able to find it. I've got all the QBO-side API documentation, but I'm a bit stuck and would just love to look through an actual functional API call. Does anyone have a good example they'd be willing to share with me, or know of an app with an example in the exchange maybe? Thank you! #quickbooks #APIsandcustomcode #Pipelines #oauth2 ------------------------------ Elena Larrabee ------------------------------39Views0likes8CommentsAPI button to add new parent record
Hello, I'm wanting to add an API button in a child table that would add a parent record and also add the parent record id to the related field in the child record. Basically the same thing that adding a record from a record picker does but pre-populate fields in the parent record. Is this possible? Thanks in advance for any advice! ------------------------------ Sam Rettig ------------------------------26Views0likes7CommentsAPI_AddRecord and land the user in edit mode.
This works to works to create a record and land the user in View mode. URLRoot() & "db/" & [_DBID_SKTDS] & "?act=API_AddRecord" & "&_fid_6=" & URLEncode([Supplier]) & "&disprec=1"; Is there any way to land the user in edit mode? ------------------------------ Mark Shnier (YQC) mark.shnier@gmail.com ------------------------------17Views0likes16CommentsRestful API how to update multiple records?
Hi, I'm new to QB and API. I'm trying to update a field (checkbox) in a table for multiple records using an unique Key field. I managed to update the field for one Key field, but failed to update multiple in one request. My script for one record looks like : { "to": "ID of my table", "data": [ { "72": { "value": "unique Key field" }, "60": { "value": true =>tick the checkbox } } ], "fieldsToReturn": [ 3 ] } Is there a simple way to run this action with multiple values for my FiD 72? Thanks for your help. ------------------------------ David NEGROBAR ------------------------------51Views0likes2CommentsEdit Record button doesn't work (a=er)
Hello, I have a button and when I use ?a=API_EditRecord&rid= it works, but of course saves the record. I would like the record to stay opened in Edit mode. So when I use ?a=er&dfid=2&rid= it doesn't update any of the fields. I need to be able to enter a quantity before I save. I'm starting to feel crazy, but I had the button working the other day fine, and the next day it didn't work. This one updates fields correctly but saves: URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & URLEncode([Record ID#]) &_fid_119=" & URLEncode("Change Qty Requested") //Change Order Status & "&_fid_110=1" //Changed Item checkbox & "&_fid_111=" & URLEncode("Waiting on Approval") //Approval Status & "&_fid_109=" & URLEncode("Waiting on Approval") // Change Status & "&_fid_114=" & URLEncode([Qty]) // Change Previous QTY & "&z=" & Rurl() This one opens the record in edit mode, but doesn't edit the values of any of the specified fields: URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid=" & URLEncode([Record ID#]) & "&_fid_119=" & URLEncode("Change Qty Requested") //Change Order Status & "&_fid_110=1" //Changed Item checkbox & "&_fid_111=" & URLEncode("Waiting on Approval") //Approval Status & "&_fid_109=" & URLEncode("Waiting on Approval") // Change Status & "&_fid_114=" & URLEncode([Qty]) // Change Previous QTY & "&z=" & Rurl() What am I missing here?5Views0likes7CommentsAny interest in an open source set of SSIS components for MSSQL?
Hello - Wondering if there are other users of Microsoft SQL Server who might be interested in a simple set of SSIS components (connection manager, data source, and data destination)? I realize there's a commercial ODBC driver out there (which looks great), but I found myself in an odd situation where, for specific reasons, buying software is off the table, but investing time is OK. I've already got some basic stuff working and my intent is to polish it up enough to be useful without needing to know the API: Connection manager for attaching Data source for querying Data destination for writing back (No generalized ODBC like integration where you can do mass deletes) For the data source I'm also going to add something I've found useful on other projects, which is emitting "maybe kinda close enough DDL" for generating your target tables (it just abuses SMO). I've already got this working and it applies some basic rules (sanitizing column names, prefacing the individual address fields with the parent name prefix, etc.) as well as does some very rudimentary guesses on data types. It's mean to be an assist, not an operation you completely trust. I already wrote a generalized "auto sync" process that says "get everything from a database" (simple C# app - creates and runs DDL, merges data over, etc.), but I'm in the process of taking subsets of that and putting things into simple SSIS components. Basic SSIS process - set up the connection manager with your API key and select the database, then in the data source, choose your table. That's it. Done. It's meant to be easy. The only "API-ish" bit I'm exposing (mainly because I'm lazy) is the query. For right now I'm planning on that just being a string you enter. (EX:https://help.quickbase.com/api-guide/index.html#samplequeries.html) I don't want to have to get too far into the weeds right now in building a custom UI for that. I'm currently testing on SQL 2016. If anyone else is interested in testing later, please let me know. I'm happy to ship out a sample DLL. Right now I've got the data source implemented as I try to figure out how MS wants the destination written. Code will eventually get to GitHub once I finish wrapping some basic UI elements around things. Thank you, Eric3Views1like5Comments