Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

-3 Poor

About stefwef

  • Rank

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

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

  1. Each team gets its own interface file (entirely identical) and data file (entirely identical except for data). The teams don't want their data merged into one file for security reasons so I have to do it this way. Also, merging the data was problematic with privileges on merged records, as the only way I found to permit access to only your team records was to set privileges using a global field, and that SLOWED down performance to an unacceptable degree. If I had FMP advanced I could remove the "show all" and what not and force you to navigate only to your related records, but
  2. Thanks! But what I'm wondering is if you can call a script from an external file when the call to the external file uses a variable. I have a solution that calls the same script in many identical files - only the IP host and filenames vary. So I set my call to: fmnet:/$hostIP/$filename I then perform script (Startupscript in fmnet:/$hostIP/$filename) from original file, passing a parameter. However, it won't let me select the script since the call uses variables. Is there a way to do this?
  3. The issues with UI/data separation just keep popping up as I go along! In my integrated file I had privileges set for record access (deletion in particular) that referred to the layout the user was in (layout that is now in the UI file). With separated UI/data, the privileges calling on layout names or layout tables are no longer protecting my records. For example: --> I do not want to prevent deletion entirely in that layout, and I do not want to permit it entirely either. --> I want to permit deletion when child_table::field <>"√" --> I want to allow deletion
  4. Well, I'm writing a book here, but hopefully this will save someone else a lot of pain. I found this on the fmp website: "Also, if the file is shared and the Boolean calculation that determines record access privileges contains one or more global fields, you may be able to improve network performance by moving some global fields into a separate table. " Talk about slowing down performance! to a standstill!
  5. I am passing a parameter to a script, which in turn calls a script in another file. The initial parameter determines which file gets opened. Is there any way to call an external script when you are using a variable filename? I think I know that the answer is no in FMP9.0v3 but perhaps I'm missing something. Would fmp 10 allow this? I'm considering the upgrade... thank you!
  6. I am using export to Get(TemporaryPath) & "temp.fp7" (from a database that is served) then an import to create a bunch of related records upon record creation in the parent table/served file. However, I keep getting the error: ""temp.fp7" was not created by Filemaker or is severely damaged and cannot be opened" It looks like get(temporarypath) goes to : Macintosh HD/private/var/tmp/folders/501/TemporaryItems/Filemaker/ However I don't seem to have a "private" folder on my computer and "temp.fp7" does not get create. THEN, if I change to get(desktoppath), the file DOES
  7. Well, as my husband likes to say, "now I'm cooking with fire". So the slow navigation issue stemmed entirely from privileges to data records, which were set to check on whether a global (team) = record's field (team). When I remove this, all of a sudden my layouts are super fast. So - I am removing them! My plan was to use different launchers to set each team / and use the same set of usernames for each. I guess that will not be possible - will have to set team specific usernames instead. The table slowness was a different issue - and I maintain entirely caused by the
  8. To recap: You currently have only ONE table with fields recipe, food and #? You want to get a total of # for each food (regardless of recipe)? Do you want this as a dynamic value (you can see in browse mode) or is a printed report sufficient? (See recent posting about fruit.)
  9. Is the first row of portal showing in browse mode? Are rows 2 and beyond in the portal printing where they should (ie leaves a blank space for first row) or are they collapsing up?
  10. Do you want #boxes per fruit across orders or just within one order? I think if you just want a report you can create a summary field in items=total of #boxes. Then when you sort your items by fruit, each group will be just one fruit, and the summary will be total of # boxes for each group (ie fruit). If you want results that are more dynamic than that (ie don’t require the sort/preview), the only way I know how is to have yet a third table that is called “Fruit” and matches items by fruit::fruit=item::fruit. In fruit you would have a calc that =sum(items::#boxes)
  11. Alas I do not have fmp Advanced. I don't really get why they don't just make all the versions advanced so I'm stuck with the version we have which is the basic (we're still all on 9). Oh well.
  12. I have removed all unnecessary TOs from my data file and only have those that are called on via calculation. I've deleted all scripts and valuelists from the data file, except for 2 VLs that are called in data file calcs. I have a bunch of valuelists in the interface file that call on fields from data file - should I move those VLs back to the data file and delete form interface file? I was thinking they are part of the interface and as such should be in interface file, but perhaps not... My file only calls on 2 related files, by file:filename.fp7. I've removed all calls and relation
  13. Yes - if you want to move them into a brand new table: import --> file/new table. This will keep calc definitions / I think any ref to related field will appear so long as the table exists in new file. Else you have to re"link" those in the calcs. No - if you want to move them into existing table.
  14. In your script, you can also capture errors so they don't display. In this case you can catch the failure to import and set it to try again. If it fails again you can give user an alert that perhaps something is wrong with the file (or what not - if you have IDed what the issue is). Embedding media is not a good solution if you are expecting a lot of media. Filesize can become an issue.
  15. Sorry I did not check on this again. The question in your file does not match the question on the forum - and setting $$Select to tutor::peopleID and student::peopleID to $$Select are working (when a student portal row exists to click on). Is it that you are surprised that you cannot click to assign $$var to empty student::portal row? This is normal, as the student::peopleID is the related field, it "autoenters" into the related tutors::peopleID (which since you are in "turoring" will be from the first tutor record related to tutoring). You cannot have data entry into this field from two
  • Create New...

Important Information

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