searson1 Posted September 24, 2006 Share Posted September 24, 2006 OK, whilst I am here, I may as well try and push my luck a bit. I have setup a layout that will show everyones email address. However, the results also include empty fields of people who do not have email addresses. How can I achieve only showing results that actually have email addressess entered in my email fields? Did that make sense. Link to comment Share on other sites More sharing options...
bcooney Posted September 24, 2006 Share Posted September 24, 2006 the easy answer is to do a find where email address is empty (just put "=" into the email address field, click Omit and do the find). Link to comment Share on other sites More sharing options...
comment Posted September 25, 2006 Share Posted September 25, 2006 What happened to "*"? Link to comment Share on other sites More sharing options...
searson1 Posted September 25, 2006 Author Share Posted September 25, 2006 It would sure be a lot easier to understand how all these things worked if I had a database that was already done and dusted that I could take apart and see how it worked. I have several Filemaker Pro Books, which are great for things like design, layouts etc etc etc, however, getting to grips with things like scripts and calculations does make my brain throb!!! lol. I tend to forget that not everyone has the same design and requirements as me. Does anyone out there have a database that is concerned with church membership and stuff like that I could take a good look at? That would be cool. I feel such a dunce when I ask what must seem to you good folks are stupid questions. Though I do appreciate the replies and help everyone has given me. Mark Mark Link to comment Share on other sites More sharing options...
Genx Posted September 25, 2006 Share Posted September 25, 2006 Well, the sample solutions (the bulk of them anyway) are generally too hard for "semi-first timers" to pull apart at first. Start with the FM samples provided with FileMaker and work your way up -- things will make sense a lot quicker. In terms of comment's suggestion, of using the "*", the asterix (if that is in fact how you spell it) is simply a "wild card" character and when used alone will retrieve all records that have any content in that particular field. As usual, though i know like most people knew to FM, you might not want to read things and you want to get right on in there, you may save yourself a lot of time by reading a couple of free whitepapers (just search the forums, i forget who does them but the Novice whitepaper is good). Search the forums. Anywho, it's hard to find specialised databases that will instantly suite your purpose, but in most cases, there are only broad categories of databases where a small bit of customization can go a long way. Righto, any questions, just yell. Link to comment Share on other sites More sharing options...
comment Posted September 25, 2006 Share Posted September 25, 2006 The * symbol is called 'asterisk'. Asterix is a French comic-book character (or perhaps an attack of emotional excess in certain parts of London?). Link to comment Share on other sites More sharing options...
Genx Posted September 26, 2006 Share Posted September 26, 2006 Lol, awesome. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6514 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now