Stick

You would need to use Filemaker Server 7 Advanced - otherwise you are limited to 5 concurrent users. Overview "Allow up to 100 users to simultaneously access a database that has been published to the web through Instant Web Publishing"

There has been a similar post here. Hope it helps.

As no-one has replied, there probably isn't an easy way. If you have know all the users and usernames then have a table with them in that has a 'logged_in' field (1's & 0's) that is set on a start-up script. Then loop the table for current users. However, you would also need a reliable way of knowing when they log out - don't know if this is possible when they shut the database down with an 'on close' script.

You can see the report if you use browse/list mode as well can't you. When do they revert back? when you switch to browse mode?

You can do this using scripts. If its a related record - then 'go to related record' script step and use 'set field'. Or just 'go to layout', find the relevant record and use 'set field'

For information, I contacted rapidhost.co.uk and they said they could host the database in the way that Reed has said. They were very very helpful!

I have seen this problem in other posts - but it seems to be for multi-user environments. Mine is only used by 1 person at a time - but still I am getting 'record in use' errors. They have started appearing after upgrading to FM7 - the majority when I am using the 'replace contents' script step. I know there are additional locking features in FM7 - so what would I need to remember to fix this? Do I need to specifically use the 'commit record' step and things like that? Thanks

Thanks, that's what I was afraid of! What are the main differences between fm6 and 7 for IWP?

I have developed a solution in FM7 to use with IWP. However I did not realise that the server 7 had only just been released and hosting companies say in general it is going to be the middle of August until they are fully up and running with this! I need this working for July 12th - therefore is there a way of converting back from FM7 to FM6? Emma

Anyone know of any ISP's that host FM 7 now?

QuinTech - you are right, its the fact that there is a limit on the records for both list and table view. I was hoping to have a large portal so it would display all records at once and therefore be able to print them all off from a browser. I think I will try using the conditional portal page thing. I am sure there will be some kind of delay loading the page with a 500 row portal?! Thanks for both your help. M

It probably would if I understood what you meant It has to be related, its not actually rows matching the total records in the table - it'll be a subset of these.. defined by a relationship. I think I'm just going to have to abandon the idea of printing from a browser. Thanks though! Emma

This is for development in IWP. I have a report using a portal (because of the 5 record limit for list view) that needs to be printed out. However you are only able to print as much as the portal displays on screen. Is there a way to dynamically increase/decrease the portal rows so they match the number of records in the table? Thanks Emma

I believe someone previously tried with word 2004 and it didn't work.

Thank you for the info. I have just realised that the script step "Perform AppleScript" is not Instant Web Publishing (IWP) compatible. Any one know of a different way - my clients aren't happy to send lower case emails

Sorry to hijack this thread... How would that applescript translate to URL to use a mailto - i need to use this fix but have no experience of applescript. I am getting the lowercase problem when it populates the email. Thanks

you would probably need 2 drop downs - one for the group and then another with the ingredients in. the ingredients one would need to be a value list defined "from field" and then selected to use related values only.

The template examples in the filemaker folder show examples of this. A specific one is the inventory. On my system: filemaker 7/english extras/templates/business - people & assets/inventory.fp7 The blue tabs at the top right of the layout are what you need.

I am using the open OpenURL() script step to send emails - using mailto: I have 3 problems in using this and wondering if there are any workarounds. 1. All text loses case formatting. (ok seen a fix here using applescript - but applescript is not web compatible) 2. Special characters not displaying correctly. i.e. apostrophe displays as

If you are using a portal now, are you viewing as a form.

Alan H - I think I am going to assume that it is something like overlapping - even though it doesn't appear to be. When the font is larger, the field is still within the body - and the other occurances of it in the list are relating back fine - its just the new one that you enter. I'm not using scripts for this. And none of the relationships are defined to sort on a field that has been deleted.. curiouser and curiouser......

jfmcel - thanks a lot! I think you have just saved me from learning yet another scripting language

That is madness - all I did was change the formatting of the related field to the same as the other fields small, black (it was big and blue - just testing the fields) and it works! Change it back to big and blue and stops working again! This isn't a problem for me, but any ideas why this should happen?

Not sure if this is a bug in FM7 or a bug within my database - I can recreate this over and over. I have a layout that contains fields from that table (ids), related fields (codes and cost) and 1 related field from a table more than 1 table away (product name). When I add a record to this layout, the related codes and costs get filled in correctly but the product name does not. To make this appear I need to go to define databases (on the relationship tab), then double click on a relationship and then close the dialogues back to the layout and it magically appears!? Any ideas? Emma

Thanks for your suggestion, I would do it the inelegant way as they would only need to order in 2 different ways. However, I have realised that the field I want to order by is actually a related field - therefore does not appear when you double click the portal and try and sort it from there. Is there a way of sorting by a field that is related?