What you can do however, is to select multiple items and apply formatting to them as a group

Which would work even better with a Format Painter 

Am I right in remembering that Conditional Formating is planned as well?

A couple of quick questions:

• Do you have a page that explains the field set up screen? There were some options there that don't seem to be used by the default database.
• Is there a File Requester that can be attached to a field (that is a path type)? Or is drag and drop a possibility? I know you can drop onto the grid and a new record will be created, but it'd be handy to be able to fill specific fields.
• Any thought about having child grids that are different to the parent (similar to how Access will display a related table), so for example you could have an invoice grid with children that are invoice items that display a different set of fields??

I made a new grid for another artist "Gene Harris" using the same fields as before "MusicItem".  I imported all the items and organized them.  Then I tried to have the new grid show only the Gene Harris items, but I can't seem to get that top bar filter to do anything for me.  Whenever I try, i get the big red error bar on the bottom.  How can i only show the Gene Harris items?  (see attached screenshot)


Also, let's say I have a bunch of items using the MusicItem field, but I in the grid, i only want to show certain specific albums that have no real logic to it.  Say, some of this artist, some of that artist, but nothing I can put a "rule" or filter for.  How can I pick and choose what is displayed?  It seems to me like you can't manually pick and choose, everything has to be formally defined by fields and filters.  Am I right?

1. You're not too far. In your filter, you must say which field to filter:
MusicItem="Gene harris". You can also use the Alpha toolbar: MusicItem and click the G or type Gene in the associated text box
2. You can use the Check field (or another). Simply check the items you want and set the source (or filter) to Check

1)  It still doesn't work for me.  There are 3 places to type in the bar, and none of them worked.  I opened up the alpha toolbar and type "gene", but you see how my top-level item is "Gene Harris"?  It only filtered the sub items and only the albums that had the words "gene harris" in the album title, which is only a few of them.  How come it doesn't show everything under Gene Harris since the top level matches the filter?
2)  Here's the problem with the check.  The check box would just be another field right?  What if I have thousands of artists and I want to have several grids showing a different collection of artists.  Do I have to make a separate check box field for each grid?  Because, if I understand correctly, the check box field (and it's state of checked/unchecked) will be stored with the item itself.  So, for one grid, it will be checked, and for another it needs to be unchecked.

Is there any plans to have a more "manual" way of showing what appears in the grid?  I mean, it's very powerful to have the filters there for situations where your selection can be defined by logical means (all albums which this artist appears on, all albums made after 1995, etc.).  But what if you want to make some grids based on purely arbitrary and random choices?  I understand that all the items are stored in the database and the grids only display what you want to see from that database.  Is there a way (now or planned for the future) to be able to pick and choose individual, random items from the database pool and stick it inside a grid?

2 pages were added to the wikispace:

1- How to use SQLNotes fields
2- How to import data from other programs (in particular Outlook) into SQLNotes

http://sqlnotes.wikispaces.com/

This feature will be added. Currently, you can do with in Field Properties:
1- Select the item field
2- In Equation enter = MusicItem
3- Click Update
4- Remove the equation from the Equation field
5- Close the Field Properties dialog.

All... This is not what you want to do?

All... This is not what you want to do?

Well, in this case it works.  But I only want to copy the musicitems for these particular items, not the entire database.  What if I had another grid somewhere and I'm using both the MusicItem AND the Item fields?  Then I don't want one to overwrite the other.  I just want to copy/paste for a selected few.


Oh!  I forgot about one of my favorite feature requests...
Will there be a way to password-protect certain items/grids/databases?  Let's say I wanted to keep an outline of personal information, and I wanted to protect a couple of items that had a password, could I do that?  Similarly, I might want to add protection to individual grids or even an entire database.

Zoot allows you to password-protect the database.  Mybase allows pretty good flexibility in that you can protect the individual notes with a password, and you can also protect the whole database file with another password.  I talked about these in my notetaking review a little.

I think I found a bug:
In the Options, where it says "Create backup on program close", I keep changing it to "Yes" and it keeps going back to No.  That's why I didn't have backups saved that one time.  The setting doesn't stick.

confirmed, I'm working on it right now

Yes, more formats will be added, but if tab-delimited does not work, can you try comma separated ?

I'd be interesting to determine if it's Outlook that can't generate properly formatted tab and csv delimited files or SQLNotes that doesn't read them correctly...

I'd be interesting to determine if it's Outlook that can't generate properly formatted tab and csv delimited files or SQLNotes that doesn't read them correctly...

My feeling is that it's Outlook's that's improper. When I open the csv (or tcv)  text file I can clearly see that some fields are just not where they should be (especially the "notes" field, it seems -- when you open an Outlook contact, that field actually doesn't have any name!)