Jump to content

Jason Barker

Members
  • Content Count

    35
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jason Barker

  • Rank
    member
  1. I have this date field (start date) that is set to a Monday within two weeks of the creation date of the record. I also have a date calculation field that runs through the same algorithm based on today's date (currrent start date). I'm trying to do a FIND through a URL where the start date equals the current start date. I'm not having any luck by using the field names in my query (i.e. &start_date=current_start_date) as I think it's looking for a start_date with a value of "current_start_date". How can I accomplish this? Can this even be done in FM? Thanks in advance! Jason
  2. I've been milling around this forum trying to understand some of the newer "features" of FileMaker Pro 7. It all started because my boss bought a copy of FMPro7 (and she loves it) and wants me to create a front end for it for the web. I tried to create a test html page and put it into the Web directory of my FileMaker Pro 7 directory and then access it through a web browser. It didn't work like some of the stuff I've done in FileMaker 5 and 6! (URL: <port>/FMPro?-db<dbName.fp7>&-format=...)'>http://<host>:<port>/FMPro?-db<dbName.fp7>&-format=...) So if I have understood what's going on in FM7 (as well as what isn't), there is no more CDML. Any "customized" interaction with a FM7 database through a web browser must be done in XML (and XSLT -- whatever that is) or PHP. Am I on the right track? Thanks!
  3. On a layout within my database, I have a portal that shows related records. I have placed a button in the portal layout, which will be there for each and every record in the portal (which is what I want). I am trying to code a script that will be executed when the user clicks on the button for any record that is visible in the portal. The script will open the related file and find that particular record. However, I don't know how to access the fields in the portal. Any ideas? Thanks!
  4. Jason Barker

    InlineAction/Portal tags don't work for me...

    P.S. It was your comment about whether the Portal was actually placed in the NAMED LAYOUT that tipped me off to look to see if I had even included the name of the layout in the URL. THANKS!
  5. Jason Barker

    InlineAction/Portal tags don't work for me...

    Thanks Gary, I feel a little stupid...I did not include the layout name (-lay=<layout_name>) in the URL. I tried it for the InlineAction code and it still didn't work. However, when I tried it with the code for the Portal tag, it worked like a champ!!! Also, I tried to hard-code a value in for the "bookCode" field but that still didn't work either. Thanks for your help!
  6. I have created two databases and a relationship between them called REVIEW. I also have a HTML doc set up to display some records from the Master file and then all of the related records from the related file. However, this is not working. I've tried stripping out all of the code to a bare minimum to see if I can even get it to work but when I look at the source of the "rendered" html doc, I see nothing. Here's my code below. Can you see anything wrong with it? InlineAction tag - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <script language="JavaScript"> // Obtain RECORD information and save into parallel arrays. // var username; var mockupID = new Array(); var thumbnailFP = new Array(); var reviews = new Array(); var cnt = -1; [FMP-Record] cnt++; username = "[FMP-CurrentToken: 0, HTML]"; mockupID[cnt] = "[FMP-Field: mockUpID]"; thumbnailFP[cnt] = "http://127.0.0.1:591/[FMP-Image: mockUpThumbImg]"; [FMP-InlineAction: -db=CoverArt_MockUpReviews.fp5, -lay=ReviewInfo, bookCode={field:bookCode}, -find ] [FMP-Record] var testStr = "[FMP-Field: reviewID] - [FMP-Field: reviewDate] - [FMP-Field: bookCode]"; testStr += " - [FMP-Field: reviewer] - [FMP-Field: review] - [FMP-Field: rating]"; alert( "testStr [" + testStr + "]" ); [/FMP-Record] [/FMP-InlineAction] [/FMP-Record] document.writeln( ' <form>n' ); document.writeln( ' <table cellpadding="3" cellspacing="0" border="0" align="center">n' ); document.writeln( ' <tr>' ); for( var idx = 0; idx <= cnt; idx++ ) { document.writeln( ' <td><a href="http://127.0.0.1:591/FMPro', '?-db=CoverArt_Mockups.fp5&-format=cover_art/view_cover_mockup.html&mockUpID=', mockupID[idx], '&-Token.0=', username, '&-find="><img src="', thumbnailFP[idx], '" border="0"><br><input type="button" name="review_', mockupID[idx], '" value="Review this Mock-Up"></a></td>n' ); } document.writeln( ' </tr>' ); document.writeln( ' </table>' ); document.writeln( ' </form>' ); </script> ___________________________________________________________________ Portal tag - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <script language="JavaScript"> // Obtain RECORD information and save into parallel arrays. // var username; var mockupID = new Array(); var thumbnailFP = new Array(); var reviews = new Array(); var cnt = -1; [FMP-Record] cnt++; username = "[FMP-CurrentToken: 0, HTML]"; mockupID[cnt] = "[FMP-Field: mockUpID]"; thumbnailFP[cnt] = "http://127.0.0.1:591/[FMP-Image: mockUpThumbImg]"; [FMP-Portal: REVIEW] var testStr = "[FMP-Field: REVIEW::reviewID] - [FMP-Field: REVIEW::reviewDate] - [FMP-Field: REVIEW::bookCode]"; testStr += " - [FMP-Field: REVIEW::reviewer] - [FMP-Field: REVIEW::review] - [FMP-Field: REVIEW::rating]"; alert( "testStr [" + testStr + "]" ); [/FMP-Portal] [/FMP-Record] document.writeln( ' <form>n' ); document.writeln( ' <table cellpadding="3" cellspacing="0" border="0" align="center">n' ); document.writeln( ' <tr>' ); for( var idx = 0; idx <= cnt; idx++ ) { document.writeln( ' <td><a href="http://127.0.0.1:591/FMPro', '?-db=CoverArt_Mockups.fp5&-format=cover_art/view_cover_mockup.html&mockUpID=', mockupID[idx], '&-Token.0=', username, '&-find="><img src="', thumbnailFP[idx], '" border="0"><br><input type="button" name="review_', mockupID[idx], '" value="Review this Mock-Up"></a></td>n' ); } document.writeln( ' </tr>' ); document.writeln( ' </table>' ); document.writeln( ' </form>' ); </script> ___________________________________________________________________ In both cases the source code for the "rendered" html doc is as follows: <script language="JavaScript"> // Obtain RECORD information and save into parallel arrays. // var username; var mockupID = new Array(); var thumbnailFP = new Array(); var reviews = new Array(); var cnt = -1; cnt++; username = "jason.barker"; mockupID[cnt] = "1"; thumbnailFP[cnt] = "http://127.0.0.1:591/FMPro?-db=coverart%5fmockups.fp5&key=1&-img"; cnt++; username = "jason.barker"; mockupID[cnt] = "2"; thumbnailFP[cnt] = "http://127.0.0.1:591/FMPro?-db=coverart%5fmockups.fp5&key=4&-img"; cnt++; username = "jason.barker"; mockupID[cnt] = "3"; thumbnailFP[cnt] = "http://127.0.0.1:591/FMPro?-db=coverart%5fmockups.fp5&key=6&-img"; document.writeln( ' <form>n' ); document.writeln( ' <table cellpadding="3" cellspacing="0" border="0" align="center">n' ); document.writeln( ' <tr>' ); for( var idx = 0; idx <= cnt; idx++ ) { document.writeln( ' <td><a href="http://127.0.0.1:591/FMPro', '?-db=CoverArt_Mockups.fp5&-format=cover_art/view_cover_mockup.html&mockUpID=', mockupID[idx], '&-Token.0=', username, '&-find="><img src="', thumbnailFP[idx], '" border="0"><br><input type="button" name="review_', mockupID[idx], '" value="Review this Mock-Up"></a></td>n' ); } document.writeln( ' </tr>' ); document.writeln( ' </table>' ); document.writeln( ' </form>' ); </script> _____________________________________________________________ Any advice or help would be greatly appreciated. Thanks! Jason
  7. Let's say that I have a database file with records that have a one to many relationship with records in another database file (which I don't really have...but I suppose this isn't the forum to ask how to do it). I want to be able to get all of the records in the second database associated with the record from the first db. And I want to be able to refer to them using a HTML template file (like normal use in FileMaker over the web). How would I refer to those fields in my template?
  8. I'm just wondering if this is a possibility (and if so, how to do it)...Is it possible to use a FileMaker database that can hold images which can be uploaded via the web as well as viewed in web pages from the database? If it is where should I go to find help with the code/syntax? Thanks, Jason
  9. Jason Barker

    Access Privileges for web users

    Ha, Ha! It worked! The piece that I was missing was: I had to open the service request database file in FileMaker Pro WITH THE DB FILE PASSWORD SET UP FOR A WEB USER! Gee, that's Dumb (with a capital 'D')! Why should it matter which password is used to open my service requests db file so long as the web page sending the 'new' request uses the appropriate username and password combination from the web security db file? Someone please explain the logic behind this to me! THANKS FOR YOUR HELP!!! Jason
  10. Jason Barker

    Lacking Access Privileges

    I have been testing this with Apple's Safari 1.2 (v125). I cannot figure out why FileMaker is rejecting this. The username and password entered in the web security database allow a user to 'Create' and run 'Scripts'. This username/password combination is mapped to a password in the database file that allows access to the entire database file. If I reduce access to the database file for the database password to only allow 'Create Records' it does not work. And when I submit a form via the web, I am alerted to the fact that I do not have permissions to perform the action: new. What does one need to have checked within the FileMaker database to allow a web user to create new records? Thanks for your help!
  11. Jason Barker

    Access Privileges for web users

    Thanks for your reply, Garry. If I understand you right, when you say, "Try opening the database with a password which has 'Create Record' permission," you are telling me to use a web username and password combination within the Web Security database that is mapped to a password in my work request database file which has the 'Create Record' option checked in File > Access Privileges > Passwords... window. The current database password is set to allow entire access to the database file as this is the only way I seem to be able to get work orders in from the web. When I uncheck every option but the 'Create Record' checkbox, I am not allowed to enter a work request (over the web). I am simply informed that I am not allowed to perform the action: new. Am I missing something else?
  12. Jason Barker

    Lacking Access Privileges

    I am experiencing a problem where I am not able to create a new record in the database via the web. The error message I get is: "Access Restriction: You do not have access to perform the action: new" The database is for work requests that our users can enter via a form on our corporate intranet. The form's action contains the username and password for an entry in the Web Security database, along with the hostname (i.e. <form action="username:password@fm.domainname.com/FMPro">). This username and password combination is only allowed to: Create, Edit and run Scripts. The corresponding database password for this user has permissions set to the following (File > Access Privileges > Passwords): Browse records, Edit records and Create records. So with this setup, I cannot create new work requests in the database. However, if I check the "Access the entire file" checkbox in the passwords window for the database file, I am able to create a new record. I have tried numerous combinations of checked checkboxes for this database password but I've not seen any success. Million dollar question: What am I doing wrong? Thanks, Jason Version: v6.x Platform: Mac OS X Panther
  13. Jason Barker

    Access Privileges for web users

    I have checked the "Web Security Database" option in the Web Companion Configuration setup window (FileMaker Pro > Preferences > Application > Plug-Ins > Web Companion). In the web security database, I have Create, Edit and Scripts checked as allowable permissions for this username and password combination. The only way I seem to be able to create a new record via the web is to allow this user complete and total access to the FileMaker file. That seems wrong to me to have to do that.
  14. I am experiencing a problem where I am not able to create a new record in the database via the web. The error message I get is: "Access Restriction: You do not have access to perform the action: new" The database is for work requests that our users can enter via a form on our corporate intranet. The form's action contains the username and password for an entry in the Web Security database, along with the hostname (i.e. <form action="username:password@fm.domainname.com/FMPro">). This username and password combination is only allowed to: Create, Edit and run Scripts. The corresponding database password for this user has permissions set to the following (File > Access Privileges > Passwords): Browse records, Edit records and Create records. So with this setup, I cannot create new work requests in the database. However, if I check the "Access the entire file" checkbox in the passwords window for the database file, I am able to create a new record. I have tried numerous combinations of checked checkboxes for this database password but I've not seen any success. Million dollar question: What am I doing wrong? Thanks, Jason Version: v6.x Platform: Mac OS X Panther
  15. Jason Barker

    A universal password

    Thanks you guys! I gave Steve's solution a try and it worked. This will satisfy the security requirements for this project perfectly! Thanks for the other ideas. They will come in handy for a future project!
×

Important Information

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