Jump to content

FMRadio

Members
  • Content count

    15
  • Joined

  • Last visited

Community Reputation

0 Neutral

About FMRadio

  • Rank
    member
  1. Totalling fields from a related table?

    Fitch, sorry for the delay in responding. Crazy trail over here, I actually did not understand your suggestion, I did not have enough knowledge. So, as I so often do, I messed about and experimented. Thru a kind of accident I realized that I could (rather than above attempt) bring a remote, related table field into a calculation field and get the result I was looking for, a total of all the values of the records showing -all or a found set. So, in other words, exactly what you suggested in 'pipelining.' The accident was that I tried to sort a field that would not cooperate because the original database set it as text, I needed a number. So I setup the calculation field to 'massage' that data into a number so that it sort correctly. That's when I realized that I could now carry out a Summary action because the data was now local. You told me to go out in back of the house to find what I wanted, but apparently I had to go out behind the barn and keep digging until I reached the house.Some of us are kind of slow. :-) Bringing the related data to a local field for analysis works beautifully, with a few extra features thrown in. Thanks again for your help.
  2. Exporting Field Labels?

    Thank you.
  3. Can you export field labels from FileMaker? On import, you have the option to read the the first row as label or data, what about the other direction? Thank you.
  4. Totalling fields from a related table?

    Thanks for your response. I thought a picture might be worth a thousand words, or so they say. I uploaded a screenshot of the table Neighborhood. Basically, the table is an elaborate calculator, the idea being to find sets of properties based on some criteria and get total values at the bottom of the window. Those totals could be total square feet or a total of land values. The find criteria might be the block property is located on or one of the alternative rezoning proposals. In the screenshot, all of the fields shown are from the Neighborhood table, the primary table. The only exception is the field labeled Lot Area (Parcel :: ParcelArea) which comes from the related table Parcel. The Parcel# field, at the far left, is the field that links the two tables with property parcel number. At the bottom of screenshot in the footer is the field ParcelAreaTotal, in line with the field Lot Area (Parcel :: ParcelArea), where the totaled value is to be shown. As you have pointed out and as I have read, you cannot use a summary field for this operation. But, so far, my attempts at using a calculation field have failed. You can see that value in ParcelAreaTotal is not a total of the found list but is the value of the currently active record 9547200070. This is my central question, how do you use a calculation field in this situation to total a value located in another table? Thank you. Privacy: The information in the screenshot is not private data. Public data from the online county records and the properties shown are from a commercial developer.
  5. I am attempting to help my neighborhood organization with some land issues. I am using FM 11 on a Mac running OS Sierra. My primary database is Neighborhood and the related database is Parcel. Neighborhood and Parcel are joined by the field Parcel #. County parcel numbers are the ultimate identity of property, so each property parcel is an individual record in the Neighborhood table. Using the unique parcel number I am able to align the information from the two tables. Neighborhood is of my own creation and Parcel is provided by the county and since this is a major metropolitan area, it is quite large. Parcel has only one field I am interested in, ParcelArea., that contains the area of each piece of individual property, Parcel does not contain the individual property's address, while Neighborhood does. In Neighborhood, using this relationship, I am able to show the address, owner and other details of each piece of property, plus the area from the Parcel table. Using a list layout, I placed a Summary field in the footer that would tally what was showing in the list of individual property records, based on various search criteria. When I had the property field with the lot's area stored in Neighborhood, the Summary field, ParcelAreaTotal, worked fine. But when I switched designs, from internal data storage to an external, related table; the Summary field, ParcelAreaTotal, stopped working correctly. Instead of showing the total property area from a selected group of records, ParcelAreaTotal shows me the area of what is the currently selected record. I tried a number of options, failures all, my last attempt was using the function Sum ( EXTR_Parcel Converted::ParcelArea ) but this approach yielded the same outcome as before, whatever is the currently selected record. Judging by my repeated and varied efforts to get this to work and a bit of reading, I am clearly missing something obvious about total calculations and related tables. Thanks for any guidance.
  6. Well a bit morte valuable than 2 cents, as I get it now. Comment and you meant like a spread sheet. Columns are a language and rows are the individual search terms, English and the rest following in that row. Thanks.
  7. I thought that I would get notifications via email from replies to posts, here in the forums. I have an email address setup in my profile settings but I am not seeing any email notifications. What am I missing? Thanks.
  8. Comment, thank you. Not only does that work, suing your example, I have expended it to other languages. "But I do believe you should use one table for all foreign languages (if not one big flat table as explained earlier)." I did not go deeply into the user experience issues when I described my problem earlier. The layout I am using, first version rather primitive compared to where it is going, needs to focus on one language at a time. There are two reasons for this: one is the lack of screen real estate, I need avery tight, columnar list showing just one language and its English counterpart. The other reason is that I will be searching the web and other documents, one language at a time. Showing other languages would be distracting and get in the way. Really want to thank you again. I knew, in the back of mind, to take the approach you shared with me but like I said earlier I do not work in Filemaker often enough to keep the chops up to par. There was a day, but no longer. Its too bad because whenever I return to Filemaker my needs seem exceed my current ability. I do not care for a lot of Filemaker's interface design but it is one hell of a tool.
  9. "That makes no sense, because the two values must be the same in order for the two records to be related." Your question made me realize that I am in a bit of Catch-22. Let me explain more clearly: I will enter a number of search terms (record for each) related to privacy and identity in the English table. These will act as an anchor. I should also point out that I may not know the exact term in advance for another language, such as German, for English term. When I am in the German table (layout) I will create a new record, for a known German term, and then choose from the popup menu the matching English term. Until that point, there is no relationship but I do need to see the list in advance to make that happen. Thus, the Catch-22. I thought you could show a Value list in another table without requiring a relationship? "Will there be always only one German term corresponding to each English term? Or is it possible to have alternatives?" Yes, there will only be one German term and one English term matching. Some English terms may not have a German equivalent so they will not have a matching German record. No alternatives, but as I mentioned earlier, there will be other tables for other languages hooked to the English table. I will have buttons to switch between different layouts views to show them.
  10. Thanks Eos, done. Search_Term_Translation.fp7.zip
  11. I am writing a book about privacy and identity, as part of the research phase I am finding that I need several databases. I done OK, so far, but my attempts at creating relational database today has left me stumped. I am ashamed to admit that I have worked in Filemaker for sometime but it is not my regular gig and after returning, post long hiatus, I find I am not so familiar with my old friend. I have to search online for for various terms related to the subject, often in other languages. I have to keep pairs of search terms: English and other language. Paper lists are not cutting it anymore. Its quite possible my concept is flawed, if so, I am more than willing to change tack and redesign. Just started so no major marriage to first try. I created a table named "English" with one field, "English Term" and another table named "German" with one field, "German Term." I then linked the two tables together via those fields. I created a list layout named "English Terms" with a field for the various English terms and a field beside it for German equivalent from that related table. I also created a value list named "English Match" that gets its values from the "English Term" field in table, "English." I tested this list, it works. In a layout named "German" I have a field for the related English terms and it is setup with a popup menu to show those terms from the value list "English Match" and that field is supposed to show those values from "English" table. To the right of that field is the field for German term. The Problem: What is supposed to happen is I click on the "English Terms" field, while the German table, and get a choice of English search terms, pick one and then enter the German equivalent in other field. The goal would be that while English list I could see each matching German term. Once this works I would copy procedure for many other languages. It is not working, while in the German table the English terms field remains unresponsive, no popup menu list appears, so I am unable to choose. Fairly sure that this is a relationship problem of some kind. I am working Filemaker Pro Advanced version 8.0v1. I am on a Mac running Snow Leopard. Thanks for any guidance. Attempted to upload file but received the following error message: "Search_Term_Translation.fp7 You aren't permitted to upload this kind of file?"
  12. I am concatenating a name in a function and need to include quotes, tried the slash plus chacter following but that does not in Filemaker. What si the proper way to escape characters? Thanks.
  13. Thanks all. Vaughan, I will definitely be using your method for other applications. Comment, this is exactly what I was looking for, convenience at the time of paste. Not sure why I am not getting email notifications on my posts and replies... Thanks again.
  14. Sorry Vaughn, to be clear I want the pasted text from source to change to the setting in the Filemaker destination field. Under 'Field Behavior', I have the option enabled, 'Synchronize with Field's Font' but that is not doing it, not sure what that is for. Filemaker is atypical on a Mac, in that if you hold down the Option-Command or Shift-Option-Command keys with the V key or use the menu "Paste with Style" in other apps, text is pasted with the style of the destination field. I followed your instructions but not all of the formatting is being altered. It is changing the color but not the font style or size. Example: Original text Arial Black Bold 18 point Should be... Destination text Palatino Grey Regular 14 point BTW Anyone ever tell you that your avatar looks like Jack Nicholson?
  15. I have returned to Filemaker after some time and have forgotten how to insure that a field retains the font formatting when you paste from a copied source outside of Filemaker. Much faster and sometimes more accurate to paste, rather than retype, but every time I do this the field shows the font style from the source. Thanks in advance.
×

Important Information

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