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 that field to be editable (and not a calculation field) because sometimes we make special arrangements and pay authors something different from what the length of their piece would indicate.) Okay, so the hard part is that some authors have more than one piece in each issue, and I want to have a "payment history" portal that lists all pieces a particular author has ever written for us, along with how much we paid for each piece. But the "piece payment" field in the portal only works correctly when there is only one piece per author per issue. When there is more than one piece, the *same payment* (the payment for whatever piece is at the top of the portal list) shows up for *all* the pieces. This only happens in the portal. Also, when I click out of the portal and scroll through the records (some 1000), the payment field disappears from the portal. It only comes back when I go to one of the records that appears in that portal. Does anyone have any idea what is going on here? Why is FMP only computing the payments when the particular record is active? Can't it store the payment/tie it to the record so that it appears in the "payment history" portal? Thank you!
  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 essay or story is too short for the author to make $100 (.08 cents a word), then we pay them the minimum $100. I've already written the individual payment calculation scripts (to calculate the $1.50 per line and .08 cents a word). Now, I need FMP to put a "40" in the total payment field only if "poetry" is selected from the drop-down menu (and the total is less than 40). Likewise, it should put a "100" if "not poetry" is selected from the drop-down (which contains a lot of "not poetry" value list items) and if that total is less than $100. I tried adding to your calculation, & table:genre_field = "Poetry" But it didn't work. I'm sorry for being such a pain. You're so kind to help me!
  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 I use instead of the semicolon? Thank you!
  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 log for each genre when it is time to deposit the contest submission fees.) I know that the "Payment Description" field (which the summary field is set to calculate) has text and numbers in it, but even when it was an edit field set to "number," this happened. Any idea??? DB_summary.fp7.zip
  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 it should be very simple to summarize the values of one field in a given found set--what am I doing wrong??
  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, numbers, etc.) I made it so that I can enter up to four checks (check records) in the portal. When in Form View, of course I can look at the portal and see that John Jones paid with two checks (and what the amount and check # of each was), but when I switch to Table View (or make a report), all that appears with his contact information is his oldest check record. I want to see all of them, the same way I do in Form View (only as a spreadsheet/report, each check record in its own row). Is there a setting I'm missing? It seems like this should be easy, a matter of adjusting FMP preferences, but I can't figure it out. Anybody know? Thanks!
  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.