Jump to content

ShannonM

Members
  • Content Count

    22
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ShannonM

  • Rank
    novice
  1. Hello, I have a printing problem that I cannot figure out. I have a report that contains a Header, 3 Subsummary parts and a Body. The Header and first two Subsummary parts feature text and one merge field that consistently only take up one line each. Now, the third Subsummary part contains varying amounts of data and often has to extend beyond the first page boundary. Similarly, the Body part varies in length and often extends beyond the second page limit. I have selected all of the appropriate sliding/printing options (sliding up based on all above, also reduce the size of
  2. Hello, I am looking for help with what I thought would be a fairly simple text formatting calculation. I have a text field (originalGenus) that typically has italics applied to it. I have now come across some cases where I need the italics to be removed from certain characters within the field. For example, typically the field is populated with the text "Genus". In some cases, it contains "Genus (Subgenus)". Now, I need both, genus and subgenus to be italicized, but not the brackets. This field is subsequently used in other calculation fields to format a complicated o
  3. Does this mean that I am out of luck using a PC? "Custom colours" are created when you choose the 'other colours' option at the bottom of the colour palette. There are blank boxes where you can add your own colours. These boxes seem to reset each time you close the program though.
  4. Hello, I regularly use custom colors on my layouts. Each time I exit the program, I lose all of the custom colors I had previously set. Does anyone know if there is a way to save or store these custom colors between sessions? It is so frustrating to have to set them all up each time I open FileMaker. Thanks!
  5. I know there are quite a few threads regarding this topic, but I can't seem to find exactly what I am looking for. I have database of 1000+ records of different species of flies. I have created a layout that prints out a PDF in a catalogue format. That is, all species are grouped under their appropriate family , tribe & genus names (using subsummary parts). The indenting and formatting is very critical for a catalogue, so I would like to retain this. It comes out nicely when I print to a PDF, however, I need it as a Word document (which the PDF doesn't convert to properly, obv
  6. I am attempting to get a lookup field to input multiple values for a single record. I have a main table that contains information about species (each record represents a single species). Each species has a distribution. The distribution is selected from a Country field (which is a series of checkboxes). I have another table (Country table) that lists all the possible country names and their abbreviations. The main table & country table are linked by a unique country ID#. I want to have a lookup field in the main table that will have the country abbrevations (data from Country t
  7. Hello, I am wondering if anyone knows of any FileMaker training being offered in Ottawa. The main company that provides courses in Ottawa, Montreal, and Toronto had to cancel there most recent Ottawa classes due to lack of registered participants. I am desperate for intermediate to advanced training (user & developer). Does anyone have any suggestions? Thanks - Shannon
  8. Hello, I am attempting to create a calculation that allows me to replace specified occurrences of a search string. For example, say I have a field that contains a list of names: John, Sarah, Henry, John, Chris, David, John, Mary. I want to be able to substitute the second and third occurences of "John" with the text: "John(duplicate)". I hope this is clear enough. Thanks in advance!
  9. Hi, I am having a problem with a calculation involving an IF function. I want the IF statement to be based on whether or not a field contains a specific value. However, I am having trouble differentiating between the field containing just that value vs. that value along with other values. The field in question is based on a value list of countries. The beginning of my IF statement is: If(CountryName="Canada";" CA"). For most records the CountryName field contains many different countries, not just "Canada" alone. I want the calculation to work on any record that has "C
  10. Hi, I am having a problem with a calculation involving an IF function. I want the IF statement to be based on whether or not a field contains a specific value. However, I am having trouble differentiating between the field containing just that value vs. that value along with other values. The field in question is based on a value list of countries. The beginning of my IF statement is: If(CountryName="Canada";"CA"). For most records the CountryName field contains many different countries, not just "Canada" alone. I want the calculation to work on any record that has "
  11. Ok, I have yet another calculation that is stumping me. I have a checkbox set of provinces. I have created a calculation field (with the help of the some wonderful people here) that outputs the selected provinces with a specific format, in an alphabetically ordered list separated by commas. So - for a record with Ontario, Quebec, and Manitoba selected - the calculation field for the desired output would be "Canada (Manitoba, Ontario, Quebec)." Now, I need to create a new calculation field which will take "Ontario" (when it is selected) and remove it from the list and put it at
  12. Thanks, that was exactly my problem! Thanks again - I am going to have to start splitting my salary with you! :P
  13. Thanks for your help. I copied exactly what you did but I am getting "," as a result.
  14. Hi there, For some reason when I view my layout in preview mode a large blank space appears under my header. I have a header, three subsummary parts and then the body. Each part is set to just the size of the field, yet when I switch to the preview mode a large space appears between the header and the first subsummary part. I have played around with the sliding, etc...but it makes no difference. I have even created a brand new layout, adding each part over again and then when I am done and view in preview, there is that stupid blank space again! Oh, and I should note that on
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.