Leaderboard

In this situation, one way of locking a single field such as the 'Quantity' field on an Invoice is to change it into a repeating field with 2 repetitions. In effect, this hidden second repetition "watches" over what you do with the first... Redefining the Quantity field also involves using an auto-enter calc. to populate its second repetition with a "copy of the value" that's entered into the first. Then you add field-validation which checks that both repetition values are the same. On an Invoice layout, only the first repetition is visible. Any attempt to change the 'Quantity' is therefore challenged. I've provided an example file to show how this works. As an extension to this idea, it would be possible to provide a "Please let me" button/script to let a user make a "genuine" alteration - the script could operate in a few ways, one way being that it captures the initial value, the userName etc. (for auditing purpose say), then sets the second repetition to match the first, thereby permitting the change to be accepted. Regards, Ralph Locking_a_Field.zip

In a system I have just completed, there are no invoices. Instead, there are accounts. Each account has "charges" and "payments" and the balance is the difference between the two. It may change each month. If an account has a balance outstanding then they get sent a statement. If a payment comes in it reduces the total owing. It just occurred to me that "invoices" are really "requests for payment" that have a due date. Wow. Let me think about that a while.

I mean the application window close. let’s say you open a new window as part of a script, and then pause the script in order to wait for user input (and also to lock out all other windows from being modified). Users will then inevitably try to “cancel” the paused window by clicking the close window icon. There will be a beep if they do this, but that’s not particularly useful. What I’d like to do is have all the benefits of a paused script, whilst intercepting these “close window” clicks.

I'm switching my company over to paperless invoicing via laptops this year. It's a seasonal business and I've just learned of filemaker not to long ago and I'm starting to get busy again. I'm using the invoicing solution based on the VTC.com tutorials by John Osborne. Anyways, I've modified the solution to my needs and I need someone to incorporate a few features that I've been having trouble with and I'm basically out of time trying to figure it out on my own. Naturally I will provide my current solution with admin password so you can modify it. This work looks easy to me and will probably only take 20 minutes to accomplish for an experienced user. Items needed: 1.) Right now the solution only has a drop down box to mark an invoice paid. I would like to be able to accept partial payments and payments that can be applied to multiple invoices as well as show the current balance for that customer (I have some tables already setup for this but this was past my current knowledge) 2.) When Invoicing I would like the "pool opening" product price to automatically change based on some parameters. The price should change based on. Pool's total square footage ( I have a field for this) pool's type of cover (water bag covers and vinyl pop-in add $10 to the price) above ground pool's have a standard price of $189 (unless they have a water bag cover then they are treated as in-ground price) (I also have some tables setup for this but haven't gotten to incorporate them.) 3.) When Invoicing the "cleaning" product price is based off of the field in customers table called "pool_cleaning_price" I can offer $50 via paypal Thank You, Kevin Stempien