Jump to content
Sign in to follow this  
racheld

Evaluate Calculation not working in IWP

Recommended Posts

Hi

I was hoping someone could shed some light on why a calculation is not working once it is translated in IWP...

I am using the following calculation to narrow down the results that appear in one field based on a selection from a previous field.

Evaluate(Quote(""); CSI Div.)

Now I don't know if this was the best or esiest way to accomplish a narrowing down between to fields, but it functions great in Filemaker Pro 9. However once it goes into IWP the field that contains the above calculation does not function, it pulls down a blank filed as if nothing was entered in the previous field.

I don't know if it has to do with the fact that the 'CSI Div.' referred to above is another table within the file. However, the first field references that table fine.

I hope this makes sense.

The following is a hypothetical example of what I am trying to do that would also translate to IWP:

First field contains the names of the 50 States; based on which state is selected, the second field displays the names of the counties within that state only. (The States and Counties are contained within a table)

Share this post


Link to post
Share on other sites

What if you script it instead followed by a Commit Record step in the same script?

However does this seem wrong:

I don't know if it has to do with the fact that the 'CSI Div.' referred to above is another table within the file

Neither in IWP nor native mode will an unstored fields change of value, force thru a rerendering or re-evaluation if the field isn't shown as related value in the layout of the TO the user interface frontmost to the user, at least not entirely reliable!

Often is such behaviour improved just by having a selfjoin in the frontmost TO's layout.

--sd

Share this post


Link to post
Share on other sites

Thanks for the quick response...

I appologize but I am new to Filemaker and couldn't quite follow your reconmendation.

Ultimately I am wondering if there was an easier way to perform a filter between two fields, as in the example above, that would be compatible with IWP?

Share this post


Link to post
Share on other sites

And I exhibit similar appologetic gestures, as to what you're on about. You need to be a slightly more specific in your questioning:

was an easier way to perform a filter between two fields

Easier than what? Your original question was about Evaluate(Quote(""); some_field) ...this is not filtering in my humble opinion but instead triggered cleansing of a field.

Please discripe what kind of effect you're after???

--sd

Share this post


Link to post
Share on other sites

Although I am calling the action I am trying to perform 'filtering' this might not be the right terminology. By easy, I only meant that i am sure there is a simple calculation to perform this action i am just not sure what.

Here is a hypothetical example of what I am trying to accomplish:

In find mode, one would click on the first feild and a pull down menu would display the makes of 10 cars(VW, BMW, Lexus, etc.). Based on which make they selected, when they clicked on the next field only the models of the make selected would be displayed. i.e. One would select VW for the first field and then in the second field they would have their choice of Golf, Passat, Jetta, etc.

Share this post


Link to post
Share on other sites

Dynamic valuelist are not easily applied to genuine requests (going into findmode), but are a fine measure to fill a portal with relevant stuff:

http://www.fmforums.com/forum/showtopic.php?tid/144255/post/144580

But what I fail to see the reasoning in is this:

hypothetical example

...why beat around the bush, instead of descriping a specific problem. In order to get good replies in forums like this, is the "bigger picture" almost always needed to give a balanced input or contribution to a probelms propper solution.

Who benefits from the "cloak and dagger" way of approaching this forum??? It's clearly a way a newbe gives him-/her-self away as ...newbe!

Very few can conduct a life on one single revalation giving everything they need to know about computing, talents are nothing if they aren't cultivated or flexed into fitness, this means that everything is approached via pathes of association, but if you provide next to nothing to hang on to ...are we all in the deep end of the pool.

--sd

Share this post


Link to post
Share on other sites

Thanks again for sticking with me on this one. I now have changed the way my fields relate using Basic Conditional Lists and it works great.

I based it on this link found on another post:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000712

However, I am still having the same issue once it goes to IWP. The first field displays the drop down list, but the second field is blank when you click on it. I tried changing the fields to Pop up Menues, but this did not solve the problem.

Thanks!

Share this post


Link to post
Share on other sites

Hey, racheld. Keep in mind that IWP is a non-AJAX web page, so there's no continuous connection between the web page & the server (it's "stateless" like most ordinary web pages).

Hope that makes sense, but if not, just know that once FMP delivers the web page it "disconnects" from your browser. You can make whatever changes you want on the web page but they aren't actually saved to the database until you submit/save/commit the changes. It's like any ordinary web form.

So, when you select the drop-down list, FMP doesn't see this change until you submit the page. Then FMP will get your new selection & show the corresponding values in your 2nd drop-down. Make sense?

I know that's not the behavior you're looking for, & I don't know of any workaround other than using CWP & adding some javascript. Maybe someone can suggest otherwise.

Good luck.

Share this post


Link to post
Share on other sites

What you said makes sense, thanks!

However, I would like for this to be a function in Find mode, so i don't believe that 'submit' comes into play. My goal is for the user to search the first field "CSI Divisions" and then the second feild "CSI Title" displays subcatagories of only the item selected in field one.

Do you know if there is anyway to perform a refresh calculation of some sort after the selection from the first field is performed in find mode?

Share this post


Link to post
Share on other sites

The same rules apply whether it's to perform a find or alter a record or anything else.

Changing a selection list sends an event message to the browser which could be handled via JavaScript, but FMP/IWP does not handle these events. So FMP will never "see" that the user selected something.

Short story, if you need this functionality you'll have to code it yourself :

Hopefully FM will add some AJAX or additional functionality to allow behaviors like this.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By AlesD
      Hi I can not fiddle out how to make it work. I have tried several browsers with same result. We are using FM 12 server. I tried this file paths
      file:///C:/file.jpg
      C:/file.jpg
      file://localhost/C:/file.jpg
      and few others
       
      I'm using this code in the Web Viewer which is working fine in FM client but not in browser
      "data:text/html, <html> <head> <style type=text/css> " & table::style & " </style> </head> <body> <div class='thumb'> <span class='helper'></span><img class='thumb' src='" & table::ThumbnailPath & "'> </div> </body> </html>"  
      If it's caused by fact image is not present in web site folder as stated in document then my question is if it possible use unc network path in filename like file://///other_than_fmserver/networkpath/file.jpg. I wasn't successful either. 
      Any help appreciated
       
      Thank you
    • By KevinArevalo
      Good morning! I need some help getting something working.
       
      We have a company website, and we are trying to create a instant web publishing portal for our customers to login and view their open invoices. Pretty simple. We have all of our information on a FileMaker solution that is hosted with FileMaker Server 12. The problem is we can't get it to work the way we want it to. 
       
      This is our idea and how we kind of want it to work. We want the have our customers create their accounts/passwords on our actual website. We will store their account information on our web server. We will authenticate their login on our web server. Then, after they log into our website, we want to take their username, bypass the filemaker instant web publishing login page, and then set their username (which they used to log into our website, not filemaker) to a global variable or a field or something, we just need it in filemaker so we can do searches on it. We have the instant web publishing layouts built and we can get all that part working fine, we have the login authentication working on our site, that part is fine. It's just bridging the two together. 
      We are using WordPress to build the website, and our site is hosted on GoDaddy. Our problem is that we can't find a way to auto-login and bypass the login web publishing page. We currently have one account called "WebLogin" which we have been trying to use as a general login (since the actual customer login is authenticated on our website, not FileMaker) but we can't seem to bypass the page. I found this page through google searching: http://lnx.acidsoft.net/problemsolved/bypass-filemaker-iwp-login-via-url.html
      and tried to do it the way that he describes, but it is not working. It gives me an error saying:
      Bad Request
      The server could not process your request due to a missing command: ""
       
      And I get another dialog box that says: 
      Bad Request
      The server could not process your request because your session has timed out, been closed, or communication with the server has been lost.
      Please reselect the database to begin a new session. If you cannot open the database, please contact your database administrator.
       
      That is one of the problems, how can I resolve this?
       
      My other problems is we are trying to pass through the username that the customer uses to login to our website as a variable in filemaker or even set it to a field. I am not sure how to do this. Is this even possible?
      Thank you so much!
    • By djlane
      I have an application that was using IWP under FM Server 12, to allow my friends and friends of friends to upload their golf scores, and my system would calculate their USGA handicaps.
       
      After upgrading to FM Server 13, IWP not longer exists, and WebDirect does not support mobile devices.
       
      So, I set up an alternative server using FM12.
       
      A lot of guys that I don't have contact details for, used that IWP based system to upload golf scores. So I don't have a way to tell them all the new URL.
       
      Using the old IWP URL, you are presented with a screen that says "The requested page is not found. Check the URL you are using to access FileMaker WebDirect."
       
      I want to edit that page to add some additional information telling them the new URL etc. But I can't find any document with that content in any FM Server folder or sub folder. 
       
      Anyone know where I can find it ?
       
      thanks
    • By cchaski
      Hi, I have a databse hosted in IWP that uses Supercontainer for people to upload documents. The process works fine when I use FMPA 12 to access the hosted database, but when I go through the web browser (the IWP approach), the process does not work. A button "Upload Doc" calls a script that goes to the upload layout, generates the SC id code for the record, shows the webviewer with upload and delete buttons. This works fine when I am using FMP to access the database, but this does not work when I use IWP. When I click the button in IWP, nothing happens. Any ideas?? Thanks in advance!
    • By cchaski
      Hi, I have a databse hosted in IWP that uses Supercontainer for people to upload documents. The process works fine when I use FMPA 12 to access the hosted database, but when I go through the web browser (the IWP approach), the process does not work. A button "Upload Doc" calls a script that goes to the upload layout, generates the SC id code for the record, shows the webviewer with upload and delete buttons. This works fine when I am using FMP to access the database, but this does not work when I use IWP. When I click the button in IWP, nothing happens. Any ideas?? Thanks in advance.
×

Important Information

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