Upload an Excel file with only validated rows.

Question

Hi&nbsp;&nbsp;I wish to upload an excel file into Quickbase and also perform validations while uploading so that I upload only validated rows.&nbsp;&nbsp;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.&nbsp;Also open to&nbsp; use Pipelines, but to be honest I am still not very comfirtable with pipelines.&nbsp;Would appreciate a help&nbsp;Many ThanksDinesh Rampal------------------------------Dineshdinesh.rampal@apollotyres.com------------------------------

gregorygebhardt · Answer

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
------------------------------

markshnier__you · Answer

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
------------------------------

dineshrampal · Answer

I am more comfortable using Javascripts. Is there a way possible using Javascript you know ?Many thanksDinesh------------------------------dinesh.rampal@apollotyres.com------------------------------

dineshrampal · Answer

Thanks Marks. I would prefer one step process, using some Java scripting OR pipeline as many users would be uploading data and hence want it to be more efficient.

------------------------------
DineshDineshdinesh.rampal@apollotyres.com
------------------------------

markshnier__you · Answer

I don't see how you can have a one step process without having a way for the uploaders &nbsp;to deal with their rejects.&nbsp;
My suggested solution could allow each separate &nbsp;user to deal with their own rejects.&nbsp;
My solution would be an upload and a button click.&nbsp;
Also, It sounds like you would be using up a a lot of Step Runs if you are dealing with records one by one in pipelines.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Upload an Excel file with only validated rows.

Related Content

Multi-File Upload

Convert Excel (once uploaded) to PDF inside QuickBase

Multi-Upload Button

Email address validation

[Snippet]Weekly Updates Excel Sheets to QuickBase