S Moore
-
Calculating Sales Tax
This is such a simple formula, I don't know why I am unable to figure it out. I have 3 fields, a dollar amount (Price) field, a percentage field (Tax), and a calulcated field.…
-
Zip Code Populate city and state?
I am wondering if anyone has create, or know of a way to create this formula. I am trying to create a formula that when a zip code is added to my zip code field,…
-
Change All Table Values by Button
I am looking for formula, that when a button is clicked, it can change the value of all data in the entire table to the same thing. For Example: allrercords('Show Details' := false )
-
Formula to jump to tab
I am trying to create a formula in a field trigger after update, where it will jump to a tab on my table. How do I acheive this?
-
Table Constraints
I am trying to create a table constraint. I have a table named transaction, with a debit account, and a credit account, to move money from one, to the other.…
-
Display first two characters
I am trying to create a formula that will only display the first two left characters from a text box. How do I create this?
-
Default Off Print Attachments
When printing a record, is it possible to set "Print attached images" to unchecked by default instead of checked?
-
Create automatic records
Hello, I am wondering if there is a way, after every 30 days to automatically create a record linked to my main table?
-
Trigger after update previous value.
I created my own audit trail, where when a field is modified, another record is created and linked to that table that records the modification. One example is: (and this action is recorded in a field,…
-
Unique Alpha-Numeric Formula
Hello, I want to create a trigger on create, that will assign a field named "Case Serial" a unique alpha-numeric data. I would prefer if the Case Serial was 12-digits long.…