# Formulas & functions

## Conversations

Recent Conversations
Conversations 31 - 45 of 3018
###### "save & keep working"
In spite of what the updated documentation says, clicking the new "Save & Keep Working" button reloads the page, AND also keeps the curre...
• 2 me toos
• 4 replies
• Question
• In Progress
###### How can I get the text of a number in the way one would speak it? For example \$100.00 = One Hundred Dollars
I could do it with this formula! var text numt = ToText(Floor([Number]));var text cents = If(Contains(ToText([Number]), "."), Left(Right...
• 3 me toos
• 4 replies
• Question
###### ToNumber function keep failing when using formula to create gauge chart
I am trying to create a gauge chart by using formula-numeric-percent. The formula is based on the division of 2 ToNumber functions. The r...
• 1 me too
• 3 replies
• Question
• In Progress
###### Copy Button Code Help
Hi,I am making a copy button using one of Dan's pasties to copy text directly from a field because highlighting it and copying doesn't se...
• 1 me too
• 2 replies
• Question
• In Progress
###### Is there a way to have a summary report calculate the variance of the difference between sums?
Basically I need the variance to be calculated as the following:FTE Target - FTE Sum (Filled) - FTE Sum(Open) = Variance. In which case w...
• 1 me too
• 2 replies
• Question
###### Filter Report by Record ID#
I have a table with near 15,000 records and would like to export all of the records. With the 5,000 record limitation for export, I thoug...
• 1 me too
• 2 replies
• Question
• In Progress
###### How to add a filtered report into a body of the outlook email
I would like to add a certain report into a body of the email. I created an email button to populate the subject and send to. Now I want ...
• 1 me too
• Question
• In Progress
###### How can I send a notification to a specific email direction with specific data?
I have a need with a notification: Example: I have a field Supplier with values "A", "B", "C" and "D" ( these are emails and it is a te...
• 1 me too
• 7 replies
• Question
• In Progress
###### Button that adds the total of a numeric field to another
I couldn't find a post with similar details, but apologies ahead of time if this is a duplicate.I am wondering if it is possible, or more...
• 1 me too
• 2 replies
• Question
• In Progress
###### Formula URL that Saves record, then, after saving, edits the record, saves again and refreshes the page
Here's what I have so far. The problem is that when you click this button on the form, any changes you made before clicking this button d...
• 1 me too
• Question
• In Progress
###### Entering Date/Time values that include a timezone offset into Date/Time fields?
I have the need to handle imported date/time values that include timezone offsets I'm hoping at least one of the following is possible:1....
• 1 me too