JimLieder2
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Filtering data on mobile devices
While using an iPhone or iPad mobile device, I'm trying to figure out how to display the filter icon on reports, but can't get it to display. Is the option to change report filters on mobile devices still supported? See the attached screen shot for for an example of what I'm looking for. I'm using Safari as the browser and also tried displaying the filter icon using the Quickbase mobile app. Thanks, Jim LiederRe: Adding rows of data to a CSV in Pipelines
Hi Mark, I did see Sharon's YouTube video, and it's very informative and answered many questions. Sharon's Pipeline is retrieving a record from QuickBase and then adding a new row to a .csv file and then looping back to read another record from QB. In my Pipeline, the API is retrieving many records at once from a RollMaster, and I'm wondering if the process of adding rows of data works differently when retrieving many records at once. ------------------------------ Jim Lieder ------------------------------Adding rows of data to a CSV in Pipelines
I have a Pipeline that makes an API call to another application (rollmaster.com) to retrieve customer order information and download the information to a .csv file. The Pipeline successfully makes the API call to the RollMaster Orders endpoint, and I see all the RollMaster records scrolling by as it runs , but when the .csv file is created, only the column headers are there. I'm missing the step that maps the data retrieved to the table defined in the first step, but I'm not sure how to do that. The Pipeline steps are: Define the table Make the request (this is where the API call is made and the 400 records are retrieved Add a Row <- I think this is where I'm going wrong. Download .CSV <-empty file except for headers ------------------------------ Jim Lieder ------------------------------Can a webhook clear out data in fields?
Can a webhook remove existing data from a record? I've tried double quotes, single quotes, nothing between the <field> and </field>, but it doesn't seem to work. <qdbapi> <apptoken>xxx</apptoken> <usertoken>xxx</usertoken> <rid>[Inventory ID#]</rid> <field fid="18">""</field> <field fid="22">Returned to Stock</field> <field fid="34"></field> <field fid="105">""</field> <field fid="124">""</field> </qdbapi>Displaying a small image of an attachment.
I have a File Attachment field named Picture 1 which is used to attach pictures of the equipment being serviced. Right next to the attachment field, I want to display a small image of the picture. This works OK, except if when a revised image is added to the Picture 1 field, the formula field be still shows the original picture. I thought the v0 parameter would make sure to show the current version of the attachment. Formula field that displays a small image of the attachment field: If([Picture 1]>"","<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e183/v0\" height='200';>","")API_EditRecord with non-standard key
I changed a Table's Record Key from Record ID# (fid_3) to Customer_ID (fid_206). When I use API_DoQuery to look at the records, it looks like the the Record Key is still fid 3. Am I interpreting this right? </chdbids> <record rid="510"> <-- Is this telling me the Record ID is still fid 3 ? <fid="3">510</f> <fid="2">1533741045089</f> <fid="6">Test Account Name</f> <fid="206">ADAM4914</f> <update_id>1533741045089</update_id> </record> </qdbapi>QuickBase Sync access to Dropbox folders
I have a script that exports data from another application and saves the data as a .csv file in a Dropbox folder. According to the Dropbox documentation, there isn't a way to place the .csv files in a directory outside of the App folders. (https://www.dropbox.com/developers/reference/developer-guide#app-permissions So, the problem is the script is restricted by Dropbox to place the .csv files in Dropbox > Apps > QuickBase_Sync > Imports but the QB Sync process is looking in Dropbox > QuickBase_Sync > Imports. Is there for QuickBase Sync to look in the App folder path?
