How to upload and download image/files with quickbase
Am trying to upload/Download an Image or a file using Quickbase Json Restful API. what is the best way to do that. Below is two options i have tried 1.) I upload the file to external server while saving the file name to quick base. The field type for this text field. 2.) I converted the image file to base64 encode via php and then created a field type File Attachment. The issue here is that base64 encoded files cannot be saved to quickbase via Restful API Json Call with field type set to File Attachment. here is how I did it with php <?php $file = 'photo.png'; $encode_File = base64_encode(file_get_contents($file)); ?> What is the best way to upload/download files via QB Json Restful API ------------------------------ Fredrick Esedo ------------------------------40Views0likes1CommentImport without duplication
I have source data in a .csv file. The source will update on a regular basis. I'd like to be able to import from source into QuickBase table 'Inventory', but not import values that already exist. It looks as if I can use the field 'IP' as the key but after that I'm not sure what steps to take. inventory.csv IP, host, OS 192.168.10.1, server1, windows 192.168.10.2, server2, linux Quick Base Table name: inventory Fields: IP, hostname, OS Thank you in advance, brian ------------------------------ Brian Dunbar ------------------------------38Views0likes4CommentsError Message: We cannot get the status of your upload at this time. Please refresh the page.
Receiving this error message when trying to upload an excel to an existing table. I can see it uploading until 100% complete, but I never see the sheet pop up for me to review the columns to import. ------------------------------ SallyAnne ------------------------------22Views0likes3CommentsRemove commas (newbie here) from imported numbers
Hello - I've spent an hour searching the community and cannot find an answer to removing the commas to my uploaded numerical column. I was my numerical field to look like this: 123456789 not; 123,456,789 I have changed the field properties to text and yet I still have commas. I have uploaded twice - no workie. Please help this new person with her first upload. Thanks, Lois ------------------------------ Lois Rockwell ------------------------------20Views0likes2CommentsDownloading large data table
I tried to download a large table over 600,000 records into a CSV file, but it exceeds the limits. I read some old posts that say to divide it into chunks. I would like to do that. As a viewer of the file I am unable to do anything but download the file. I could get by with just a subset of the data to use in some new reports. I'm not sure how to do this? ------------------------------ Bob T. ------------------------------14Views0likes7CommentsReports Pulling Data from 2 Tables at once
Hello, I have 2 tables that separate projects from my internal team, and external team. I would like to pull a single report that shows both entries and information regarding the projects in both tables. However, it looks like I haven't found a way to do this. Can someone support me in identifying if this is possible? Thank you so much ------------------------------ Anthony Wong ------------------------------12Views0likes2Commentsexport to excel dates in different forms
Hello, Does anyone know how I can solve this issue: When I extract my data to csv/excel the dates of my events are in different formats, 1/10/2020, meaning Jan 10 2020, or 1-10-2020, meaning october 10 2020. How can i make this unique? It looks all the same in QB. Thank you, Denise ------------------------------ Denise Egas ------------------------------7Views0likes1CommentGetting Last Updated Date to the Home Page
Dear Team, Good day! I'm trying to get the Last Updated Date to the Home Page automatically based on a CSV file upload. I have tried multiple options but nothing has worked for me so far. I could come at least somewhat closer to my expectation using a code page and get it embedded on to the home page using a web page widget. But honestly, I have no idea how I could access and call my table data to the code page. For better understanding of my expectation please jump into the link. :) https://drive.google.com/file/d/1aMrPXfDiHiBpbqGf8n5_jjBcRLKzZ-_a/view ------------------------------ Madushanka Weeriyasinghe Application Developer Healthrecon Connect ------------------------------4Views0likes0CommentsEditing Imported Data
I imported 2000 clients who have first and last names in a single field. But I have my name fields as 2 separate fields, first & last. Is there ANY WAY to do a mass edit where I can automatically split the names into 2 names?? Or am I looking at hours of manual editing!? Not a huge deal, it would be worth it. Thank you as always! -Mike ------------------------------ Michael Brumfield ------------------------------4Views0likes6CommentsExcel uploads with User Fields
Hi, I'm having an issue with a user field that someone could shed some light on. We currently upload data through excel csv and one of the fields is designer responsible. Our goal is use this upload data to link back to their employee table so that we can see all their projects or jobs in their employee table. When we upload the data it doesn't connect the name to the user. We've been told it's not possible because Quick Base can't match text name to a user. I've thought about automation, dynamic rules, or even having a field that was a formula that read the name in our designer name text field and selected the appropriate user. Any ideas on how this could work? Thanks! ------------------------------ Catelyn Atkinson ------------------------------3Views0likes1Comment