Jump to content

LaRetta

Gold
  • Posts

    11,023
  • Joined

  • Last visited

  • Days Won

    154

LaRetta last won the day on October 16 2020

LaRetta had the most liked content!

2 Followers

Profile Information

  • Slogan
    Lifelong FM Student
  • Title
    Developer
  • Industry
    Software
  • Gender
    Not Telling
  • Location
    Everywhere

FileMaker Experience

  • FM Application
    19

Platform Environment

  • OS Platform
    X-Platform
  • OS Version
    Big Sur

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

LaRetta's Achievements

Grand Master

Grand Master (14/14)

  • Reacting Well Rare
  • First Post
  • Collaborator
  • Posting Machine Rare
  • Conversation Starter

Recent Badges

515

Reputation

19

Community Answers

  1. Hi Carly, What you describe is known as the Separation model and should only be undertaken by an advanced Developer which, since you self-rate yourself as Novice, suggests it would not be a wise design choice. As Stephen indicates, it can greatly complicate your solution. Can you share your reasoning for splitting into multiple files? Maybe there are better ways of solving those issues instead. 🙂
  2. Hi Greg, script step of: Perform Find [ yourCheckboxField ; "*" ] ... should find all records where any value has been entered into the checkbox field versus those records that have not been checked at all. This would be similar to searching for checkbox as 'true' ( contains any value ). Is this what you need?
  3. Or if you already have a summary field in Users table, which is 'List Of' User IDs, just include Users which should be assigned (only from Sales Department) in your found set or include WHERE in Michael's eSQL() calc to further fine-tune the restriction, such as skipping Admin staff.
  4. Hi wattmhite, What do you do in case the number doesn't divide equally? It does now but might not in future; in fact, your first new customer could go to your newest rep if your UserID is UUID (since value list would sort alpha). Your script might instead sort your Users in order of seniority (hire date?) then set your variable with that list of UserIDs so those at the top get any resulting (odd) remainder. Nice calc, Comment! 😁
  5. Hi Rudy, If you must mark records, the less you touch them the better. Attached is an example which: 1. reduces number of fields 2. cuts down on frequency you touch the data 3. provides timestamp when invoice was printed Using timestamp when printed has additional benefits of 1) an audit trail when a group of invoices was printed and 2) allows benchmark stats between when Invoice is ready and when finally generated. I do not know your process. You may wish to print the list of those skipped or loop a second time and print any skipped from the first round. You may wish to add robust error trapping - I used an empty field as proof the Set Field[] failed instead. You may wish to create a calculation of the status (instead of using button bar as I did) if an export is required but this is a rough expansion of Comment's response and not a contradiction of it. Just some things to consider. 🙂 Invoicing.fmp12
  6. Either the button is clickable which works on some records or it isn't clickable at all. Here is how we can help you: 1. Record a video with the file in Browse mode clicking into row 1, then row 2 etc and switch to a few different records and click the Delete on each row. Attach the video. 2. Attach a screen shot in Layout mode of the entire layout including status bar. 3. Do you have any script triggers on this layout? 4. Do you have any special Privileges assigned to records in this table? 5. When you record the video, have script debugger open and viewable to us as well. It is possible that, with this information, we can pin down the problem.
  7. If you are getting a '?' then do you have the calculation set as number? It should be text.
  8. Might it be that you have 998 records with a number field containing 2? Please see attached for a possible reason for your results. I'm surprised FM13 even runs - I'm using FM19 on Mac but I assume the results would be the same? QuickFind.mp4 QuickFind.fmp12
  9. IOW, they all are a way to give a thumbs up. I like the cat badge too; of course I'm biased. 😉
  10. That is PRECISELY what you have, CCBtx (what Comment suggests) ... one of your records contains both values (N and Y). Since you are performing a find for 'Y', FileMaker finds that record too. FM, when searching, treats a multiline (any field with multiple values) as two separate searches. Find that record, place the field on the layout as set it as 'edit box' instead of checkbox and increase its height so you can see all values within the field. You'll need to protect from multiple values being selected. There are a few ways to accomplish that but we couldn't recommend without knowing more. Are you using a checkbox or toggle script to set the value or ?
  11. So the itemID itself is not unique in that table because it could have bidIDs from other periods of time against the same itemID, right? It is the combination of itemID and bidID which must be validated as unique. If I understand you correctly, add a new text field with an Auto-Enter ( Replace Existing Values ) and set THAT field as validation unique, validate always (see the validation on uniqueCombinationKey field (attached). This, as Comment describes, will stop duplicates from being imported. IgnoreDuplicates.fmp12
  12. Hi aregee, welcome to FMForums! 😁 As Comment suggests, an average can be simple summary field. As bcooney sugests, having more information (such as a copy of your script which is triggered) would help. And as Ocean West suggests, you may not need to leave the layout even if you need a scripted process which leaves the layout. Odds are, with more information and a copy of your script, you can simplify your process and get specifically what you really need. You are being assisted by very nice and knowledgeable folks above!
  13. Do you have it stored in your keychain? When I've stored my password to an FM file in keychain then it doesn't matter WHAT I enter in the password, it just accepts it and let's me log in or I can just hit [enter] when the password dialog is presented. If it's stored in keychain, delete it from keychain and try again. Maybe that's your issue; it's worth a try!
  14. Creating a blank layout for each table occurrence (maybe calling each as: Utility: Contacts or Utility: Invoices (etc) is very helpful for tables you're working in frequently. As Tom mentioned, if there are no fields (no references) on these Utility layouts then records will never be fetched from the server even though the record-indicator may specify a number of records. I include a message at the top reminding Developer to never place references on the UTILITY layouts. As for isolating for a found set, a single utility script comes in handy because it is uncoupled, similar to script: ZeroRecords Go to Record/Request [ first ] Omit Multiple [ Get ( FoundCount ) ] So scripts might be similar to: Go to Utility: Contacts Perform Script [ ZeroRecords ] Go To Layout [ ... where you want to end with zero records in the Contacts table to begin creating your multiple records. There are other approaches as well. But really, without knowing the specific process you're expecting, we can't say for sure. You aren't planning on looping and doing this multiple times, are you? You just want to end up on a layout with zero records and then run process to create multiple records, right? Feel free to share more information or your existing script if you would like further in-depth assistance.
  15. You almost had it ... since you want to clear the global value (that controls the conditional formatting), you must use OOExit script trigger on the popover. Attached is how I'd modify your example. Of course there are other ways to approach the problem ... there are always alternatives. 😁 sample_popover_open_close_MOD.fmp12
×
×
  • Create New...

Important Information

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