Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About IrongateMachine

  • Rank
  1. IrongateMachine

    convert to a word

    You can try these (some examples of what Garry mentioned): Make a calculated field in FM, where the calculation is this: Case( day=1, "Monday", day=2, "Tuesday", day=3, "Wednesday", day=4, "Thursday", day=5, "Friday", day=6, "Saturday", day=0, "Sunday", "Yesterday :P") [FMP-If] statements in page: [FMP-If: DayNumber.eq.1]Monday[/FMP-If] [FMP-If: DayNumber.eq.2]Tuesday[/FMP-If] [FMP-If: DayNumber.eq.3]Wednesday[/FMP-If] [FMP-If: DayNumber.eq.4]Thursday[/FMP-If] [FMP-If: DayNumber.eq.5]Friday[/FMP-If] [FMP-If: DayNumber.eq.6]Saturday[/FMP-If] [FMP-If: DayNumber.eq.0]Sunday[/FMP-If] I'm not that great with Javascript, so if neither of those work for you, maybe someone can post some javascript for you... Hopefully one of those works for you. Also, as mentioned earlier, you should take spaces out of your field names, it looks cleaner and can help avoid problems down the road that you may not forsee at the moment... Good luck!
  2. IrongateMachine

    Portal records - "Group By"?

    You've done it again Garry! thanks so much!
  3. Hello everyone, I have a CDML solution that will display a page for a order. Each order has one or more parts that have been ordered and all are listed on this page. If any of the parts have been shipped, the tracking information is displayed, formated like this: Date.............TrackingNumber...............PartNumber All tracking info is listed together at the top of the page, each part on it's own line. If multiple parts from the same order are shipped in the same package, all parts will have the same tracking/date so I would like to only display the tracking/date once per package. So instead of this: 4/1/04.............12345...............555 4/1/04.............12345...............111 4/1/04.............12345...............999 4/2/04.............44453...............222 4/2/04.............44453...............777 I want to display this: 4/1/04.............12345...............555 ...................................................111 ...................................................999 4/2/04.............44453...............222 ...................................................777 The tracking database contains the fields TrackingNumber, OrderNumber, PartNumber, and Date. The portal is based on a relationship linking OrderNumber to OrderNumber Anyone have any ideas on how to accomplish this? Any suggestions are appreciated, thanks, FileMaker Version: 6 Platform: Windows XP
  4. IrongateMachine

    Javascript calendar pop-up

    Does anyone have any new developments on this issue?
  5. IrongateMachine

    Creating an Invoice.

    http://www.fmforums.com/threads/showflat.php?Cat=&Number=71519&page=&view=&sb=5&o=&fpart=1&vc=1 check that thread out, it's got a some info on the form tags. Also look to the CDML reference database (which you should have by now, if not, search the forum for "CDML reference" and you'll find a link to download). It has info about each component. If you search the internet section for "email" you'll find more threads about doing it and some about some issues to consider. Good luck.
  6. IrongateMachine

    Creating an Invoice.

    hmmm, well here's an idea or two I'll throw out there... What if you had an e-mail that sent out to the accountant once the first part had been filled out. The e-mail would contain a link to the specific record so she could follow the link, add the needed info, then print it. Then once she finishes one, move the e-mail to a different folder. Or maybe you could make a new CDML page that listed all records that have the first part completed. I'd use a tag field and set it to 0 initially, set it to 1 once the first part is filled out, then a 2 when it's complete. Just have the new CDML page list all records where tag field = 1. The accountant could browse to this page whenever she had a chance. Just some ideas, hope this helps!
  7. Hi everyone, I've been struggling to create a contact management database that functions well. I am trying to create a multi-user solution with a main screen with 2 halves. On the left would be a vertical list (compatible with mouse scroll button?) of all contacts sorted by last name with a search box above the list where the user could type in the first few letters of the name they're looking for and the list would scroll to the first match. The right half would be all the contact info for the selected person. Does anyone have any contact management solutions they'd be willing to share or any other tips on creating something similar to what I described? Thanks for any insight!
  8. IrongateMachine

    Have FileMaker serve PHP?

    Hi, Can filemaker pro/unlimited be configured to host PHP files via web companion or do I have to run a seperate web server (apache/IIS) to be able to host PHP? Or am I way off and there's a much simpler way to integrate a couple PHP pages into my CDML solution? Thanks!
  9. IrongateMachine

    Javascript calendar pop-up

    I've gotten very close with your help Garry, but I still have a small problem. The calendars all pop-up, but the date I select always gets set to the field in the first row, rather than the row I clicked in. All links and variables seem to be generating correctly. Each link looks like this after the page generates: <input type="text" name="TheBookLines::RequiredDate.1" value="" size="8" style="text-align: center">&nbsp;<a href="javascript:cal1.popup();"><img src="img/cal.gif" border='0'></a> <input type="text" name="TheBookLines::RequiredDate.2" value="" size="8" style="text-align: center">&nbsp;<a href="javascript:cal2.popup();"><img src="img/cal.gif" border='0'></a> <input type="text" name="TheBookLines::RequiredDate.3" value="" size="8" style="text-align: center">&nbsp;<a href="javascript:cal3.popup();"><img src="img/cal.gif" border='0'></a> etc..... and at the end, here's what the second portal generates for declaring the variables: <script> var cal1 = new calendar2(document.forms['records'].elements['TheBookLines::RequiredDate.1']); cal1.year_scroll = false; cal1.time_comp = false; var cal2 = new calendar2(document.forms['records'].elements['TheBookLines::RequiredDate.2']); cal2.year_scroll = false; cal2.time_comp = false; var cal3 = new calendar2(document.forms['records'].elements['TheBookLines::RequiredDate.3']); cal3.year_scroll = false; cal3.time_comp = false; var cal4 = new calendar2(document.forms['records'].elements['TheBookLines::RequiredDate.4']); cal4.year_scroll = false; cal4.time_comp = false; var cal5 = new calendar2(document.forms['records'].elements['TheBookLines::RequiredDate.5']); cal5.year_scroll = false; cal5.time_comp = false; var cal6 = new calendar2(document.forms['records'].elements['TheBookLines::RequiredDate.6']); cal6.year_scroll = false; cal6.time_comp = false; </script> (there happen to be 6 lines on this page) <edit> I should also mention that I made the changes you posted to calendar2.js Also, I just found another problem...the calendar won't scroll through to the next or previous month. Any ideas? </edit> Any ideas on why all popups edit the first portal row? Thanks for the help so far!
  10. IrongateMachine

    Javascript calendar pop-up

    seems my last post got deleted in the mishap and I didn't get to see if there were any replies, so here it is again: I'm wondering if it's possible to use this calendar a dynamic number of times per page; once per portal row. Anyone have an idea on how to implement that? thanks,
  11. I don't know if you're familiar with tokens, but here's a brief explanation. They use the URL to send a piece of info between pages. It's kind of like a temporary cookie that gets stored in the URL rather than the users hard drive. From what I can tell, it seems that when you sign up for a seminar it stores the record ID of the seminar you signed up for in a token, so when you click the link, the [FMP-CurrentToken] is replaced by the record ID that was stored. I would guess that before you sign up for a seminar, nothing has been stored in the token so you get the error. I don't know how you have the page with links to view the seminars setup. Is it just a list of all seminars available with a link to view it and another link to sign-up? Without knowing more, I would try modifying how the links are created (use [FMP-CurrentRecID] instead of [FMP-CurrentToken]) or set the token earlier so it's already set by the time you get to the page. There is a lot more info about token in the CDML reference database so check that out too. Hope this helps,
  12. IrongateMachine

    Display image just from filepath?

    thanks for the info
  13. IrongateMachine

    Calc fields aren't rounded when displayed on web

    I'm using 5.5 and that seemed to do the trick, thanks for the quick reply/solution Unable.
  14. IrongateMachine

    How to disable 'Enter' key

    Couple of options, check them out see if any work for you... add this javascript: <script language="JavaScript"> function disableEnterKey() { if (window.event.keyCode == 13) window.event.keyCode = 0; } </script> then add onKeyPress="disableEnterKey()" to your form tag like so: <FORM NAME="QTY" ACTION=FMPro METHOD=post onKeyPress="disableEnterKey()"> http://www.dynamicdrive.com/dynamicindex16/disableenter.htm http://forums.devshed.com/archive/1/2001/10/4/24642 http://developer.irt.org/script/2066.htm Since you're looking for a form solution rather that a filemaker solution, there is quite a bit of info out there. Just use google and search for it. Thats what I did to find those links. Hope you can find one of them to be useful!
  15. Hi, I've got some calculation fields that do some complex calculations to end up at a dollar amount. The calculation itself uses the Round() function to trim to 2 decimal spaces. And I have the number format set to 2 decimal places as well. All the numbers show up fine on filemaker layouts, but when I put them on a web page: [FMP-Field: QuoteQty1Amount] Some amounts show up with more than 2 decimal places. Is there a way to prevent this? Thanks,

Important Information

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