K_B1 - profile

K_B1 · Jul 24, 2024

I am trying to generate a formula where:1. If date in field x is greater than 1953, then 1 is put in field zOR2. If checkbox is checked in field y, then 1 is put in field zI came up with this formulaIF(OR({NO DIGITAL} = 0), ({CODE-DATE} > 1953), "1")...

K_B1 · Mar 01, 2024

I have a Long Text column in my table with a lot of text, likely 20K plus pages. I used formulas to clean this text, removing undesirable characters, extra spaces, etc. Is there any way to copy the contents of the Formula column back to the Long Tex...

K_B1 · Feb 26, 2024

I am working on a formula that1. Trims2. Replaces Double Quotes (") with Apostrophes Quote (')3. Replaces Ampersands (&) with 'and'.TRIM(SUBSTITUTE(SUBSTITUTE(DESCRIPTION, '"', ''),'&','and'))The above works, except, if I change it to include the Apo...

K_B1 · Jul 24, 2024

Got it working. Thanks!

K_B1 · Jul 24, 2024

what if I want it to do nothing if both statements are false?

K_B1 · Mar 02, 2024

I think I understand what you mean. If I write a formula like this Trim(DESCRIPTION), it does indeed work fine. The problem is, it isn't editable. What works is converting that field into long text, then renaming it. It's a bit onerous, but works.

K_B1 · Apr 05, 2020

I am adding my own request to this list. Not sure why it is still missing, this is an essential database feature.

User Statistics

User Activity

Formula, If / Or Help

Copy Column with large amount of data

Trim and Substitute '

Re: Formula, If / Or Help

Re: Formula, If / Or Help

Re: Copy Column with large amount of data

Re: Would love a find/replace option!