Offline options for field data collection
We have field workers in remote locations that do not always have access to internet signal. When they enter this area, they are forced to handwrite their info on paper or log to an excel file. The...
Forum Discussion
I reached out to our AE to see if can get EA - maybe I can find an interim workaround using this.
------------------------------
Ruby Kapil
------------------------------
------------------------------
Ruby Kapil
------------------------------
We seem to be in the same boat - I have field collectors go out to collect pole information using a quickbase app, and we need to have offline capabilities as well and currently they use an excel spreadsheet on an ipad and upload it into an attachment field on the form when they get better connection. Originally, offline was set to release at the end of the year, but they then told me that they would have something for us to use by the end of the first quarter of 2020. Since they have early access already for it, it shouldn't be too far away
------------------------------
Jordan McAlister
------------------------------
------------------------------
Jordan McAlister
------------------------------
- Yes, offline is huge. I just hope they can also get some more folks working on bug fixes also for the map reports in mobile mode. Regarding your use of an excel file, is the data collected loaded into a single file as an attachment or is each cell loaded into the appropriate field and record in quickbase? if loaded into fields, what process did you use?
That would be a workaround, user downloads to Excel the data they need to conduct the field survey and enter their survey into the spreadsheet. I guess they could then import their data collection Excel file each day but I have a concern that they would import data by accident into the wrong field names. Let me know your ideas and workaround details. Thanks.
------------------------------
Ruby Kapil
rubykapil@wi-finity.com
Wi-Finity, Inc
------------------------------- we leave it attached to a field without re-populating quickbase fields and our engineers just look at the spreadsheet. It's formatted in a way that is visually efficient so to speak, but for our other projects we use an excel module to reformat it for formulas and such. For your case, if you wanted to export back into quickbase - perhaps someone could take the attachment spreadsheet and use a module to put into an import format that you can put back into quickbase easily.
------------------------------
Jordan McAlister
------------------------------
