nbrunskill

Alrighty, I'll give it a go. thanks! Nate

Nuts! I really wanted to allow scripts to do things that I didn't want people manually messing with. Is there any workaround for this? I assume I'm not the only one who's wanted to do stuff like this. I tried giving the password access to the fields, but not the layout but that didn't work either. Any ideas? thanks again Nate

Hi, I'm tweaking the access levels of a couple related databases. One is a timecard where each entry (via a portal) is a record in a related database. I have a script which is run after a timecard is filled out which goes to the related records, loops through them and performs a the setfield function and a calculation and, lastsly, "sendmail." When I run it as the non-administrator user it says "Your password does able enable you to do this, or this file is not modifiable." I can run this script fine as admin fine and I was able to trooubleshoot the problem to the "Go to related record" script step. I've given the user access to the necessary layout and fields in the related db (though I'd prefer only the script to have access to these), but cannot figure out what is causing the error. Any ideas or other things to double check? thanks in advance Nate

Hi there, Thanks for your response. I should have mentioned I'm using windows. Is there a windows equivalent to AppleScript? I've done this before using AppleScript. Man I miss it was nice... If anyone has any ideas/solutions I'm all ears! thanks Nate

Hi, Like many others in this particular forum, I'm working on a script to send email. My question is: Is there a way to tell Outlook to auto send the email after the FM Send Mail script step sends the necessary data to Outlook Express? I've read from other posts about SMTPit for sending directly, but I'm trying to REALLY economical for now. I've got the SEND MAIL step working fine, I was just wondering if I can somehow (in FM or Outlook Express) get the email to send without having to click it. thanks in advance Nate

Sorry, I had one more thought. Is the limit for 10 unique IP's in 12 hours a limit only for those attempting to connect to my served database via the web, or for ALL those connecting (like both those connecting via the web and via FM Client). And, if I choose not to purchase FM Unlimited (I might have fewer than 10 connections a day), those few will be able to access a web-enabled database served via FM Server, correct?

Ok, thanks! This is what I had suspected I'd have to do. thanks for the info! Nate

Hi Andy, Ok. So, FM Server for sure. As far as the web part, you mentioned I'd have to "build a full on web version of the database." By this do you mean creating pages with HTML and CDML to interact with the database? If this is the case I've done this. Basically, on my personal machine (using FM Client 5.5) I've created funtioning db files that work in both a FM Client and when accessed over the web. Basically, I just want to serve it up at this point to FM Clients (to run scripts, reports, etc.) and to Web clients (to submit data). Do I need FM Unlimited at this point for any reason? Nate

Hi, I have developed (with the wonderful help help of some in this forum I must say) a FileMaker system which needs to be accessed by about 10 people over a LAN and about 10 people via the web. I have read other posts about FM Unlimited and FM Server, but am not entirely clear on when is appropriate. I understand Unlimited allows an infinite amount IP addresses for web access and FM Server is for LAN serving, but I'm not entirely clear on when each is useful. Do I need both or just one of them? thanks! Nate

Ok, I'm an idiot. I misread your previous post Gary. Sorry about that. As soon as my brain actually started working, I was able to successfully use the code you wrote. Sorry about that. Problem sovled! I can't thank you enough for all your time and help Nate

Oh, sorry. I should have been more specific. The portal conflict I get is when I name my selects/drop downs. CDML wants me to name them using colons: <select name="timeCardID::t_shotName.1"> <option value="">DUMMY VALUES </select> but Javascript doesn't like it when I write this in the script, I assume because of the colons and periods. var oLBDest = document.the_form.timeCardID::t_shotName.1 ; Is there something I can do about this?

Ugh! My apologies! I replied too soon. I was able to solve the issue. I changed this var oNewOption = new Option(text) ; oNewOption.value = value; to this var oNewOption = new Option(text) ; oNewOption.value = text; Now is submits correctly. Has anyone found any workaround for the portal/javascript conflict? quote: "Also, I need to submit the info to two portal fields. But, JavaScript doesn't like it when I name my select lists using colons. How have folks worked aroung this?" thanks for everything Nate

Hi again, I changed the code per your suggestions. The value lists work perfectly, and I can get it to write the correct text selection as you showed, but for some reason it still submits the array index for the "web_shot1" form. At first I thought it might have something to do with the "selectedIndex" part of the line below, but I think this line pertains to the "web_show1 " form. var nSelId = oLBSource[oLBSource.selectedIndex].text ; Oh, well. I've pasted the entire script below. Please let me know if anything catches your eye or jumps out at you. But no need to spend too much time on my problem. Nate SCRIPT: <script type="text/javascript" language="JavaScript"> var i = 1 ; var aLBValues = new Array() ; [FMP-Record] var a = [[FMP-Portal: showName]"[FMP-Field: showName::t_FX Name]", [/FMP-Portal]""]; aLBValues["[FMP-Field:t_showName]"] = a; [/FMP-Record] [/FMP-InlineAction] function addLBElement(oLB, value, text) { var oNewOption = new Option(text) ; oNewOption.value = value; oLB.options[oLB.options.length] = oNewOption ; } function updateLB() { var oLBSource = document.the_form.web_show1 ; var oLBDest = document.the_form.web_shot1 ; var nSelId = oLBSource[oLBSource.selectedIndex].text ; oLBDest.length = 0 ; // Clear the LB for(nLoop = 0; nLoop < aLBValues[nSelId].length; nLoop++) { addLBElement(oLBDest, nLoop, aLBValues[nSelId][nLoop]) ; } } function onLoad() { updateLB() ; } </SCRIPT>

Ok, after a few days I'm back again with another question or two, because, well I'm just having a rocky time learning CDML and JavaScript for my first project I guess. Anyways, my conditional value list items in the code above submit a number to the database fields from the array rather than the text itself. For example, in aLBValues["Gabrielle"] = new Array("SIGN1", "THROW3", ""); when ""SIGN1" is slected it submits a "0" rather than the text and "THROW3" submits "1". Is there something I can change to tell it to submit the text instead of the index number? Also, I need to submit the info to two portal fields. But, JavaScript doesn't like it when I name my select lists using colons. How have folks worked aroung this? thanks again! Nate

Hi Garry, I was finally able to get the whole thing to work using the code below. I pretty much attempted to combine it with another, similar example I found on another website. The code it probably not as "clean" or efficient as it could be because of that, but it works for now until I can better learn JavaScript. Anyways, thanks very much for helping me (I've also learned quite a bit from your posts in other threads). I can't tell you how much I appreciate it. Nate <HTML> <HEAD> <TITLE></TITLE> [FMP-InlineAction: -db=shows.fp5, -lay=Form_View, -FindAll] <SCRIPT langauge=javascript> var i = 1; var aLBValues = new Array() ; [FMP-Record] aLBValues[i++] = new Array([FMP-Portal: showName]"[FMP-Field: showName::t_FX Name]", [/FMP-Portal]""); [/FMP-Record] [/FMP-InlineAction] function addLBElement(oLB, value, text) { var oNewOption = new Option(text) ; oNewOption.value = value; oLB.options[oLB.options.length] = oNewOption ; } function updateLB() { var oLBSource = document.the_form.choose_category ; var oLBDest = document.the_form.the_examples ; var nSelId = oLBSource[oLBSource.selectedIndex].value ; oLBDest.length = 0 ; // Clear the LB for(nLoop = 0; nLoop < aLBValues[nSelId].length; nLoop++) { addLBElement(oLBDest, nLoop, aLBValues[nSelId][nLoop]) ; } } function onLoad() { updateLB() ; } </SCRIPT> </HEAD> <BODY onLoad="onLoad()"> <form name="the_form"> <select name="choose_category" onChange="updateLB()"> [FMP-InlineAction: -db=shows.fp5, -lay=Form_View, -FindAll] [FMP-Record] <option value=[FMP-CurrentRecordNumber]>[FMP-Field:t_showName]</option> [/FMP-Record] [/FMP-InlineAction] </select> <select name="the_examples"> <option>DUMMY VALUES <option>DUMMY VALUES <option>DUMMY VALUES </select> </form> </BODY> </HTML>

Hi Garry, It seems that in this section of code: <script> var shows = new Array(); [FMP-Record] i = 0 ; var show_shots = new Array() ; [FMP-Portal: showName] show_shots[i++] = "[FMP-Field: showName::t_FX Name]"; [/FMP-Portal] shows("[FMP-Field:t_showName]") = show_shots ; [/FMP-Record] </script> the "[i++]" sections are not populating with numbers. They should be number themselves starting with zero, correct? Maybe that's what the problem is. But, either way, I shall be purchasing my very own copy of the O'Reilly book (or another if it seems to suit my needs). Nate

Hi Garry, I was able to get the above code to work initially, but for some reason I cannot get it to work again. <html> <head> <title>test</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head><body bgcolor="#FFFFFF" text="#000000"> [FMP-InlineAction: -db=shows.fp5, -lay=Form_View, -FindAll] <script> var shows = new Array(); [FMP-Record] i = 0 ; var show_shots = new Array() ; [FMP-Portal: showName] show_shots[i++] = "[FMP-Field: showName::t_FX Name]"; [/FMP-Portal] shows("[FMP-Field:t_showName]") = show_shots ; [/FMP-Record] </script> [/FMP-InlineAction] <form action="FMPro" method="post"> <INPUT TYPE="hidden" NAME="-db" VALUE="timeCard.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="Form_View"> <INPUT TYPE="hidden" NAME="-format" VALUE="new.html"> Show:<select onChange="ShowShots();"> <option>Select a Show</option> <script>for (m=0; m < shows.length; m++) { document.write("<option value='" + shows[m] + "'>" + shows[m] + "</option>"); } ; // end fordocument.write('</select><br>'); </script> </form> </body> </html> As of now I cannot get the Javascript to write/populate the various options, though the javascript in the FMP InLine Action does generate the arrays it seems. And, do have a particulare favorite JavaScript book or reference for this situation? I can work with example code I think, but am having trouble learning how to write it and work with it myself. And, well, I'd rather not bother you forever... : in any case thanks again for your help Nate

thanks garry! I got the array code above to be populated by the filemaker fields correctly. Now I am working on figuring out how to get them to work with my html form menus. The above code works quite well so far. Nate

Well, I hope it is something I can work through. It is only one level deep. The user will pick a "showName" and will then have to choose from a generated list of shots ("shotName"). I have this working in FilmeMaker itself using a master database and two related db's ("shows" and "shots"). But, as you explained to me last week, relational valuelists don't work too well with CDML and I'll pretty much learn whatever I have to get them to work via the web. please let me know if I can provide any more details thanks Nate

Hi Garry, Yes, I'm definitely interested. Is the JavaScript complicated? I ask because, well, I don't know any. Would it be a pretty difficult "first project" for Java? None the less, I'd be interested in any more details (or even code if the site might be available). thanks! Nate

Hey all, Me again. I've been chugging along on this CDML stuff, which for the most part seems to suit my needs. But, I've run into a situation where conditional pop-up menus are necessary via web entry. I've learned this is not possible via cdml since the web form needs to post back to the db before it can alter the lists. I was going to work around it by dividing the html form process into two separate pages (one which submits the initial data the the other which edits it using the conditional value lists). But, this will not work because my conditinal list is based on related values (another thing CDML does not deal with it seems). So, I am wondering what kinds of work arounds y'all have implemented in oder to use related value lists on the web. Or, alterntively, what solutions have you come up with to have conditinal value lists? From what I've read in the forums, there's lot of JavaScript talk and/or workarounds involving calc fields. Could anyone elaborate? many, many thanks as always Nate

Ugh! That's it. If, in my FMP file I change the value list to "all values" fromt the field the list is created from it works. If I change it back to "related values only" it no longer works. Nuts! That makes the values lists very large and unuseful... ah, well. At least we figured out what the problem was. thanks for your help Nate

thanks for the response Garry. The ValueList is indeed applied to the "t_show" field which exists in a portal on the layout. I just realized that the ValueList I am trying to apply is taken from a list in another file. Does this make a difference? I've also noticed that if I create the submit fields this way ________________________________________ <select name="TimeCardID::t_show.1"> <option value ="">- No Selection - [FMP-ValueList: TimeCardID::t_show.1, List=activeShowsList] <option>[FMP-ValueListItem] [/FMP-ValueList] </select> ________________________________________ or this way ________________________________________ <select name="TimeCardID::t_show.1"> <OPTION VALUE="">- No Selection - [FMP-option: TimeCardID::t_show.1, list=activeShowsList] </select> ________________________________________ both will display the "- No Selection -" in the list, but none of the ValueList values.

hmmmm. after a bit of tweaking, I was able to get the field to show on the web page, but the value list of completely empty.

Hi again, Yeah. That's the way I tried to display the portal itself, but then nothing shows up when I go to view the web page. It's as f there is no code there at all.