Skip to main content
Question

Upload an Excel file with only validated rows.

  • October 28, 2020
  • 0 replies
  • 130 views
Hi 
 I wish to upload an excel file into Quickbase and also perform validations while uploading so that I upload only validated rows.  
The default quickbase Table upload functionality will not work as it doesn't allow me to write customise validation for each row. I am ok to write Javascript for this, but not sure on how do i construct the javascript.

 Also open to  use Pipelines, but to be honest I am still not very comfirtable with pipelines. 

Would appreciate a help 

Many Thanks
Dinesh Rampal

------------------------------
Dineshdinesh.rampal@apollotyres.com
------------------------------
This topic has been closed for replies.

Not sure if this helps, I do a lot of this but I use VBA to validate data and then push the data using an API (again from VBA) to upload the data.  ​

------------------------------
Greg
------------------------------
Greg
MarkShnierYou
Forum|alt.badge.img+24
I would suggest that you import into steps.

The first step will just bring all the data into a scratchpad table in QuickBase where the validation will be done. Then I presume you would have a simple checkbox formula to calculate if the data is valid and you would make a button or Process to do a saved table to table copy API run import to move the data into the real table.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement