Forum Discussion

RubyKapil2's avatar
RubyKapil2
Qrew Captain
6 years ago

Re: Offline options for field data collection

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

1 Reply

  • JordanMcAlister's avatar
    JordanMcAlister
    Qrew Captain
    6 years ago
    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
    ------------------------------