Recently Written- Lion, iCloud, and Bento… October 25, 2011
- Bento 4.06 Available October 1, 2011
- Bento Price Drop Confirmed! August 23, 2011
- Bento 4.0.5 Available! August 9, 2011
- It’s Confirmed: Lion Is Fighting Bento! August 1, 2011
- Bento 4.0.3 Update Is Unstable May 21, 2011
- Customizing Themes Even Further April 23, 2011
- Sorely Needed: Page Guides On Forms! April 23, 2011
- List Field Refinements Needed April 12, 2011
- Dear Filemaker & Bento Product Manager: April 11, 2011
- New Free Service: iChat Screen-Sharing! April 10, 2011
- Bento 4 Crashes Reach BentoUsers! March 17, 2011
- Finally: Bento 4 – First Review! March 16, 2011
- Bento Black-Friday Pricing! November 26, 2010
- Important Software Update – Bento 3.0.5 November 4, 2010
Mar
2
Please Note: For more details about using Related Records Lists please refer to the article, ‘Related Records Lists’.
When you create a Related records List on a form it will inherit and use the fields currently displayed in the Table view of the source Library. However, if you want to change the fields which are displayed you can simply click on the Related Records List in the form and you will notice that the list of fields changes from showing the fields in the current Library to showing the fields in the Library which the Related Records List is based upon. This allows you to not just select and deselect the fields but you can also rename the fields (but note that the field in the originating Library will also be renamed).
It is also possible to re-order the fields in a Related Records List by clicking on the field name and dragging it to where you want that field to be.
Thanks to beachgrrrl over at the Bento™ forums for this tip.
Mar
2
Using Checkboxes In Calculations
Filed Under Bento Tips | 6 Comments
Although it may not be immediately obvious it is possible to implement some basic logic and conditional calculations in Bento.
Assume, for example, that you want to keep track of sales, some of which have tax added to them and some of which do not. The easiest way to differentiate between the two is by using a checkbox and fortunately the the state of a checkbox is stored internally by Bento as a 1 or 0.
To re-create the above example you will need to create four fields.
1. An Amount field which in the example is formatted as a currency field.
2. A CheckBox which here is called Taxable.
3. A Calculation field which is called Tax Amount in this example. The formula is simply [Amount] * 0.175. This effectively populates the field with the tax amount for the total. The value is 0.175 because here in the UK the VAT rate is 17.5% so multiplying an amount by 0.175 adds 17.5%. The field is formatted as Currency just because it looks better if it is going to displayed anywhere.
4. A Calculation field called Total. This consists of [Amount] + ([Taxable] * [Tax Amount]). This is formatted as Currency.
Mar
2
Bento™ can make use of iCal and Address Book data and this is one of the strengths and selling points of the application. However this area could do with some additional explanation as there are some potential issues which you should be aware of.
Read more
Mar
2
Multiple Library Collections
Filed Under Bento Tips | 2 Comments
If you need to use two or more independent and separate Bento™ collections of Libraries, create another user
account on your Mac. Each new account has its own Bento data file stored in the Application Support folder in the user’s Library folder.
This tip was submitted by Jon Longworth (aka Jade in the Bento™ forums).
You can also simply copy or rename the bento.bentodb file in your user’s Library/Application Support/Bento folder and when you next start Bento it will create a new one. However, please ensure that Bento is not running when you attempt this.
In the screen-shot below you can see that I have three Bento files, each containing their own collection of Libraries: my personal Libraries, Libraries to do with work and Libraries used for examples for this site.
Mar
2
Storing Media By Alias
Filed Under Bento Tips | Leave a Comment
A Media filed can be used to store images, movies and sound files. The default behaviour is that when you drag and drop a file onto a Media field you store a copy of the actual file in your Bento database. Obviously this can lead to the database file becoming very large very quickly so an alternative is to hold down the Option (⌥) key when you drag a file onto a Media field. This stores the file’s alias, a link to the file rather than the file itself, which is around 4k in size, almost insignificant.
This tip was submitted by Jon Longworth (aka Jade in the Bento™ forums).