I’d like to generate custom forms from the user defined structure of my database application. I’d then have my customer buy Tap Forms for use in remote/offline data collection and import results from there.
I guess I’m asking if it is possible to populate tapforms_db.sqlite programatically with my own custom forms? “It works, but is not supported” is an acceptable answer for now and we could test?
olec
Hello Olec,
As long as you generate a CSV file with the right structure, Tap Forms can import that and create the form automatically for your users. If they’re needing to append data to an existing form they can do that to by selecting the form in Tap Forms first, then selecting the “Import Records” option.
I suggest you create your form (or even just a sample form) in Tap Forms first, then export that as a CSV file and take a look at the header row. It will contain the field type tags that you need to put in your CSV file.
Thanks!
Brendan
Thanks. That takes me almost there.
What about pick lists? Can they be imported?
I investigated using linked forms as pick lists, but they aren’t exported as far as I can understand.
Any chance the CSV header will be augmented with some of the other Field Options/metadata that can be set, such as pick list, default values etc?
olec
Yes, Pick Lists can be imported. When you create your pick list, there’s an action menu at the top-right which lets you do things like sort the values, delete the pick list, or import values. Just create a text file with one entry per row and upload it to Tap Forms.
Hmm… Not sure about updating the header with all that info. Ultimately an XML file would be ideal for something like that because it’s easy to represent relationships in an XML file.
Thanks,
Brendan
The XML approach is a great idea, easy way to get a complete structure easily uploaded in one go, forms, fields and picklists.
I’ll continue to see what can be done using the current import mechanisms and also manipulating the sqllite db looks manageable.
Thanks
olec
.
