BillH - profile

BillH · Jul 14, 2023

@Phil_Rose @LarsJohnson I'm not sure who to direct this to, so I hope one of you can help.I need to get some idea of what is going on with the changes that seem to be going on. I have a interface designed for a client, and finally have reached the p...

BillH · Jun 16, 2023

What is the proposed idea/solution?Having the ability to clear unpublished changes on the interfaces has been very helpful, and is in line with many of other development environments I've used. In case I'm not being clear, I'm referring to the litt...

BillH · Jun 13, 2023

Having the ability to clear unpublished changes on the interfaces has been very helpful, and is in line with many of other development environments I've used. In case I'm not being clear, I'm referring to the little blue dot (see below) letting us...

BillH · Jun 12, 2024

Setting the format to 2 decimal places only changes what you see, the underlying amount remains the same. Try ROUND((SUM(.75*{Approved budget}))*100)/100 If that is the only number causing the issue it should work.

BillH · Jun 11, 2024

There is at least one lengthy discussion of options for accomplishing this on the Built on Air slack channel. It's a good source in general for additional solutions, although it's not really an archive since the retention is three months.Anyway, I b...

BillH · May 21, 2024

see https://support.airtable.com/docs/identifying-blank-values#:~:text=The%20BLANK()%20function%20can,is%20used%20within%20IF%20statements.&text=When%20using%20BLANK()%20along,are%20selecting%20aren't%20numeric."NoteWhen using BLANK() along with != (...

BillH · May 14, 2024

You have it right there, but assuming you would want a space use {First Name}&" "&{Last Name}

BillH · May 09, 2024

It looks like your "Revenue AVIDZ" column is a Lookup to a linked table. If I'm seeing correctly you should be able to switch "Total Revenue" to be a Rollup to the same field and set it to sum. Your names will be different than this example, but ho...

User Statistics

User Activity

Changes to Sidesheet Behavior

Clear Unpublished Changes On Record Detail (for Interfaces) - Reposted from Interface Designer

Clear Unpublished Changes on Record Detail

Re: Formula field set to currency with 2 decimal places but getting up to 14 in token

Re: Covert to already Created PDF

Re: Why does this AND function not work and a simplified version do?

Re: Formula - No text format available?

Re: Add numbers in cell