Form with input that allows user input but also has initial value controlled by enum

[leonsteber]

Hello good people.

I have a form with an input that shows a rainwater tank's last water level. The user can change this level but also has the option of setting it to FULL or EMPTY (an enum). 

See the video: https://drive.google.com/file/d/1H-vxKSYRlMmtBnbTG4gx8d-hckZCP8C3/view

The FULL and EMPTY works initially but as soon as the user manually adjusts the value, the enum FULL and EMPTY no longer works.

I've tried playing around with the Reset on Edit but can't get it to work. 

Is it possible to have the enum FULL / EMPTY change the value at any time regardless of whether the user has modified the water level?

EDIT 1: There are several different tanks so FULL and EMPTY values change with each tank. Can't use RANGE, as I can't change min/max and when I'm working with max values like 3645mm.  I've already set VALID if so user can't set value outside of the FULL/EMPTY.

EDIT 2: The reason for having EMPTY and FULL is so that the user, when out in the field, about to pump water to a tank, can quickly show if that tank is FULL or EMPTY. I have several tanks and the values change for each, for instance FULL may not always be 0mm from the top of the tank, it may be 30mm.

[peterson]

Why not to use the number in a range format? It would be better!

[leonsteber]

Good idea, and looks good, but I need different minimum (empty) and maximum (full) values for each tank.

The example I gave I made very simple but in my version the different  tanks  have different full and empty values according to their dimensions. At first glance it doesn’t seem like I can dynamically change the RANGE max and min?

[peterson]

In this case why not use the valid if ? You can use some conditionals to determine the min and max according to the enum chose...

Maybe use IFS() expression 

[leonsteber]

No I already tried this to make sure the user doesn't submit values outside fo the FULL/EMPTY range.  I suspect it's more likely to do with a RESET on EDIT expression but can't figure it out as it works at the start but won't reset again once I'm in the middle of editing the tank level

[CleanSheets]

Hi @leonsteber,

What if you had a (third) formula field showing the outcome (e.g. 100 or 0 or 37 or 48 etc)?

It shows all the time and is below the Full and Empty buttons.

If Full or Empty is not selected, a different manual entry value field is shown to the user via a Show_If() formula, otherwise it's hidden.

Then the formula for the final value field can be calculated dynamically.

If you didn't want to change your initial design of the one entry field, you could still introduce two Action buttons and remove the Enum buttons. If the field is 100 only the Empty button would show, if it's 0 only the full button would show, if it's a number then both would show. When pressed it sets the value back to the corresponding 0 or 100. 

Cheers 🙂

[leonsteber]

Understood on these two options, thank you.

Adding action buttons means I can no longer use the "form" view and adding an extra field I'm not fond of as my forms are already a mess of info already (haha).  I'm starting to think that I will leave my form as is, I was hoping to not mess with the visual aspect, just adjust a formula but I'm starting to think it's not possible.

Cheers!