Import 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 ------------------------------
Reports 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 ------------------------------
Downloading 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. ------------------------------
Is there an import log or history anyway? Or is it creatable?
Hi, we need to track / view the import history on one of our apps - ideally, name of import (filename), table it was imported to, and by who/when. I would think this MUST exist somewhere, but having trouble finding it. Does it exist? If so, where? If not, how would I create it? ------------------------------ Hannah Drake ------------------------------
Remove 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 ------------------------------
Error 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 ------------------------------
Editing 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 ------------------------------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 ------------------------------Getting 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 ------------------------------