Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About scchoi

  • Rank
  1. Currently I'm working to create a script that will help me navigate from my default page to other layouts with certain conditions. So I've created a field where I calculated the number of records sorted by a category (type) My goal here is to have a script with the following conditions: - If only one stamp is found, show in detail view - If more than one stamp is found, show in list view - If there are no stamps for that type, alert the user and stay on Dashboard layout so currently i have something along the lines of : the screen shot attached. Suggestions on how to proceed? Do I need to set variables here? edit: sorry move go to related record so that it's placed ontop of end if
  2. Hi, it eventually worked for me! I think the problem was that I had an unrelated table... this is probably my fault for complicating things too much. But anyways, thanks a lot! Appreciate it.
  3. The relationships are just there for my note, since this is my first database that I'm building from scratch. A lot of the things are tests and trial. Which ones do you have question about? I'm still coming off as a blank I'd have attached ac ouple more screen shot for you to get a better idea of where I'm getting at. The first one is the detail of the stamps. Bottom right of it is where the Type is indicated per stamp (under _kf_Type) The second one is a snapshot of of my home table, where it might be confusing to you. I needed to create a two calculation fields for the TOTAL NUMBER OF RECORDS (STAMPS) and the TOTAL VALUE OF STAMPS so I used the a relation to accomplish this. Any other methods I tried prior to this proved futile. My 3rd snapshot is a picture of how I did my graph. I used a script and looping technique to set the variables of x and y.... I don't know if I can somehow relate this to my function that I'm trying to make but I just put it there as reference anyways.
  4. I'm still struggling to get it to work. I'll show you a screen shot of what I'm talking about. In my example, its slightly different in the category (I just use a sport analogy cause It's easier to understand I guess?) Just replace: Category with Type Team with Stamps and Home still = Home I've posted my relationship, layout, and fields that I feel applies to my question. look at the second screen shot, and see how my bottom left portal displays the type name but not the number of stamps in each type? in other words, it should reflect the Chart's number in correspondence to the the number of stamps per type.
  5. It's one team for one category. So my relationship goes something like this: Home_Team_Sports and each team is assigned a certain sport. what i'm doing is creating a function where i count the number of teams per sport and having that number displayed. I'm not so sure if I should use a calculation or summary field here, or if i ned a script. I used a summary calc field and got the portal to display the category (in this case it's 11) but on the side of the category, instead of displaying idfferet numbers it shows 11 for all; so it's counting up all the categories instead of counting up the records related to the category. hope that makes sense.
  6. Hello, I have a question on how to create a field with the calculation (or any other suggestions) that would display a field in my database that shows a list where i'll have the number of items per category. In other words, let's say I have 3 different tables. table 1: default home page table 2: lists of sports table 3: sports team in my default home page, i have a portal shows the sports team on left column and the lists of sports the team is apart of. now what I want to do is instead of showing the sports team on the left column, i want a field that counts the number of teams in each sports. IE: Number of Teams Sports Category 4 Basketball 5 Football 2 Baseball 3 Hockey Note that each teams are given a separate sports category already from their respected tables/fields such as a relationship between Category and Teams.
  7. scchoi

    Creating a Chart in Home Layout

    hey guys, I'm trying to create a homepage that display a chart of my records. for example let's say i got a record full of basketball cards. basketball cards have their own entire different table with the fields basketball cards name, year, price, etc. and then i have another table that lists the basketball cards according to their team. in other words, it's a table that has perhaps, a list of entire team and an ID for each team. what i did was i have a relationship BasketballCards to BasketballCards_Teams If I want to create a chart in my home page which has a designated table of its own (a home table) that shows how many cards there are per teams, how would i go about in doing so? Or in other words: I have my Data from X-axis (the teams) and the Data from Y-axis (the cards) and I want to show how many cards there are per teams in my collection. I got the two data, but how do I create a script that'll link them together and then put that script within my chart? Any examples? or links to examples that I can work from? Thanks FMForum!, scchoi
  8. Hello FMFileMaker, So here's my dilemma: I imported the data into my database. The following database has a STAMP Table with a list of stamps with primary keys. Each stamp in addition is given a FOREIGN key. This FOREIGN key is labeld as a _kf_Type (as in, the type that the stamp is categorized by ie: Type 1A, blue.. Type 2A red, etc...) In my TYPE Table, I manually entered the Type according to the Primiary Key. IE: _kp_TypeID is 1000 Type name is Type A1, Brown _kf_StampID is 1 Now what I want to do is some how show on he detail layout of each stamp the TYPE that corresponds to the stamp. All iI'm getting is the _kf_StampID number which is what I originally imported into the database from excel. For example let's say one of the stamp has the _kp_Type of 1, I want it to display Type A1, Brown instead of "1". Thanks in advance for your input
  9. Hello FMForums, I have a question in regards to creating a layout that lists a series of type. Let's say, there's a Table for a Type and there's another table for Stamps. In relation between the two tables, one Stamp is labeled as a certain Type. Is it possible to create a layout having the Type as the main table and then what happens is, I will have a Type, followed by a list of stamps that has been designated/labeled as that Type? (For example: Similar to a sub-summary or would using sub-summary be the best option? Thanks, scchoi
  10. The cartesian worked! thanks!
  11. scchoi

    Delete post please!

    Thank you! Sorry, I was trying it on FileMaker Go... and I got thrown off for the day. Plus I'm fighting an extremely bad cold. Maybe I should take some time to rest...
  12. scchoi

    Delete post please!

    Sorry, but I wasn't thinking straight. Obvious answer to something that was basic/fundamental. Please delete post!
  13. Hi Bcooney, I've tried that but my field is not producing any answers. Perhaps my relationship is wrong? Can you critique my relationship. I posted a screen shot of the relationship below. I'm displaying data from Home::Count_Stamps and the calculation field is Count ( HOM_Stamp::__kp_StampID ) Best regards, scchoi
  14. Edit: Sorry but I realized this might be more fitting underneath the functions section of the forum... my apologizes. Hello FM Forum, Long story short, I'm fairly new to FileMaker and I'm trying to create a database from scratch. At the moment, I have 5 tables. Stamp, Album, Type, Collection, and Home. For my layouts, I have a Stamp_List, Stamp_Detail that are based off of Stamp table, Album_List that is based off of Album table, Type_List based off of Type table, and Default_Home (which is basically an utility layout that is based off Home table and has no fields at the moment) What I want to do is create a function to counts the total number of records in the Stamp table. That is my database is a collection of Stamps and I want the default home page to show that number of records. Previously, I used the Get(TotalRecordCount) when my Default_Home was based off the Stamp table but I figured that wouldn't be in my interests when I need to do other stuff for default_home. In addition, I would like to add a field or function where I can see the total value of the stamp collection. (this is another field within the Stamp table) and create a chart for the Types of stamps (a field in the Type table). I'd greatly appreciate your inputs on the best approach to these scenarios! Thanks, scchoi
  15. I removed the "#!/bin/sh" should that not of made a difference for Windows? The settings were all correct, I checked time and time again that the privileges were given full the custom access. Using iRepair, I gave the Owner, Group, and Others full access with "Exec." in addition to setting it 777 under fmserver / fmsadmin.

Important Information

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