jn08
-
Posts
50 -
Joined
-
Last visited
Everything posted by jn08
-
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.
-
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.
-
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?
-
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?
-
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 the relationship graph will help much but happy to post it up. Thanks!
-
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 bunch of different combinations but it still doesn't seem to update day-to-day. First-off I discovered that the relationship doesn't work unless indexing is on. So I turned it on and the calc field on the promotional table doesn't seem to 'update' the next day and therefore display the correct current promotional price. I've tried using auto-enter number fields, but they don't seem to update either. Could anyone give me a best case scenario of how this relationship should work and what type of fields (with what options) should be used for the relationship? It's driving me insane!
-
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. If I come across this error and manually load the page again it continues with issues. Is there any way I can pull this error into the script somehow to avoid having to manually check it?
-
Refresh web viewer with script step
jn08 replied to jn08's topic in Script Workspace and Script Triggers
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. -
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 doesn't reload, so the new information sent to the page doesn't show up. If the user then interacts with the web viewer then there's a conflict when they try to update. It's easy enough to manually reload the web viewer if you know what you're doing, but expecting users to do this is a bit tough. Does anyone know how to force a web viewer to reload its contents? I've tried just moving back a record and forward again, but sometimes the viewer caches the page. Would appreciate any help.
-
Ah ... I see. Hmm. I can't see how to smarten that up, though, so it's invisible to the user.
-
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 ...
-
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.
-
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.
-
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 might have been updated with new information since the last update and output them along with new titles. At the end of that export, I'd like to make sure all exported titles don't get exported again (unless they're modified).
-
Ah, yes. That is what I mean. So there's no way to update on that basis?
-
All right, I've used the method suggested and it works well. The only problem is that the flag doesn't register changes in calculation field results. Is there any way to force it to notice the change in a calc field?
-
That's a pity. So there's no way to do it but to list every single field? And presumably that means I have to update it every time I add fields to the table down the line. Is there any way to automate this? I'm not sure I understood your solution. If ( Flag ; Self ; Modified ) My idea was that the flag should set on automatically based on when the record is modified, and be switched off automatically when there's an export, but it also needs to be manually switched off at times when the record is modified but the user knows it won't affect the export. At the moment if I do that with a normal date modified field it will immediately set the flag back to on (because it's modifying the record).
-
Thanks. Having trouble doing the calculation using FieldNames(). This is what I've got so far, but it doesn't work: Let ( trigger = FieldNames ( Get (FileName) ; Get (LayoutName) ) ; Get (CurrentTimeStamp) ) Obviously if it worked this would show a timestamp if *any* field were updated, but I thought it was a start to work it out... Any tips?
-
Ah, yes. I understand now. I think the FieldNames() function solution might be the way to go. I've tried searching the forums for a local field solution (a record modified field that only watches particular fields - in this case all but one) but I can't seem to find it. Can anyone point me in the right direction?
-
Hah! Sorry guys. If I create the flag field on a separate table then I'll have to manually create related records in that table if I want the flag field to monitor the product record's date modified field. I think that makes sense. I think it might just be easier to change the date modified field so that it doesn't monitor my local flag field. I just don't want to have to specify every single field except that one, my product table has 80 fields or so.
-
Erk. That sounds complicated. Is there a way in the "flag table" of automatically creating a record so that it creates a flag as soon as there's a record to be linked to?
-
The flag does apply to all users. I need to know when a record has been updated by any user in order to know which records to export. Only the modified records need to be exported. I want the ability to flick the flag off manually because sometimes the user (or I) could make a change they know will not affect the export, so it'd be good to be able to ensure it *won't* be included. It'd also be good to switch it off when the records that need to be exported are exported, which could presumably be done with the export script. Any suggestions on how to do it?
-
Hi everyone, I'm trying to create a field which flags whether a record has been modified today, and is modifiable by the user in case they don't want to include it in the next export (and I will set my metadata export script to flag all exported records to "No"). The auto-enter calculation I've added to the field works, but (rather obviously) it updates automatically to "Yes" as soon as the user tries to click "No". This is the calculation: If ( PatternCount ( Record Modified ; Get (CurrentDate) ) ; "Yes" ; "No" ) I guess I could try sticking this flag in a related table so it doesn't update when the record upates ... but is that the simplest solution? Or is there a simpler way?
-
The target spreadsheet has fields (columns) for four authors (or perhaps it's five, I'd have to check). Most of the time there's only one author, so most of these fields are blank. So the extra fields need to remain blank if there's only one author (or two, or three). I've figured out (sort of) the author situation. But I feel like there should be an easier way. I use a similar method to the multiple ISBN allocation described above. However, the text parsing is a lot more complicated, as author name fields can include multiple names. In the end I managed to write a calculation that allocated the Author to the Author export field, and the Author 2. I can do the same for further authors, but haven't yet. It would be far more simple if there were a straightforward way to include multiple specific related fields on a layout to be used for export. Or if portal fields exported like normal fields.
-
I've already got the export file set up, and I don't have control over column headers, it's a set format. It has columns for multiple authors and multiple ISBNs. However, if I set it up that way in the database it wouldn't be very useful for anything else, so I want to keep the relational set up. I've figured out a solution for the multiple ISBNs. I have added a calculation field in the product table with a List() calc that lists a concatenated format of the Format & ISBN. I then wrote a text parsing calculation for each specific-format ISBN field to ensure they all have the right ISBNs split out to the right fields for export. It was easy enough to do because every ISBN is 13 digits long. Will be more difficult for the multiple contributors situation, but I reckon I can still probably do it. Fiddly, but once it's set up it should just work.