• Content count

  • Joined

  • Last visited

  • Days Won


comment last won the day on February 25

comment had the most liked content!

Community Reputation

1,302 Excellent

About comment

  • Rank
  • Birthday

Profile Information

  • Gender
    Not Telling
  1. In all the given examples, you can populate AddressNumber as = LeftWords ( AddressOld ; 1 ) and AddressStreet as = RightWords ( AddressOld ; WordCount ( AddressOld ) - 1 )
  2. Could you post a representative example of the "old" contents? If the format is not consistent, post several examples representing the most common arrangements. Hopefully, you do not have a field whose name contains a forward slash?
  3. To tell the truth, I don't know nor particularly care. This forum's engine has many features that are more suited to a social site than the professional one it is. I would suggest you complete your profile to show your version and OS, though.
  4. Drag and drop is sort of possible (see, but far from being simple. For a method using buttons, see Note that before deciding on any specific method, you need to consider whether reordering performed by one user should take effect for all users alike (which would also require that the records being reordered by one user will not be locked by another).
  5. Where do you get this information? My understanding is that you can run it on both: requirements
  6. The nitpicker in me cannot resist telling you do have a choice: downgrade your OS. The scientist in me cannot resist telling you that your test is inconclusive. Why haven't you used the trial version on the same system? What if the real cause is a faulty memory module?
  7. You don't need a field for this. Just insert the Record Number Symbol into the first portal row - see:
  8. I wouldn't import anything from your current file. The purpose of this exercise is to see if it's your file that causes the problem, or the system. If you use any parts of the suspected file, you can't be sure.
  9. That is a possibility - but before you jump to conclusions, I would suggest you see if you can reproduce the problem in a brand new file. One that has never crashed before.
  10. You may want to lookup the Fast Summaries method.
  11. IMHO, the procedure to find out which room occupies which pages will be more complex than producing a separate report for each room - see:
  12. How exactly is this field defined (in the Service table)?
  13. I don't understand your question. Do you already have a table where each record holds the name of one of the image files in some folder? If so, all you need to do is add a calculation field (with result type set to Container) and let it calculate the path to the corresponding image file. This is assuming your goal is just to display the image). In any case, the logic you have outlined cannot work, because Filemaker cannot loop among the items of a folder (at least not v.11, not without a plugin).
  14. So why don't you do just that? Go to Portal Row [ Last ] Go to Portal Row [ Select; Previous ] Duplicate Record/Request Set Field [ Service::Service Date; Get ( CurrentDate ) ] This is assuming that: there are no other portals on the layout; the relationship is defined to allow creation of records in the Service table; the record you want to duplicate is shown in the last non-empty portal row. Note that if the Service Date field is defined to auto-enter the current date, you won't need the last step. --- Two unrelated notes: 1. As a general rule, you should avoid using copy/paste in your scripts, if only because it destroys the user's clipboard. 2. Your script reveals that you have numbered fields (Machine 1, Machine 2, Machine 3, etc.) fields in both tables. That's a symptom of poor structure. You should use multiple records in a related table.
  15. I guess. These is really a side issue, unrelated to your main question here. Whatever solution is found to that, it can be made to work with YES/NO values, too - just a bit less elegantly. The value list has nothing to do with the calculation. It only helps with data entry and formats the field for display; the calculation works off the actual data in the field, and is unaffected by how the field is formatted on the layout. I am not sure it matters how many you have. And as I just said, making them numbers will not solve the show/hide problem.