Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About jn08

  • Rank

Profile Information

  • Gender
    Not Telling
  1. I'm using Filemaker Pro 11 and trying to switch on IWP. I'm using Mavericks and Server on a mac mini in our office. IWP switches on after a long time with a spinning beach ball, but even though it will allow me to change the port number to something else when I re-open the preference pane for IWP the port has changed back to the default (80). When I try to access the server from inside or outside my network I get a "No data received" error. Anyone have any clues to fix this? I'm sure I had IWP running when I first set up this database, but I have no idea why it's suddenly not working.
  2. I think I've got this working, but I'm using a script to update a text field and having it loop through each record adding the current date whenever a new promotional price is updated, added or accessed as well as during the startup script every evening. This should cover all contingencies as far as I can tell. I tried to use a global field instead but it didn't seem to work with the auto-enter calculation. Thanks for your help guys.
  3. Hmm, that might be the issue. I have a script that runs on startup (which runs once a day as the database is scheduled to close and re-open overnight). The easiest way to integrate it into my existing solution would be to somehow 'refresh' that field so it updates, but I'm not sure how to do that. Is it possible?
  4. Could the issue be that the fields in the Product table that are accessing the promotional pricing are calc fields pointing to the related fields? Do they need to be fields inserted directly from the related table, or can they be used in calculations? The documentation on the "automatically create indexes as needed" option seems to suggest that new indexes are only drawn up when searching for the field -- not when accessing the fields in related calculations. Any ideas?
  5. Unfortunately when I set the regularly updating field to Do Not Store the relationship breaks and no information is displayed. If it's set as "store only as needed" it appears to not update when the calculation changes. Here are the two match fields: ProductID (Number, Indexed, Auto-enter serial, Can't modify auto) --> ProductID (Text, Indexed) Active Promo (Calculation, Indexed, = 1) --> Active (Calc, Indexed, from Promotional Pricing, = If( Get ( CurrentDate ) ≥ Promotional Pricing::Start Date and Get ( CurrentDate ) ≤ Promotional Pricing::End Date ; 1 ; 0) Not sure if
  6. Hi, I've got a central title database set up for a publishing house. They have promotional pricing that they need to schedule by date. I have a promotional pricing table set up with a start date, an end date, and the promotional price. A calculation field on this table determines whether the particular row on the table is 'active' i.e. should have pricing enabled. I've got a relationship to this table with the main products table matching the ProductID and the Active field. I would have thought this would work, but I'm having trouble on a number of levels and have tried a whole bun
  7. I'm using the web viewer to scrape data from a website on a daily basis. The script loops through my records and loads the web page. I use a loop script like the below to make sure the page has loaded before scraping data. Loop Pause/Resume Script [ Duration (seconds): 1 ] Set Variable [ $html; Value:GetLayoutObjectAttribute("source";"content") ] Exit Loop If [ PatternCount($html; "<head>") ] End Loop The problem is that occasionally the web viewer returns a "the request timed out" error in the status bar and this causes the script to just loop infinitely and not complete.
  8. That is precisely what I was looking for. I don't know why I didn't see the bloody script step! My apologies. And thanks.
  9. Hi guys, Not sure if this is the best place to post it, but I've searched and can't find a solution. Is there a script step (or a workaround) to force a web view to reload? I'm currently using the Filemaker Wordpress plugin to sync various fields with a Wordpress website. Works great, but there are a few fiddly custom fields and other elements that don't work with the sync, so the user has to interact with the admin page of the Wordpress back end. It all works fairly well, except that if the script I use to update the Wordpress page runs then the web viewer to the right of the page d
  10. Ah ... I see. Hmm. I can't see how to smarten that up, though, so it's invisible to the user.
  11. I guess so. I'll have to change the calculations pertaining to it. But I definitely want the user to enter the whole percentage amount. This is a confusing issue. What if the user wanted to enter 0.4%? It's not particularly intuitive from a user interface design perspective, even if conceptually it makes sense. Not sure what you mean by smarten up a bit to handle editing ...
  12. I'm using the number in calculations elsewhere, so I can't change the number in the field. I don't understand, is this normal behaviour? Why would the percentage field change the number displayed? I want the user to input a percentage ... It's very confusing.
  13. Hi, I think I must just have some weird setting in place but I can't for the live of me find it. Every time I set a number field to display as a percentage it shows it as a percentage times 100. For e.g. If the number in "general" format is 40, and I set it to percentage it changed to "4000%". It's clearly only a display issue, as if I change it back to general it displays in the original format. Anyone have any idea what could be causing this? I've tried the same thing in a new database with the same result, so I assume it's a preference in FileMaker.
  14. I've got it working about as well as I expected it to get. Though it still doesn't watch the calculated fields, none of those are critical. However, I suspect I've got my database wired up wrong, which is why I can't quite conceptualise how I'd do what I wanted to do properly. At any rate, I've got a books database with 80+ fields, many of which are automatically stored, some of which are calculated from related tables. Occasionally I need to output metadata for the books (to booksellers etc). Mostly this is new titles, but I'd like to have the database keep an eye on any books that
  15. Ah, yes. That is what I mean. So there's no way to update on that basis?
  • Create New...

Important Information

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