Somehow does not show a user validated column when entering a value in app

Hi, 

 

I'm trying to draft an app, but somehow when I click the button to add a row in the app on the right-hand side: It won't show the Labour_Type Column that I defined. 

 

See I have 2 tables, one for entering materials and costs, the second is for the labour cost per hr. So I have a text column in the first table, asking what type of labour to be used so that when the user selects it, it auto =lookup's and finds the relevant $/hr. So when entering a value to that column, I had to do data validation, but as soon as I placed the data validation, it removed it from the form submissions in the app? 

DennisYildirim_0-1662637596898.pngDennisYildirim_1-1662637615190.pngDennisYildirim_2-1662637627006.pngDennisYildirim_3-1662637716929.png

 

 

0 1 33
1 REPLY 1

The valid if expression of LIST([Labour Type]) does not make sense as a validation. 

Valid_IF provides validation in two ways - 1) checking an entered value to make sure it meets certain criteria  2) providing a LIST of valid values - however if EMPTY then the there are no valid values and the column will not show by design.

With specifying the LIST expression you have AND not assigning any Initial Value (I assume you haven't), the [Labour Type] column is empty and therefore the LIST of values is empty preventing the column from showing.

Can you explain in words in what way you would like to validate the inserted values for the Labour Type column?

Top Labels in this Space