I have a bento database and will move to tap forms5 however it contains over 23,000 records and 53 fields. I’m sure there are fields not needed, Sparcely populated etc that could be eliminated. Is it better to convert to tap forms then. Cleanup the fields or export from bento a excel file then sort data by column/field to see what is used etc and the. Delete fields etc in bento before the migration to tap forms or how would I do this after migration? Bento is on an old computer that is being kept only until I migrate to tap forms thanks for the help
Hi Ron,
Rather than exporting to an Excel file, I would recommend exporting a .bentoTemplate file using the Export Template function in Bento. As long as you’re using at least Bento 4, then you will get not only the form structure but also the data in the .bentoTemplate file. Tap Forms will re-generate to the best of its ability all your custom layouts and import all the data from that file.
As far as what’s best to do, you may want to clean up everything in Bento first before importing into Tap Forms just so you’re not importing things you don’t need.
You can also just export it as is and import it into Tap Forms into a new document to see how it goes for you. The nice thing about Tap Forms is you can create as many separate databases as you like, whereas Bento could have only one. This gives you the peace of mind that you can play around with different copies of your data and once you’re satisfied then just use that one without having to worry about making mistakes because you can always import again into a new database document in Tap Forms.
Thanks!
Brendan
.
