How to change default column on REF type? By default never show what i need Iโve tried to use in VALID_IF formulas as
=select(products[product],true) =products[product] =products[product],true and others, but no one works Using this get the msg โInvalid Entryโ and block Living clear, by default, works very fineโฆ but shows the column ID
Can you make the column you refer to the key?
When you want to add a formula into the ref columnโs Valid_If option, you should always choose the key column likeโฆ SELECT(TableName[KeyColumn],โฆ) It will then show you the list of key columnโs values. If you have chosen a โLabelโ in your column structure, it will show you the Label instead of key columnโs value. When you save the record, it will save the true key value into your database.
@Aleksi_Alkio i have seen such problem since my begin with appsheet, months ago. I try to test with one new app, but get always the same situation.
What is your account ID number and app name if I check the reason?
@Aleksi_Alkio 593499 SolarFilm Control Translate
@Aleksi_Alkio so using the label is for appsheet view only, right?
Correct
hi @Aleksi_Alkio ,thanks but doesnt work like thatโฆ ive tried to mark Label but system do not accept.
@Aleksi_Alkio Is when i use " select(table[column]) in valid_if,
i get such msg "invalid entry
@Aleksi_Alkio Using clean valid_if works fine but now shows me the column image + productโฆ But write the column IDโฆ
@Aleksi_Alkio for now i create one solutionโฆ i did another column called nameproduct to get the name referenced to the id of REFโฆ and just leave the REF showing image + product (in bold, very niceโฆ I want to know how to do thatโฆ)
You need to use at least something in your condition check likeโฆ SELECT(Table[Column],TRUE)
yes i didโฆ many times, and a lot more. But that i have seen all the time in every where i readโฆ but never works like thatโฆ ever get errors
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |