millmaine

We appear to have resolved the issue. I thought that perhaps records were not being committed properly and went through all scripts to ensure that where a "Commit Records/Requests" script step occurs that the options to "Skip data entry validation", "Perform without dialog" and "Override ESS locking conflicts" were all checked. Since then we have not lost any records. It probably comes down to less-than-perfect database construction and scripting in the first place but this at least seems to have worked for now.

Perfect. Thanks.

We have a table of Suppliers. We also have a table of Tasks. When defining a Task, the user chooses a Supplier from a value list that is filtered by Territory. i.e. the Task will have a Territory defined and only the Suppliers operating in that Territory are selectable. However there are some Suppliers that work across ALL territories. I would like to have a way that these Suppliers are included in the value list for ANY territory, so if the Task has the Territory defined as (say) Sydney, the value list will show the Suppliers relevant to Sydney AND Suppliers that cover all territories. Ideas?

You're correct. The link to the OnTimer trigger seems to deal with exactly my issue. I'll download the sample file and explore that.

I have a script which opens a new (dialog) window for user to enter information. The script pauses while information is entered. I want to allow the user to cancel the script (i.e. leave User Abort on) but if they do, I want the record to revert and the window to close automatically. I tried: If [ Get (Script Result) = "Cancel"] Revert Record/Request [ ] Close Window [Current Window] Exit Script [ ] but that doesn't seem to work. Any thoughts?

Thanks for these thoughts. Privileges was one of the first things we looked at but will review again. Yes we do have UUIDs, so we're confident that data is not being overwritten — the records are actually no longer there. However we don't have ALL of the other fields suggested. We'll implement those. The daily check method sounds like a great way to try to identify the circumstances.

We have been having an occasional issue where records just disappear. It's been going on for almost a year now and we simply can't see what might be causing it. It is not common and seems to happen at random. Once every 2 weeks or so. Our database has 33 tables. The disappearing records all come from the same table. It is hosted on a cloud based server with 17 clients in 2 cities (same time zone) accessing it. Steps we have taken so far are: • Disabled "delete record" from the Menu Set • Implemented a dedicated "delete record" script that notifies the administrator when it is run so that the administrator can confirm with the user that the deletion was intentional. • Checked that records can not be deleted via a relationship • Tracked the timing of discovery that records have disappeared. This is difficult because it may be weeks or months before someone needs to refer to it, so doesn't really tell us when the record disappeared. When the record is deleted it appears that related records are NOT deleted. Help?

Comment's solution works beautifully. Thank you.

I have 3 fields: START DATE — user selects date from calendar RUN — user enters number of days over which activity will occur END DATE — Calculation based on first two fields. This works fine BUT we want the user to have the option of entering the END DATE directly and have the RUN calculated. I changed both RUN and END DATE to Calculated Values but with no luck: changing RUN still changes END DATE (which is good) but when END DATE is changed, RUN doesn't change and END DATE consequently reverts to original value.

OS-X permissions was the issue. So obvious in hindsight. Thanks very much.

File was copied into database folder

Further to previous post, User gets message: "File is not modifiable." This occurs for all levels of access, including administrator.

We have just upgraded to Filemaker Server 13. Client machines can access database without issue, however all functions are greyed out.

In most cases where I've used drop down lists it's where being on that list is part of the validation process. You're right it works fine. It's easy to get so focussed on what you CAN'T do that you forget to look around for other ways. Thanks

I have a pop-up menu that displays standard ad sizes for specific publications. "Allow Entry of Other Values" is activated so that users can put in a special size when appropriate. If someone puts in an "Other" value all is fine. However it seems that this disables the value list for that record. i.e. if someone enters an "Other"value and then changes their mind and wants to use one of the standard ad sizes from the value list, it can't be done except by typing the name in the "Other" dialogue box. This is not effective if the user wants to review the available options. Is there a way to ensure that if the "Other" value is deleted, the original pop-up menu is restored.