if, then not working within a function field script.

The following is code in a field. I want to have the field contain one value if a dynamic dropdown 1 is not empty and another if it is. I store the record ID of records in table A in field BPID1 and…

monthName Format

Hi I would like to return "Jan" instead of January when using the "monthName" function. Any tips?

How to use Date, Start time and time interval Field

Hi all, I'm having problems working out how create an appointment based on a date, start time and time interval. For example. I would like to book in a meeting by putting in the date,…

Dynamic Choice Field text (Value) vs Number - Where can I find them?

I have an excel with Country, Region,District I import this to my GEO table. Then I have a DCF in my MAIN table that show all Countries and I pick what I want.…

Form

How can I disable the resizing form ?

Merging RTF Fields

Is there a way to merge RTF text fields into another RTF text field and maintain formatting? When I merge RTF fields I get one large text paragraph with all CR's removed.

• Answered

In Forms, search for string only returns one record

When I search for a record in a form, the search string is either not found or only one record is shown when the string should be found in multiple records.…

Character Occurrences Count

Hello, I'm wondering if there's a way to count how many times a given character is in a string. i.e.: I have the field 'mytext' which contains a string (let's say "rockandrollwillneverdie") and I…

• Answered

Clear Code for Button?

What is the function and code to use in a Button to clear a field? I want to click a button to clear two search fields.