Problem with input validation

[Hernan_da_Silva]

Hello,

I have a problem with one of the forms of my app.
First, i will introduce the model to contextualize:

• Surveys table: store data about surveys (including Instruments used)
• Instruments table: has all the instruments with their info (pulled from another database)
• Instruments used table: instruments used on surveys (1-N relation to surveys, survey can have many instruments used)

The form to add instruments used to the survey works the following way:
User chooses to add one:

Add form opens with a dropdown input that has to be completed by the user with the code that identifies the used instrument:

This dropdown is an enum that takes codes of instruments from instruments table.
When a code is selected, all the data for that instrument pulls into the fields of the current form.

It works perfectly

But fails for no reason when text is large (or at least that seems to be the pattern)

In this example the field “modelo” fails, not sure why, but it happens with other fields.

I checked:

• The same data type in both tables for the fields that have this errors, they are LongText.
• No valid if condition

Any clue what may be the cause?

Thanks!

[WillowMobileSys]

Hernan_da_Silva:

Any clue what may be the cause?

What data type are you using in the [Modelo] column shown in the Form? Is it a REF column?

[Hernan_da_Silva]

Model has the same data type in both tables is LongText

[WillowMobileSys]

Hernan_da_Silva:

Model has the same data type in both tables is LongText

Ok, but in the Valid_If you have shown this expression:

Hernan_da_Silva:

I assume this is used in the column [Modelo] you are having problems with?

Does this value:

exist in the [codigo] column being listed by the SELECT expression?

[Hernan_da_Silva]

WillowMobileSystems:

Ok, but in the Valid_If you have shown this expression:

Yes, maybe that is not relevant.

WillowMobileSystems:

I assume this is used in the column [Modelo] you are having problems with?

Not quite,

LOOKUP([_THISROW].[codigo], “Instrumentos”, “codigo”, “modelo”)

This is used on modelo.

Hope this helps.
Thanks!

[WillowMobileSys]

Hernan_da_Silva:

LOOKUP([_THISROW].[codigo], “Instrumentos”, “codigo”, “modelo”)

This is used on modelo.

I think this helps explain why its marked as invalid.

The Valid_If expression, noted in your post, is returning a list of values from the column [codigo]. It should return the list of values from the [Modelo] column.

Because you are using an App Formula to assign the [Modelo] value, there really is no reason to have a Valid_If expression listed. Remove the Valid_If and you should be good.

[Hernan_da_Silva]

The valid_if expression is returning a list of codigos (codes) because that valid_if is for the column codigo.
The AppFormula is for field modelo, and is working fine.

Logic is right, my question is about the error that pops when text on modelo is too large.

Thanks for your help!

[WillowMobileSys · Accepted solution]

Hernan_da_Silva:

Logic is right, my question is about the error that pops when text on modelo is too large.

So you DO NOT have a Valid_If expression assigned in the [Modelo] column. Ok got it.

Check to make sure there is no MAX character length set.

The text you have shown is not too large for a Long Text column. I don’t believe that is the issue.

[WillowMobileSys]

Here is an example entry for a Long Text I inserted - your text PLUS a whole lot more. No error message.

[Hernan_da_Silva]

WillowMobileSystems:

So you DO NOT have a Valid_If expression assigned in the [Modelo] column. Ok got it.

Check to make sure there is no MAX character length set.

The text you have shown is not too large for a Long Text column. I don’t believe that is the issue.

You are right, cant believe that was the error, i assumed longText type would set max character to a large number and didnt even thought about checking that, it was set at 30 char limit, maybe because previusly it was text type…not sure why.

Thank you very much for your time!