Jump to content

dwins

Members
  • Posts

    63
  • Joined

  • Last visited

dwins's Achievements

Contributor

Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. Poor man's popup. This can also be done with one calculation field and one script. The calc field generates the next 52 Sunday dates from the current date forward, each separated by a return. The script takes the value in that field where the cursor resides and places that value in another field. I have a publication that runs on Thursdays. To set date for an ad or subscription you click on the date field, a button. If date field is empty, a list of dates appears, click on your choice, click date field again, the date is set. If date field is not empty, it is selected for editing.
  2. Your're forgetting to not listen to novices like me. Go back to Rod's or Jeeps suggestion. I thought I could help as I do this regularly with other field types and thought I had done it also with containers but evidently not. Sorry.
  3. A script can extract, or act on, a particular value, where the cursor is placed in a block of text.
  4. Stack the containers on top of each other, make them unenterable, hide them under a rectangle object that can form the background of your other fields, buttons, etc. You then enter each container with a script thus bringing it to the fore displaying its content.
  5. JPEG, PICT print good for me - TIFF, PDF do not.
  6. I would take Fitch's suggestion a step further and have one view/print page to a layout - 15 layouts. Nothing faster than clicking from page to page, nothing slower than trying to scroll around when it's spread over 110 inches. And you design where the page breaks are, etc. However, if you're dead set on one layout you could miniaturize everything then set your Page Setup to 150, or whatever, percent.
  7. This doesn't address SimpleChart. But the graph you want is only four points. Note that if a bar graph would be suitable, one can be made easily with a calculation field. Let ( a = "llllllllllllllllllllllllllllllllllllllllllllllllll" ; Left ( a ; 300mV ) &¶& Left ( a ; 5V ) &¶& Left ( a ; 7V ) &¶& Left ( a ; 10V ) ) Depending on font, a lower "L", or any character, can be used, field can be rotated, and about 3 or 4 stacked should make bars solid. Among variations: Multiple bar graphs can be stacked, a chart can be made of multiple records. A point chart can be made using spaces &"•". A curve can be made by tightly spacing many points. A line graph can be made by adding formulas between your results that break the difference into equal parts. You'd need lots to make the line smooth. I've not done this one myself, but one calculation is cheaper than a plugin. Of course how this displays depends on the font so you want to be careful if it goes on different computers.
  8. Base the value list on a calculation field. Case ( completed = "Open" ; name )
  9. or: number * .01 * ( 100 - GetAsNumber ( popup ) )
  10. A similar problem solved by the Fenton #2. 100 businesses that sponsor an ad are all billed at once. Scrip, here shortened, creates one ORDER for each ACCOUNT (child and parent). Go to Layout ORDERS Show All Records Show Omitted Only //this hides all records so in the end you view only the new ones Go to Layout ACCOUNTS Perform Find //to get the 100 parent records you need. Go to Record First Loop Set Field gHolder;Pkey //you'd use variable here Go to Layout ORDERS New Record Set Field Fkey;gHolder Set Fields with the data you want on the record Go to Layout ACCOUNTS Go to Record Next Exit after last End Loop Go to Layout ORDERS Data for the records is held in proxie globals. Accounts to be Billed are checked "X," then changed to "B" in the Loop. For safety the script will exit if it hits a B. B's are kept for further script action then cleared with a button.
  11. This formula rounds positive numbers up. Let ( [ a = 234.000003 ; //number b = 2 ; //decimal places c = 1/10^b ] ; Ceiling ( a / c ) * c ) //gives 234.01
  12. A question you might ask is if there's a way set the data in the first place using a script. Then that script can also do anything else. For example, if Plated / Printed is chosen from a popup, then instead you could use a script that scrolls, or toggles, through the choices. Or you could make something, like a radio button field, where you see all the choices, but make your own script buttons to mark the choice.
  13. You can format the popup field text to whatever color you like for viewing the popup list. Then use an auto-enter calculation, TextColor( ), to make the text your desired display color.
  14. Here's an answer I don't recommend. This reminds me of a gadget I've used: an entry in fieldA causes a response in fieldB. Likewise an entry in fieldB causes a response in FieldA. This requires at least three fields. This usually works in one direction and not the other because of reasons Soren gave. So stack a calculation field on top of the side that's not working - and, there are other variations to make this work smooth, but... That said, for your purpose, please DON'T have any mechanism whereby a content in one critical field deletes the content of another. You can have them mutually exclusive where one field stays empty if the other has content. That's easy with autoenters. But try to make the layout so if the cat runs over the keyboard you're not screwed. Also consider the terms: the opposite of debit is credit - the opposite of deposit is withdraw. That reminds me of Gibson guitars which for over 50 years have had a label on the pickup selector switch: RHYTHM / TREBLE (Although actually those terms do equate only in the fact that neither equates to pickup selection.).
  15. FileMaker sans plugin, no. But you can go from the two clicks of exiting the field to one click or less. So as you type in field A, hit shortcut key or button to check length, your cursor never leaves the field. Make field B a button, the script of which updates the Length, and make the last step Set Selection to put the cursor back in Field A.
×
×
  • Create New...

Important Information

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