ContributionsMost RecentMost LikesSolutionsRe: 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 isthe 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? Re: Does Quickbase have a mobile application that is available for use?Quick Base applications are automatically set up to work on mobile devices such as smart phones and tablets. Here's a link that explains more:https://help.quickbase.com/user-assistance/mobile_quickbase.htmlRe: Report link with blank sourceYou should be able to just add a report filter like the one below. The field named 'Master List of Cost Description' is a Look up field from the Child to the Parent table. Re: Make a multiple choice record conditional on other informationHere's a link on how to set up conditional dropdown fields. Let me know if this is what you were looking for:https://help.quickbase.com/user-assistance/conditional_dropdowns.html