Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About FiMaRookie

  • Rank
  1. I want to make a column of pop up fields that one could scroll up and down, so only the first few fields are immediately displayed (like a portal). The only scrollable fields I can find with google say to use a edit box, as in writing text in the field/box, but I want separate fields. is this possible? Say I want to log the top 10 times in a track & field race, plugged into 10 separate fields, but i only want the first 3 immediately displayed, then one has to scroll below them to see the next 7.
  2. I've never use scripts or anything beyond the pretty basic functions in FM. I found an old thread (which I will paste at the bottom) in which I'm pretty sure I found the answer to my question, but can someone walk me through and explain how to execute the directions? Again, my question is: how do I import from excel into portal fields? In FM, I have a "Research Notes" table with a portal field to "People Names", and I have a join table "Research Notes_People Names" with "People ID" and "Research Notes ID" fields. In excel, I have some old "Research Notes" that I want to import to FM,
  3. ok thank you. i've never used FM before so I wasn't really familiar with the Arrange & Align tools on the Inspector. Thx!
  4. How come whenever I set up a portal it automatically just makes the fields tack on horizontally? like 1,2,3,4,5,6,7,8,9 in a row? hwo can I make it look like this instead: 1,2,3 4,5,6 7,8,9 Also, is there a way to lock portal fields? i only want them to display the values, i dont want them to be edit-able from the other table that im viewing them in. It seems like regular fields have options that are "locked" or uneditable....the only reason i went with a portal was because you can make multiple at once, and simply "move" all the fields you want. but is there a w
  5. Ok, thank you all for your replies! Yeah, right now I have primary keys for every table of Category fields. (so about 5 or 6). And I Just have relationships between all 5 or 6 and the table where I want them displayed. I will go back and restructure as you guys have suggested...
  6. ...yes, 10,000 total records. However, I entered the categories as fields NOT records. And I split up the categories into several tables of about 20 fields each. What's a "data join table"? I don't even have a subjects table per say, since all the data for each category was entered in the appropriate order corresponding to subjects #1-100, so I simply added an "indexed, auto-serial ID# field" to every table, which essentially is the subject column. I also use the "indexed, auto-serial ID#" to join the related tables. The relationships have been set, and they work when I teste
  7. It's 100 x 100. 100 subjects, 100 categories, 100 pieces of data in each category (each corresponding to 1 subject) I know I could probably compile all the data into one master field, then play around with the serial ID#'s to make sure the display fields show correct data (i.e. show the 1st, 101st, 201st, 301st, etc. values from the master field when I want to see the data corresponding to subject #1). But ideally I just find a way to run this calc/function for all the fields quickly, since I do like having all the categories of data separated.
  8. ok nevermind I found how to format to general. however, i think i read somewhere that filemaker's default setting converts to scientific notation if the number is bigger than 10^9 or smaller than 10^-9 and ideally I'd like this to be like 10^5 to 10^-5 sicne I have so many fields that I want to fit in one page
  9. I want to run a simple function/calc "If ( Length (number) > 4 ; ScientificNotation ( number ; 2 ) ; number )" where SciNotation changes the value to Scientific Notation to 2 decimal places. I have hundreds of fields of data. Each field represent a different category of data. There are also about 100 subjects (therefore 100 records for each field), so I want to more or less display the one piece of data from each field (via portals or value lists) that corresponds to whatever subject I happen to pull up. Anyway, I'm very much a beginner. So right now my impression is that I
  10. Thanks for the reply! Yeah, it was pretty simple that works perfectly. Now I'm wondering if there's a quicker way of running this function rather than going one by one for every field ( i have over a hundred, lol).
  11. How do I change it to general? Hey Vaughan, thanks for the reply. u'll notice I basically deleted my original question because I more or less figured it out, simply incorporated an "if" calculation, "length" (# of characters in text) is > 5, then run the Scientific Notation function. However, you bring up a good point. I suppose it would be ideal to preserve the original value, but change the display (although for my purposes it is not absolutely imperative that I do so).
  12. I have over a hundred fields of data. I put together a custom function/calculation that will convert all values with 5 or more characters into scientific notation. Right now, I'm just going one by one, converting all the fields into calculations, and plugging in this function and replacing the "number" parameter with the name of the field. Is there a quicker way to accomplish this? Obviously if I compiled all the data into one field i woudl only have to run the function once.... I have it separated into diff fields according to categories, but I suppose if I just keep a record/key of
  • Create New...

Important Information

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