ContributionsMost RecentMost LikesSolutionsFiltering 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 Lieder Re: Snapshot calculations Thank you Mark, that worked great! Snapshot calculations I have a master price table containing part numbers and customer prices and a child table that adds parts to a customer work order table. I set up a snapshot field to in the child table to capture the current price of a part being added from the master price table. When the part number is selected from the master price table, and before save is clicked, I want to do some calculations on the current price such calculating Qty. x current price and the sales tax for the part. The problem is the snapshot field isn’t valued until after the record is saved so my calculations for the extended price (Qty x Price) and sales tax don’t display any data until after the record is saved. Is there a way to do calculations on the snapshot field before saving? I don’t want to base calculations on the lookup field in the master table because I only want the calculations to be based upon the part price when it was first saved SolvedRe: Adding rows of data to a CSV in PipelinesHi 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 PipelinesI 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';>","") Re: API_EditRecord with non-standard keyOK, thanks for the clarification. So to edit a record using API_EditRecord when I've changed the primary key field, do I use key= instead of rid= Like this: a=API_EditRecord&key=ADAM4914 API_EditRecord with non-standard keyI 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 foldersI 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?