David_Grove - profile

David_Grove · Sep 06, 2020

I wanted to make the primary field of a table into a link to another table. (Like using a foreign key as part of a primary key in a database.) Of course, I immediately discovered that was not allowed. So, I created a new field, made it a link, the...

David_Grove · Sep 01, 2020

I am creating a catalog of sheet music for some musical groups I play in. It has a main table with all the usual information to be expected (title, composer, arranger, etc.) plus some additional info, such as alias names and associated works or titl...

David_Grove · Aug 29, 2020

I have two fields in a table for a sheet music library: Last Name and Given Names. Is there a formula expression that will produce the initials for the given names? For example, If the Given Names field is just “Johann”, I would like to produce the s...

David_Grove · Sep 06, 2020

I figured that was why. And, it makes sense. But, then why not put quotes around every text string, uncondittionally? That would be a way to preserve the ability to create sorts on that field that continue to work. The way it worked for me was, t...

David_Grove · Sep 01, 2020

Thank you. Yes, a filter is a way to accomplish this, but requires knowing about the structure of the table, and how to explicitly set up a Boolean expression. But, even that is only cursory, since the Boolean expression permitted by a filter is so ...

David_Grove · Sep 01, 2020

So, the bottom line is that there is no way to do this with the free version, is that right? Thank you. DG

David_Grove · Sep 01, 2020

Thank you all, for your helpful responses. Initially, before posting, I had considered Rebecca_Elam’s idea. However, I didn’t know how to deal with an unknown number of names (and I am just a private user creating my own personal sheet music library...

User Statistics

User Activity

Using a text field containing comma(s) as part of a formula

How to supply parameters to filter a view?

Extract Initials for Given Names

Re: Using a text field containing comma(s) as part of a formula

Re: How to supply parameters to filter a view?

Re: How to supply parameters to filter a view?

Re: Extract Initials for Given Names