Jump to content


  • Posts

  • Joined

  • Last visited

mvincenti's Achievements


Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. I have a related question- since this thread is so recent, I thought I'd just continue it... I have a timestamp field that I'm trying to sort and generally, it sorts perfectly and as expected. I should mention that Filemaker will automatically enter the creation date into this timestamp field. However, I just created a new record and needed to change that date. The sort does not recognize the changed date. Am I expecting Filemaker to act inappropriately? It seems that it honors the actual creation of the record rather than the text within the timestamp field. I can certainly see how this would be useful but how can I add records retroactively via this timestamp field, then? Is my question clear? Thank in advance.
  2. I'm having almost the same problem... I cannot enter information via portals. All other fields work fine- its just that when I access the database from a web browser (via IWP), I cannot enter new information via the portal. I can see existing information but it will not allow the creation of a new portal record. It works fine within the client but not through IWP. : hmm..
  3. Thanks Lee... you're input is always very much appreciated.
  4. To extend this question; I like the provided sample database but I'm wondering if there is a way to automatically (dynamically) shrink the size of the text box so that not all entries take up the same amount of space. I'd be satisfied with a "largest" size which then displays the scroll arrows if the text content exceeds the text box (field size) but it is very ugly to have all that empty space for no reason.
  5. Wow! This is a good little tennis match! In today's day and age, you can say that EVERYthing has to do with security. The intended development of a technology and its current practical uses are two different ball games. I wonder what IPv6 will do to all this. For security reasons, you probably will still have NAT and private IPs and multiple subnets even though technically, each device can have its own static IP- including that filemaker database. But NAT, subnets, etc, are really just ways to expand the scope (and manage traffic) of machines on an network that is finite. Are signs on the road for safety or instruction?
  6. Ah!! Thank you!! I had a feeling that I shouldn't be doing this with value lists. I will try to script out a "find" solution until version 2 of this database is developed. I will use the "==" like you said in the mean time. Thanks again!!
  7. I have a table with people and the activities that each person participates in. The activities are a value list displayed as checkboxes. People can participate in more than one activity so (as checkboxes), I can check off multiple activities. How can I find all people who play soccer only- not all people who play soccer AND baseball. (I will eventually put this found set and display it in a list). I think this is a really basic question but I just can't get it. Thanks in advance!
  8. hmm... I'm sorry. I don't understand. How will that change the layout? I can create a script that when a button is pushed, it will look at the drop down menu, see "Computer" and then go to the computer layout. But is there a way that Filemaker will automatically default to the computer layout if it sees that the drop down menu has "computer" in it without having to push a button? just to be clear: I've got 4 layouts of the same table. hardware: 1st layout- has very basic info computer: above info plus computer details printer: again, info from "hardware" plus printer details. network device: again, infor from "hardware" plus network device details. so the user goes to the first layout, "hardware" and begins to enter information. Once they select "computer" from the drop down menu, they should be taken to the "Computer" layout to finish entering information about the computer (without having to push a button). Thank you very much in advance for any consideration and help.
  9. I have a table for hardware, clients, tickets, etc. Instead of using the "built-in" tabs feature in my layout for hardware, I'd rather choose from a drop down menu what kind of hardware it is (ie, computer, display, printer, router, etc). Once the "kind" of hardware is selected from the drop down menu, I'd like the appropriate layout to appear. I think I want to keep all of this on one table because there is some basic information that is similar no matter what kind of hardware it is (ie, hardwareID, Make, Model, SerialN). The rest of the information, (albeit a lot), is different for each kind. So if I choose "Computer", you see all computer details below. If you choose "Router", you see all IP configuration below, etc. Is there a way to do this?
  10. Ah... I am on a Mac and one of the buttons in my print dialog box is "Save as PDF". The computer just thinks it is printing a document. While in the script maker, I go through all of the motions of "printing" and whenever the script is called, the process repeats. In this case, it is printing a PDF to the desktop. Sorry I can't be any more help. :
  11. You can email create a PDF of that single record and then email that (as an attachment) or you can create a calculation that adds the content of each field to the body of the email. Are you familiar with calculations? PDF Solution: Script for emailing PDF: 1) Go to Layout ["order Prt" (Parts)] 2) Print [Restore; No dialog] 3) Send Mil [No dialog; To: "[email protected]"; Subject: "Please Order Parts"; "orderparts.pdf"] ! the "orderparts.pdf" is the PDF that you created in step 1 ! 4) Go to Layout ["Parts" (Parts)] Email content of fields solution: Script- 1 step: 1) Send Mail details of body field is a CALCULATION (relavent to MY database- change fields and labels accordingly: Service Ticket::email_message & ¶ & ¶ & "Name: " & Clients::Name & " " & Clients::Last Name & ¶ & "Phone: " & Clients::Primary Phone & " or " & Clients::Secondary Phone & ¶ & "Work Order # " & Service Ticket::WO# & ¶ & "PO#: " & Service Ticket::PO# & ¶ & Service Ticket::Created & ¶ & Service Ticket::Priority & ¶ & Service Ticket::Notes & ¶ & Service Ticket::Location & ¶ & ¶ & Service Ticket::Problem & ¶ & Service Ticket::Resolution & ¶ & Service Ticket::Comments & ¶ & Service Ticket::Technician & ¶ & Service Ticket::Status & ¶ & Service Ticket::Stage & ¶ & Service Ticket::Scheduled Arrive Date & ¶ & Service Ticket::Scheduled Arrive Time & ¶ & Service Ticket::Contact & ¶ & Service Ticket::Exact Location & ¶ & "Name: " & Service Ticket::Contact & ¶ & Service Ticket::Exact Location Did that help?
  12. What kind of router do you have (exact model, please)?
  13. ooo!!! I think I know this one! Simply go to the file menu and select "File Options". Tell filemaker what layout to open the file with. The button on your first file and layout need simply be an "open file" button then. this should work perfectly so long as the second file can ALWAYS be opened using the layout you specify. if on the other hand, you need to open the file one way (in one layout) and then open it with a different layout (from the other file), then, I'm at a loss. and that was probably the initial intent of your question. oh well.
  14. I had to do the same thing with one of my databases. My solution is different than Soren's (and Soren really seems to know his stuff so I might trust his answer more than mine) however, this works perfect for my situation. Portals aren't involved with my situation but instead, in order to keep this a "related record", I must copy the appropriate information into the the newly created record (since an existing one was not found). Therefore, my script looks like this: If [Repair Ticket::repairid > 0] Go to Related Record [From table: "Repair Ticket"; Using layout: "Repair Ticket" (Repair Ticket)] Else Copy [select; Service Ticket::ticketid] Go to Layout ["Repair Ticket" (Repair Ticket)] New Record/Request Paste [select; Service Ticket::ticketid] Go to Field [Repair Ticket::History] End If (Since each "Repair Ticket" has a unique ID, I'm telling Filemaker to find out if the related Repair Ticket ID is greater than zero- if it is, go to that record. if it isn't, that is, if the record does not exist and therefore returns a null result (resulting in a zero), create a new Repair ticket and automatically enter the ticketid so that this new Repair Ticket is related to the Service Ticket. Also, I am telling Filemaker to automatically go to a specific field as well- this isn't necessary but convenient.) I am certainly no wizard when it comes to scripting but when I have to make a script, I go through the steps manually very slowly, taking note of every step. Then I go to the scriptmaker and repeat the steps command by command. If it doens't work the first time (rarely it does), it usually takes just a little tweaking to correct my commands. Hope that helps... this is my first attempt to help someone else in this forum! Everyone else has been so kind and helpful to me!!
  • Create New...

Important Information

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