S Moore
-
Round up or down
I am trying to create a formula (time) that will round up to the nearest 15 minutes, so 9999002000000 for on the hour, 9999002900000 for quarter after, 9999003800000 for 00:30,…
-
If/Then Time Statements
I am creating a button to determine if something was completed early, on time, or late. The fields I will be working with in this formula are: 'Quoted Completion' and 'Timeliness' When the button is…
-
Formula to Round Up Time
I have a dropdown of "Choose Time" The optios are: 30 Minutes, 1 Hour, 2 Hours, 3 Hours, Overnight I also have a date and time field named "Quoted Completion" When I choose a timeframe in that…
-
Text Input Popup
Is there a formula that when a button is clicked, I will get a popup (similar to alert("text") ) to type in my value to copy over to a field? I am trying to insert a comment on a record,…
-
NINOX 2.5.0
I just downloaded the new beta of Ninox 2.5.0. What is all the the features that have currently been implemented? Also, I noticed that I can change the style of Head and Free text in the beta.…
-
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?