Hi, I have built a database for reviews (see image below), which I imported from a csv file. Some things are not turning out the way I would like. It would be great if I could get some help on it.
The following are the issues:
1. Is there a simple way to show a Date and Time field type just as a Date? Having just dates as input it looks silly when it shows "Fri Aug 21 2015 00:00:00 GMT-0430 (-0430)" when I only need Aug 21, 2015.
2. Apparently there are unknown characters that look fine in csv but not in the database, like " or ç (see image). They all turn into a question mark. Is there a way to avoid this.
3. ....and Wix support shows that: to delete an item from a collection, right-click the row number, and then select delete. I'm unable to delete a row. There's proabably a really easy way but I can't figure it out. I'm using a MacBook and tried Ctr click, Cmd click, etc. but nothing happens.
Your help on this is very much appreciated!