I have a column [Tipologia viaggio] with two enum to be chosen. Once the record is saved if I edit it again and try to change the data in this colum the answer is that it cannot be saved:
This columne [Tipologia viaggio] is linked to the column [Costo] in which I make some calculation depending on the field value.
Auto Compute field of [Costo ]“if(([Tipologia viaggio]=“Viaggio per Sophia”),0, [Durata Decimale]*0.50+[km percorsi]*0.25)”
How can i change things so that field value can be changed nd saved?
We need more details. Could you provide a screenshot of where this is happening for you>
I edited the row I wanted to change
And when I want to change it to “Viaggio personale” this happens:
Moreover … if it was the other way around I could understand somehow becaus when I hit “Viaggio Personale” there it open the related table. But on “Viaggio per Sophia” there is no related table averithing remain in the main table.
You need to checkout the Editable_IF, Valid_IF and Suggested Values on that column. Assuming its a simple ENUM column. Otherwise it might be you’re using a ENUMLIST to pull up a list of Ref values and now one of those Ref values doesn’t exist.
Simon, 1minManager.com
1 Like
Thanks Simon,
My Column is an Enum, with 2 values (Button Input mode).
There is no Valid if and no editable if. Its a Required value though.
Depending on the values … othe column behave in a different way:
The Auto Compute field of [Costo ]“if(([Tipologia viaggio]=“Viaggio per Sophia”),0, [Durata Decimale]*0.50+[km percorsi]*0.25)”
And in the [Related Viaggi Split] has in Sow_if: [Tipologia viaggio]=“Viaggio Personale”
And Valid_If: ISNOTBLANK([Related ViaggiSplits][Passeggero])=“yes”
