Jump to content

aricm

Members
  • Posts

    17
  • Joined

  • Last visited

Everything posted by aricm

  1. I have a Filemaker database which runs on several terminals, some of which are dedicated to database operations and others that are used personally as well. I have a Send Mail script in the database which works well, except that I want the emails to always show up from the same (general) email address. That way all replies will come to the same email address, and all messages sent will be from the same address/name. The problem is that when the script runs on a computer used for personal emailing, the Send Mail (and OpenURL, as far as I can tell) will send from the default email account on the computer, which is usually the personal account. In addition, if the user already has an email client open on their computer, the email will be sent from that account. There are two solutions I can think of. The first is to try to find an email plug-in that allows me to set this value, which is undesirable because my terminals are running different versions of Filemaker on versions of MacOS ranging from 9.1 to 10.2, and loss of support on the plug-in as OSes change would be disastrous. The second answer that comes to mind is to create an AppleScript that opens a specific email client, sets the identity, sends the email, and closes the client. My only problem with this is that it would be open to problems as users change their email clients and configurations. It seems like a great deal of complexity when there should be a more simple solution to simply setting the "From" value. I have looked into the OpenURL:mailto option, but it doesn't seem that mailto has a parameter for "From", instead simply using the mail client specified in Internet Config. All help will be greatly appreciated!
  2. Excellent! Thanks very much for all of the help!
  3. Thanks for the reply, Garry. I've got a pretty good idea on how to set up the format file. I guess the gist of my question goes more to the URL or form used to access the data in the first place. I need to be able to search for the five newest records in the database, which keeps track of creation date, and then immediately display the data from those records. The kicker, though, is that my client insists on not having a separate form page, which requires the user to click a button before viewing the results. I've been hoping there is a type of URL to run the search and call the format file. Any ideas? [ March 26, 2002, 05:22 PM: Message edited by: aricm ]
  4. I'm trying to create a page that draws from a Filemaker database. The database is already available a web server, and there is a page created with Claris Homepage that accesses it. I would like to create a page that automatically displays detail information for the five newest records in the database. I have the CDML Tool and GoLive, but am having trouble coming up with a page that automatically accomplishes this search and displays the result info. I have found several topics about setting up the database for web publishing, but I'd like to find out more about creating the actual pages. I have a copy of the main database locally on my computer, but the actual database and files are on a server to which I have FTP access. Thanks for the help! [ March 26, 2002, 05:54 AM: Message edited by: aricm ]
  5. Aha! I saw one one other posting of yours that hinted at this from last year, but the original question was unclear so I didn't get it at the time. Basically, the two related fields (iOne) are dummy fields that are used to create the relationship for access between real fields, right? That should fix it perfectly. Thanks!
  6. I have one file, Invoicing, that has two global search fields (NumSearch and CodeSearch). The file has a working script, Invoice Search, that uses these global values in several fields to find an Invoice that has a range of Num values that incorporates the NumSearch value. More specifically, each Invoicing record has ten StartNum and ten EndNum fields (StartNum1, EndNum1, StartNum2, ...). The Invoice Search script finds any record on which the Code value matches CodeSearch and one of the Num ranges includes NumSearch. I don't know if all that makes sense, but that part is working. What I want to do is have the user be in a different file, Items, for which each Item has one Code and one Num. The user will click a Find Invoice button, and the Invoice Search script should run with the global search fields set to the Code and Num values from the currently viewed Item record. Normally I would use an Insert Calculated step, but I can't think of a way to relate the Items file to the Invoicing file. Without a relationship, I can't point any script steps to any field in the Invoicing file, including the globals. As Item records are generated, the Invoice that includes them is unknown, and so I can't relate an Item to the Invoice that included it. It's unrealistic for me to create an Invoicing record for each Item, since hundreds of thousands of Items are invoiced (hence the number ranges), while only thousands are entered into the Items database when they are returned at some later date. The best approach I can devise would be a way to relate Items::Num and Items::Code to the global fields Invoicing::NumSearch and Invoicing::CodeSearch, but I'm uncertain as to how to design this so I can copy the values from the two Items fields into the two Invoicing fields. Thanks in advance for any help!
  7. Thanks! I can't decide whether it's a benefit or a detriment, but one of the wild things about Filemaker is how many easy answers there are to difficult questions. Thanks for the help!
  8. I have a related field, ::notes, which houses notes for the current record. The field is locked so that users cannot edit the notes. However, there is another field, addNote, in which a user can type text and click an "Add Note" button to insert the date, user name, and note text into the related ::notes field. The only problem with this arrangement is that the number of notes could be very large, and with the field locked against entry the user cannot access the scroll bars (which are enabled). I have tried using a scrolling portal, but eventually ran into the same problem: I could scroll the portal, but the not the field). Any suggestions would be greatly appreciated! [ April 20, 2001: Message edited by: aricm ]
  9. First off, thanks for that thorough explanation. If I use that approach, it will be invaluable. Not to beat a dead horse or anything, and your approach sounds like it will help, but I'm going to have to have a password and login for each user, and this requires a new navigation structure with an open script for each file that might be opened separately. Plus it adds the third interface for user management (since the administrator will have to manage the Filemaker password rights, the entry passwords for individual users, and the login security for the terminals), which I was hoping to avoid. Isn't there any way to just access the data that would normally be inserted by the Created By auto-entry? I guess I could have a dummy field and copy the text from there, but that's kind of the long way around and it seems like we should have direct access to that data as a function. Last question on this topic, I promise!
  10. Thanks, that sounds like it might do the trick (without hindering the navigation system too much). Do you assign the default password in the open file and paste it upon opening another file? Since I will need the security the groups feature provides, do I map each user to a password that is the default for their group?
  11. I'm writing a database system of about 12 files that will be accessed by several users, each of whom requires a different password. I will also need to control access to different layouts by use of groups. I'm resigning myself to maintaining a password for each user, and tying each of these to the group rights. However, in several cases I also need to access the user name of the person modifying the database. For example I have a script to add a note to a related "notes" field which accumulates several notes(like a large memo field including all of the notes). In that field I need to insert the username prior to the note text. I see that the auto-enter options for a field can access the username (which I assume is the network login) to put it into a field. Is there a way to access this value in an InsertCalculatedValue() script step? I'm hesitant to create a Users database since the client will already have to manage network logins and Filemaker passwords and groups through two different interfaces. A Users database would create a third separate interface. BTW: the database is running via FM Server on an NT network.
  12. The only problem I can think of, and on reflection this applies to the global fields solution as well, is that the categories database (which is intended to hold all of the default requirements) will have several categories, each with its own set of defaults. Where one requirement may be a default of $500 for one category, it could be $250 or not required for another. My intent was to have a record for each category, a field for each requirement, and the default for each category in the appopriate field. What concerns me is that the creation script, in setting the values of some 20 fields in the new Items record, will be a hefty performance hit, since each set value will be accessing the related Categories record. Thanks again for all of the input, folks. I'm at least getting the feeling that this has been thought through!
  13. To complete that, all it would take is a managerial layout including all of the global fields, correct? Excellent suggestion, I'll give it a try.
  14. Thanks for the reply. Part of my problem is that the default values being applied have to be editable by the end users. So they'd have to be able to go in (frequently) and change the defaults or create new ones. I don't think it'd be safe building these defaults into the creation script, since the users would have to edit my script to change the values. This was my reason for having the defaults for each category stored in a database and only referenced at the time of record creation. Is there any way to script a lookup at the time of creation (the items database will be related to the categories database on the category match field)? That would at least save me from having to do all of those Set Field steps.
  15. I'm creating a database for a group that has ever changing reporting requirements based on the values of a few different fields. I want the default requirements to be set as a new record is created, but then the user should have the option to change those requirements. My current plan is to use a categories and an items database in the following way: 1 -- Include in the Categories database one field for each possible requirement. Each category will have a binary value for each requirement, designating whether the requirement is a default for that category. 2 -- In the item database, various information will be entered, followed by a "Choose Category" value list and a "Set" button. The value list will be based on the category names in the Categories database, and the go button will call a script that will run a set value for the requirement fields, which will be duplicated in the Items database. 3 -- The user will then be passed to a "Requirements" layout which will allow them to edit the values that were set by the script. For some reason (I wonder why) I feel like I'm overcomplicating this process, but nothing else is coming to mind. It is important to have the ability to edit the current default requirements for the categories, which is why I've put them into a database of binaries. The solution has to be Windows compatible, so I can't use any AppleScript functions. Thanks in advance!
  16. Just a note: You need to change the conversions in the above calculation to account for square units. If a meter is 3.3 feet, then the conversion either needs to be done to each measurement ((3.3*length)*(3.3*width)) or substitute the value 10.89 (3.3 squared) into the calculation. Of course, the second option will only work for rectangular area.
  17. I think you need an End If statement for each conditional. The Else step for that test also goes inside the IF step (before the End If). Try this: If [username="test"] Perform Script [sub-scripts,External: "datetest.fp5"] Else If [username="den"] Perform Script[subscripts,External: "test.fp5"] Else If [username="king"] Perform Script [sub-scripts, External: "Tour.fp5"] End If End If End If Kind of makes you wish for a "Switch" script step, huh?! [This message has been edited by aricm (edited December 21, 2000).]
×
×
  • Create New...

Important Information

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