Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by LaRetta

  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
  16. And here's your file sample_button_barMOD.fmp12 added ... your latest script would probably work also but I think you can see how it works now (and only one refresh object[] needed). By the way, I really like how you provide a sample file and clear explanation of your need for those assisting you. It shows you respect the time of those who contribute here. 🙂
  17. Hi Randy! Yes, a single script with script parameter on each button followed by refresh object works well. Nice to see you around again! 🙂
  18. If the prefix might be a variety of character lengths, you can use this to pull only the text values: Filter ( PrimaryKey ; KanjiNumeral ( PrimaryKey ) ) gleaned from Daniele Raybaudi years ago. I suspect now would be a good time, as Comment suggests, to split the prefix aside or at least use a new indexed calculation for all future requests such as sub-summarizing etc. This would only work if there are no other text characters in the serial or at the end (which I would guess is true in this instance).
  19. I commend you for your curious spirit and desire to learn. 🙂
  20. Ah. I had forgotten. CTRL-return submitted my post! Thanks, Michael!
  21. It can be helpful to export the name field and attach that file here. The reason it isn't as clean and easy is because your data can look like: Mary Jo L Simpson Mary L Smith-Cunningham ... etc ps how in heck to get a single line carriage return here?
  22. https://support.claris.com/s/article/Execute-FileMaker-Data-API?language=en_US This? I think it just came out. 🙂
  23. Yep, they forgot it: https://support.claris.com/s/article/Execute-FileMaker-Data-API?language=en_US
  24. Welcome to FMForums, CatLady! There is nothing wrong with being a novice - we ALL were at one time or another and still are on many subjects. This is the best forum for help and you're getting assistance from one of the best. 😃
  • Create New...

Important Information

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