Chapel of Praise
-
Image copy from Child Table to Parent Table
Here is the scenario I need help with: Multiple people perform maintenance on Master Items. When they complete, they take a picture of the item and that image gets posted to an Item Image table.…
-
transaction timestamp
I've searched the forum but don't find this answer (although I doubt it's a unique question). How do I setup a field that is a transaction timestamp? Example, I collect a signature,…
-
Copying a Signature File from an On File location to a Transaction
I have a signature file (image data stored as signature, original) stored for each CLIENT. It is my OnFileSignature. Each month I deliver to these clients, and they have to 'sign' for it.…
-
Updating Child Record Only if it Doesn't Exist.
I would like to auto-populate my PLAN LINES based on all 'active' items. Once I build the header, I have a button that says "Create Plan Lines" and should create one plan line for each Active Item in…
-
Query Help for a VIEW. Unexpected behavior.
I have a PLAN HEADER and PLAN DETAIL parent-child structure. I have it setup so that I use a slider when ON shows ALL PLAN DETAIL line items, and when OFF,…
-
Is it possible to print a 'view' layout element?
I have a dashboard in which I have created a 'view' from the layout element menu. It produces a table view of the selected columns. Is it possible to print this?…
-
Conditional Formatting Built into Formula Field
I have a formula field that calculates ending inventory balance. [units on hand] - [units to distribute] I'd like to add in a conditional formula in the field background based on final balance.…