How to Avoid Drop down in child table in ref column type

[jaichith]

Dear Friends,

     How to Avoid Drop down in child table in ref Column types. 

I have used Valid if = IF(IN([_THIS], PINCODE TARIFF[PINCODE]),TRUE,FALSE)

Valid if errors = " pincode not found"

Both are not working once  column type is changed from number to ref. 

Now I want the input mode as labels (not buttons)  as shown in [remark ] in screen shot. 

 

If the pincode is not found then it should return "pincode not found" 

Please help

@AleksiAlkio @Marc_Dillon @Suvrutt_Gurjar @WillowMobileSys @JSO 

[jaichith]

@SkrOYC @MultiTech @jyothis_m 

Can you please help me with this?

[jyothis_m]

If you make the Type as Ref then i think either BUTTON or DROPDOWN are the only options possible, since you have to select option already available in the Referenced Table or create NEW in Referenced Table

[jaichith]

Then I don't have any other way to go on ?

[jyothis_m]

Keep the Type as Number if you are strict on LABEL type 

[jaichith]

Ok bro.... 😔

[SkrOYC · Accepted solution]

Use two fields.
One of them is the Input field where they can type data in Text/number or whatever format matches the needed one (maybe matching the key column type of the ref table?)
The second one is the Ref one, keeping it hidden and using an AppFormula to take the key from the first field and changing it based on future edits or with Initial Value if you will accept this to be changed just once

[jaichith]

BRO,

        I HAVE CREATE A VIRTUAL COLUMN AND FORMULA = [PINCODE]. 

THE NORMAL COLUMN HAS BEEN CHANGED AS TEXT TYPE AND VALID IF EXPRESSIONS HAS BEEN INCLUDE FOR IT. 

IN SHOW IF CONSTRAINT , I HAVE USED THE FORMULA CONTEXT ("VIEWTYPE")<> FORM (FOR VIRTUAL COLUMN)  AND CONTEXT("VIEWTYPE") <> DETAIL  FOR (NORMAL COLUMN). 

THANKS FOR THE SUPPORT. 

[SkrOYC]

---

@jaichith wrote:

CONTEXT("VIEWTYPE") <> DETAIL  FOR (NORMAL COLUMN). 

---

Yep, well done!
I'd suggest to change it to CONTEXT(ViewType)="Form" for the Text column, so that it just shows inside Forms

[koma25]

Try it

[jaichith]

Dear sir, 

     I couldn't understand what you are conveying to me. Are you asking me to set initial Value ?

What is the logic behind it ? Please help.