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...
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. ...
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...
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"...
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...
I tried using this formula to extract just the City from a (Job Address) Column and it just returned an error:Left({Job Address}, SEARCH(",", {Job Address}))I used the Comma to search because it was the only Comma in the whole address, and it was dir...
When you Group things, the numbers columns automatically pop up with a line that you can select what you want it to do for that whole column of records in that group. You can tell it to Sum, or average or whatever that column within the group of rec...
Also the fact that when I went to so much trouble to HIDE specific stuff in each record in a certain view… they Open a view with their IOS, then open a record. it shows them Everything in that record… Not just the visible fields. ALL the hidden ones ...
