Jump to content

View List in IWP only shows...?


Rushhour
 Share

This topic is 5765 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Make sure you're using the most recent updates for IWP in v7. FMI changed the record limit from 5 to 25 records somewhere around 7v3. FMP 8 keeps the new 25 record limit. (I think the limit for table view is 50 now, but I'm not sure as I never use table view in IWP)

Link to comment
Share on other sites

Sorry may i ask what you mean by self join?

In your table, make a new field let's call it "Link", then go to the relations def and make a connection type X (cartesian product) between the first and a copy of your TO with this particular field.

Close the relations def, and delete the newly created field "Link" ...since cartesian products doesn't require indexes to lean up against.

Then are you to create a portal based on this relationship in a form layout including the needed fields and a scrollbar, and you're abel to show endless number of records of the tabels content in IWP!

--sd

Link to comment
Share on other sites

Hi sd

erm.. sorry im still quite new to filemaker, dun really understand.. Can someone help me by showing a life example of it as i really wish to learn..

Actually in 1 of my form(something like po), i have many lines. And i created lots of field e.g. item1, item2, item3 and ... cost1, cost2, cost 3 and... in the end so many fields in my database. I remember i saw somewhere that it should can use portal doing it but i am having problem with that, and i though portal is used to shows records taken from different tables??

Advice will be greatly appreciated..

Thanks a lot..

Kelvin

Link to comment
Share on other sites

I remember i saw somewhere that it should can use portal doing it but i am having problem with that, and i though portal is used to shows records taken from different tables??

It could be from the same tabel, sometimes refered to as selfjoins, what it is in contemporary Filemaker'ish, is it linking made between two table occurences (TO's) stemming from the same table.

But I've made you a template that shows it, containing a whopping 2048 records, so when you go to the third layout via IWP is it going to take some time for the page to render, since all values needs to get stored in some variables the browser can read from, so it in boyscout manner are prepared for the user to pull the scrollbar to a new position.

But when it comes to it, who wish to watch so many records in one view ...so when things are organized in a practical solution are other filterings applied as well, to the selfjoin defition in order to strain the selection of records to view thru the portal!

Remember that the reason why we use databases is a desire to turn data into information by organization ...some use the phrasing "Vessels of meaning"

--sd

toKelvin.zip

Link to comment
Share on other sites

Hi sd

Thanks so much for ur time, I understand now. I need to create a table in the new layout, and replace my those fields with portal!

Some questions..

'since cartesian products doesn't require indexes to lean up against.' <-- ?_? don't understand..

How you actually able to create 2048 records??!!! haha..

Possible to break portal views into pages?

(TO) referring to table orders???

Thanks so much..

Kelvin =)

Link to comment
Share on other sites

since cartesian products doesn't require indexes to lean up against.' <-- ?_? don't understand..

All other relation types, needs two fields, where at least one of the TO provides an index for the relation to work, usually the many side of a one2many.

How you actually able to create 2048 records??!!! haha..

By applescript:

tell application "FileMaker Pro Advanced"

	repeat 11 times

		duplicate every record

	end repeat

end tell

Possible to break portal views into pages?

Yes absolutely!! - You wish to get rid of the scroll bar and cut it up in smaller cuncks such as 30 lines on each page?? When you draw the portal are you prompted for both "Initial Row" and "Number of Rows" ...you should perhaps experiment a little to see the concept behind. But the cool thing is that you can split a long list up in several tabs in a tabbed layout making it posible for the user to, instead of scrolling to the very end of one single portal view, grap the rightmost tab if it show the last say 30 records.

(TO) referring to table orders???

No I'm afraid not - read this: http://www.digfm.org/ref/FM7_key_concepts.pdf

--sd

Link to comment
Share on other sites

Hi sd

icic, Thanks a lot for your time.

Im using list view now, but what considerations should i look into whether to use portal or list view?? which one is better??

Applescript?? where can i get it?? ease to use??

I will be looking into the files and video~

Thanks a lot..

Kelvin =)

Link to comment
Share on other sites

This topic is 5765 days old. Please don't post here. Open a new topic instead.

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
 Share

  • Similar Content

    • By JDW
      Our company still uses FMP 11 Advanced because hosting online via IWP is much, much cheaper than hosting with a modern version of FMP.  Currently, we pay double to have two different FMP 11 databases hosted online.  One database contains 900 records and is open to the public with no password, and the other has several thousand records and requires a password.  
      In hopes of cutting our hosting cost in half, I would like to combine the two databases into one database, such that we need only pay to host 1 database.  But our need to password protect certain records remains.  
      In other words, I want to put the content that doesn't require a password inside the FMP database file that has data we want to protect.  I know it's possible to combine the two databases, but that would mean we can no longer use a main password to lockout the entire file, as that would lock out everybody.  I would like to know if I can use FMP 11 Advanced to password protect only certain records within a single database file?
      Thanks.
    • 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!
  • Who Viewed the Topic

    2 members have viewed this topic:
    madman411  Ron Cates 
×
×
  • Create New...

Important Information

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