Michael_Lever - profile

Michael_Lever · Jan 17, 2023

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...

Michael_Lever · Dec 23, 2022

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...

Michael_Lever · Dec 11, 2022

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

Michael_Lever · Nov 24, 2022

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...

Michael_Lever · Oct 24, 2022

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...

Michael_Lever · Jan 20, 2023

i have never used an automation so will try, thank you.(My solution is to use Textexpander)

Michael_Lever · Dec 28, 2022

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...

Michael_Lever · Dec 28, 2022

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...

Michael_Lever · Dec 27, 2022

Sorry about the spelling mistakes, nowhere to edit after posting!

Michael_Lever · Dec 27, 2022

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...

User Statistics

User Activity

Long text field - template wording

Field entries are £20.49 and £13.66 but in a third field when I use CONCATENATE …

CONCATENATE - blank space between

Formula question OR

Negative number calculation question

Re: Long text field - template wording

Re: Background colour of fields

Re: Field entries are £20.49 and £13.66 but in a third field when I use CONCATENATE …

Re: Field entries are £20.49 and £13.66 but in a third field when I use CONCATENATE …

Re: Field entries are £20.49 and £13.66 but in a third field when I use CONCATENATE …