Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jenna

  • Rank
  1. Jenna

    Portal question

    Never mind! I'm sorry. I just realized my mistake!!
  2. Jenna

    Portal question

    Hi everyone, I work for a magazine and have to calculate how much to pay each contributing author based on the length of his/her poem or article (this part I have working: I have a "Lines/Words" field where the user enters the number of lines [for poems, b/c we pay per line] or words [for articles, b/c we pay those authors by the word], and a script trigger on the field performs a script to see what "genre" is selected from the drop-down menu (basically, article or poem), then computes the payment for each piece and puts this number in an editable field called "piece payment." I need tha
  3. Oh my goodness, you've done it! Thank you a thousand times. If there were some way to mail you cookies without you having to post your address here, I totally would. Yay!
  4. Somehow I keep messing up! Here is my calculation for the Total Payable field. When the total for a poem is less than $40 (and the "piece_payment2" field reads, say "35"), the Total Payable returns "4035." Why would that be, do you think? Let ( total = Sum ( Con_ArticlessameIssue_Author::piece_payment2 ) ; Case ( total < 40 and genre = "Poetry" ; 40) & Case ( total < 100 and genre = "Fiction" or "Essay" or "Interview" or "Review" or "Non-classifiable" or "Play" or "Translation" ; 100) )
  5. Thank you, it does work fine. There is one thing I didn't mention, because I thought it would be easy for me to add once I knew the basic calculation--but now it is making me lose my mind. I'd like the total to be set to 40 if the total is less than 40 *and* if a certain value is selected from the drop-down menu. What I am doing is entering poems, essays, and short stories into a magazine's database to see how much we should pay each author, based on the length of their piece. If a poem is too short for the author to make $40 (at $1.50 per line), then we pay them the minimum $40. If an e
  6. Well, I think it's a related table. (I'm sorry, I started this project last year and it's hard to remember what I did.) It has the double colon before the field name, so it must be a related table.
  7. Hello everyone, I have a calculation field called "Total Payment" that I want to do two things: 1) Sum all the values of a certain field 2) Take that result and, if the result is less than 40, override the calculation and set the "Total Payment" field to 40. Is there a way to do this in the calculation field without having to write a script? Here is what I have as a calculation for the TotalPayable field. I don't know how to "attach" the two parts of the calculation: Sum(table:field); Case(TotalPayable < 40; “40”) Do I need to use more parentheses? Brackets? What do
  8. LaRetta, thank you! It's a long story why the summary is based on the description field instead of another one, but you were absolutely right that the layout had to be based on the Payment table!! I thought it would be fine to pull the summary field, etc. from a related table--but now I see that the layout should be *set* to that table in the first place! Thank you!!
  9. Dear Omega, Thank you for taking the time to explain this. I'm still having trouble, though. Whenever I add a total to my table, whether I set it to give me a running total or a sum total of all the records, it doesn't do any summing. Instead, it simply spits out, one after another, whatever number is in the field it is supposed to be summing. I'll attach my file so you can see. Click on any of the "Check Deposit Log" buttons. That's where the problem is. (Basically, we enter fiction, poetry, and nonfiction contest submission on the other pages, and then we generate a check deposit l
  10. Hi, All I want to do is summarize the numbers in one field of a found set. When a user clicks a certain button on one of my layouts, a script is executed that: 1. Goes to another layout--a Table View only layout 2. Sorts records by date This new layout has a column called "Payment Amount" with all number values. I added a Summary field to the table called "Total" whose options are set to Total the Payment Amount. But when I add a Trailing Grand Summary to the layout and put the Total field in it, it doesn't work at all. In browse mode, it just says "Total." I feel like i
  11. Yes, thank you! Clearly I need to read more about FMP functions and practice my script-writing. Thanks for taking the time!
  12. Thanks, everyone...I'd like to do what you suggest, efen, but even with the auto-enter calculation I can't get it to put the X in the box at the correct time. I'd like it to put the X in the "subscription" box whenever any item *except* "entry fee" is selected from the "payment description" pop-up menu. I think I'm confused about how the calculation and script interact... I attached the file, in case you have a minute to look at it. Thank you!!! contest.fp7.zip
  13. Hello, In my database, there's a drop-down menu where the user can select various options--say, A, B, C, or D. I am trying to write a script that puts an X in a different edit field/checkbox IF the user selects B, C, or D (not A) in the drop-down. Every time I write the script, it puts an X in the box regardless of what I've chosen (even if it's A). My script is simple: If [Field name="B" or "C" or "D"] Set Field [Field name; "X"] End If Do I have to do something different when working with value lists? Is there a special function I should be using? Thank you!
  14. Hello helpful people, I manage a few different FMP databases and have noticed that when I "View as Table" or create a report, only one of the related records tied to a given record is displayed (the earliest entered one, I think). For instance, I have a table for "customers" and another for "checks received." It is a one-to-many relationship, since some customers divide their one-time payment into more than one check (it's a long story). On the main layout where I enter the data, I have a portal to the "checks received" table, and that's where I enter the different checks (their amounts,
  15. Thanks! I solved the problem by moving text around, but this is very good to know.
  • Create New...

Important Information

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