Hi everyone,
I´ve been going around this for days, hope someone in the community can help me out.
So I have a Services Table, where each service is assigned to a Operator, and a correspondent commision to be payed to the operator, as well as the Status for that payment (Yes/No).
I´m looking for a way to have a form, with an EnumList with all the commisions that have been unpayed by driver.
For number 1, I have tried a Ref column, but that doesnt allow multiple selection. I tried EnumList column with Ref type. And didnt work either. I tried regular Enum List, but Im not sure why the SELECT formula is not working, Error: Column type does not match, although all column types are set to the same (number)
2. Haven´t gotten here yet, as I´m still stuck with the EnumList.
3. I was able to set up an action to do this, and can actually do a bulk status change from a table, which is fine, but I need also to register a signature from the operator accepting that payment, that´s why I need a form in the first place.
4. Haven´g gotten this far yet either.
Fingers crossed, i hope this is possible with AppSheet.
Thanks!
Solved! Go to Solution.
EnumList base type Ref does indeed need to have its available options manually specified, contrary to a standard Ref type field.
Try this in Valid_If:
FILTER( Servicios , [Pago comision] = “falso” )
is [Pago comision] a Text column, or a Yes/No?
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |