Hi
I run 3 workshops on a Saturday and have all the people that attend in my database. Can I create filtered views of my data. i.e. Only show the names of the people that attend the 10-12 Workshop and another tabbed view showing those that attend the 3-5pm etc. Creating a custom view for each so I can create a register of attendance for each workshop. In my database I have a Week1 to 10 attendance field and tick yes/no if they have come this week. It would be simpler to have a custom view for just this .. I hope this makes sense.
Also I include in the same database the customers that have left so I can keep them informed of new events etc. But I would like to exclude them from my views while maintaining the one database.
This was all possible in Bento and I wondered if I am just missing this ability or its not available yet and when will it be ?
Thanks
Neal
That is my problem also, Patrice, but now even when I reset syncing, it still won’t sync. I have read all there is to read on the internet to fix this problem. I have followed every step. VERY frustrating.
Before this problem, I really loved Tap Forms. Used to have Bento but this is so much better. Please help us fix this problem!!!
Hi Jo,
Unfortunately Bento won’t export the unique identifiers that identify a specific record when using the CSV export option. If it did, you could create a file with the unique identifiers in one column and the combined address (as Frank suggested – thanks Frank!) in the other column and then import that into the same form. The header row in the CSV file would have to have the unique identifier column be called “form_record_id” and the other column would be the address field.
For example:
form_record_id,Address
bento_id_1234,”123 Tap Zapp Way, Calgary, AB, Canada”
and so on.
Tap Forms will update a record when it has a unique identifier in that specifically named column and it’s able to find one in the current form.
But I don’t think this bit of information will help for this problem because of Bento’s lack of support for exporting unique identifiers. It does export them when exporting a Bento Template. Just not in the CSV file exports.
Thanks,
Brendan
Hi Frank,
Thank you for that solution.
However, as I mentioned above, I chose to import the bento files with the related data fields.
So importing a complete .csv file now would delete those related data fields.
Is there a way to just import the location fields and add them to the existing records?
Jo, the solution to your address import is to first export your bento data into an excel/numbers file. From there, bento breaks out the street/city/state/zip… you want to create a new column that has a formula to merge the 4 cells into one so that the full address is one cell.
From there you can import the address as location and with the latest update it will locate each address without GPS coordinates.
Simple as that! :-)
Hi Jo,
No worries. If you’d like me to delete your previous post I can do that.
As for your choice to make post, yes, you have it right. I understand that’s not ideal and it would be better if I supported the Address import for the Bento templates. I know it’s something I need to work on.
Thanks!
Brendan
Hi Brendan,
It seems I have to choose:
– or I import through a bento form, and I import the related datafields as well (the links to other forms). But then I lose the adresses.
– or I import through a .csv and then I can import the adresses, but I lose the related data fields.
At least, that’s what after some experimentation I seem to be confronted with.
Or am I doing something wrong?
Kind regards,
Jo
Hello Jo,
I would really recommend switching to multi-column list view for now until I can get an update out which improves the performance of single-column list view.
1. The Address list is one of the fields I haven’t yet supported. You could export them as a CSV file from Bento and then import into your form. However, you’d need to delete the current records in your form. Or you could just duplicate the form and experiment by importing into that one. Tap Forms will create the extra fields from the address list field.
2. Sorry, there’s not.
Thanks,
Brendan
Hi Brendan,
Thank you for the quick reply. Pasting the code in terminal was the solution.
TF is indeed very slow, it would be nicer to have it work faster.
I do hope this will turn out to be a worthy substitute for bento, since we need a smooth running, easy, and cheap dbase for my small company.
Also, 2 more questions
– since I imported from bento, the addresses have not been imported. Is there a way I can import these seperately and add them to the records in TF? I would hate to add over 3500 adressess manually.
– is there a way to easily convert check marks into multiple choicelists ?
Thanks.
Hi,
I’ve just started using TF this week (demo version) and bought the full app today.
Imported 4 bento templates. 2 of the forms I have already adapted where needed, they’re working fina.
When I started on the largest form (2500 records), TF was a lot slower, and when I edited some fields, it crashed.
Now it won’t start up again.
TF opens, and I can use the menu’s, but I can’t see the app itself.
Also, it doesnt recongise the backup I made just prior to start working on the 3rd form, so I can’t restart from there.
I deleted the original app and downloaded and installed a new one. I restarted the laptop a couple of times, etc.
Working on Macbook air osx 10.9.2.
Any ideas?
Silly me, perhaps. Since Tapforms was compared to Bento, I made the assumption there was a relational component. Is there? Does tapforms have the ability to query on fields, I.e. Date fields, names, etc. to extract specific info? Or, do I have to export to excel and do my queries there? Hope not, but I think so!
Thanks!
Hello Le-ann,
I would recommend following the Bento Template Import instructions available from the Help menu in Tap Forms for Mac. From there you will need to re-create any “smart lists” that you may have had in Bento. You may also need to re-create some of your formulas as they don’t always transfer over correctly due to differences in capabilities of the Calculation field types.
If you have a more specific question that I can answer, I’d be happy to do so.
Thanks!
Brendan
Hi I have a fully loaded bento database for cars and caravan sales and services. I’ve used bento for several years now but really want to move over to something that I can access the information stored in the database from work and at home. There are an awful lot of categories in my bento libraries and I am wondering is it better to start the libraries from scratch as opposed to importing them across? Some starting tips would be greatly appreciated as I am feeling somewhat overwhelmed.
Hi Steven,
I understand exactly how Bento is doing their searches. Yes, what I suggested works only for the advanced search. You can pick a specific field to search, then enter in a search term. Then add another search rule, pick another field, then enter in a different term.
Tap Forms only searches the entire database of forms if you click on the All Forms button after you type in a search term into the general search field.
But what I’m doing in Bento searches all fields for each term. It will pull any instance of sultry regardless of the field, then from those choices show any instance of maniacal regardless of the field and you might see:
orton | sultry | endearing | maniacal
gillespie | driving | maniacal | sultry
kilstedt | maniacal | sultry | light
then add light to sultry maniacal to read “sultry maniacal light” and you get
kilsdtedt | maniacal | sultry | light
But what you suggest trying in Tap Forms only works using the advanced search and further filter by terms in a single field. Adding terms anywhere else draws from the entire database and adds all instances of the search term to the current search
Or so I think it works….brain full.
