6 - Interface Innovator
since ‎Jul 02, 2019
‎Jan 11, 2024

## User Statistics

• 27 Posts
• 0 Solutions
• 35 Kudos given

## User Activity

I hope I put this question in the correct area.I am developing a base to use for a contracting business, and I have a column for Distance Driven to job (to calculate fuel used in a different column)when I create the job for the client, it auto inputs...

## How do I put a shortened version of an address into a formula?

I have a formula for my primary field that looks like this: CONCATENATE({Last Name}, " - ", Type, " - ", DATETIME_FORMAT(Start, ‘MM/DD/YYYY’), “-”, {Job Address}) and it turns out looking like this: Thorton - G, DS, GC, - 08/17/2020- 692 Chateau Ln. ...

## Fill a Form View for IOS

I was so disappointed when I finished my base, downloaded the App on my Cell… Only to realize that I couldn’t just click the form view on my cell and start inputting items into my base! What the heck! Seems like such a simple- No brainer thing to hav...

## Column Totaling Many Column fields

Ok, so I have a total column in which I have Sum()ed many column fields in it, to be used as a Rollup column on another table. it looks like this: SUM({5" }+{6" }+{DS\$}+{Elb }+{IN/M }+{O/M }+{Endcaps }+{H/H }+{Wedg}+{Off\$}+{B/P\$}+{D/E\$}+{Screw\$}+{12"...

## If (field name) is multiple of 4, Round up?

Hi again, Trying to write an IF statement for a cost catagory. This is what I have now. {12" GH} * 25.0 BUT I would like it to say: IF ({12" GH} is a multiple of 4, * 125, (Roundup ({12" GH}) * 25))) If the field is NOT a multiple of 4, I’d like it t...
Kudos from
Kudos given to