In a long text field is there a way to create a global entry text for some headings so that whenever I want to enter new content i don't have to enter the headings as well? For example, the headings I use are:VOA ITZAVOA Total sqftML ITZAML Total sq...
The field entries are £20.49 and £13.66 (both fields set to 2 decimal places) but in a third field when I use CONCATENATE this is what I get:Summary: Headline £15000 pa Actual £9975 pa £20.491666666666667 £13.661111111111111How do I get £20.49 and £1...
Scenario:CONCATENATE(Town, "-", Address, "-", {No / unit})displays for example Town-Address-100Question:: I would like the display to appear as Towm Address 100. How do I enter a blank space between the field items rather than a - ?tia
Before the forum goes down temporarily I’d apprecate please help for how to use OR in a formula field.
Example: three fields:
Number 1
Number 2
Total
I want to enter a decimal number is Number 1 or Number 2 (but not both) and have the result displaye...
I have three fields, two are field type Number, one is Formula. The objective is the sum of the numbers in the result field.
(1() enter W, (2) enter D, (3) result (W*D)
In fields (1) and (2) I have selected ‘allow negative numbers’
Each row has for f...
I should also find colouring field columns very useful, especially for separating field names into different themses or sections. Currently the only way, (at least the only way i have found) to separate columns is to insert a blank column between th...
Thank you. I am familiar with ROUND, having used it for calculations in a Fielemaker database.Frankly I was hoping to be provided with the answer on a plate rather than having to work it out for myself. Telling me about ROUND was very helpful, thank...
Apologies but i still do not understand.ROUND(Description, " ", {Total sqft}," ","at"," ","A/", R, " ", "= ", {enter sum ITZA sqft}," ", "sqft", 2) displays as Error I am not trying as John B2 suggests 15000" to "9975" to make "150009975" but to disp...