Get text value from an enum column

[GSConseils]

Hi,

My context is the following, I got :

• a column A
  • enum type
  • Base : text
• a column B
  • enum type
  • Base : text

User selects a value for column A, two cases :

• or value of A does not require B
  • then field B does not appear in the form (this works fine)
  • but value of B should become = value of A
    • this is my issue
    • I tried Initial value for B = [A], but it does not carry the value 😞
• or value of A requires B
  • then column B appears in the form
  • then user selects a value for B (this works fine)

Is my issue due on a value still not recorded ? Or because of enum type ?

Any help would be appreciated

Thanks

[dbaum]

What you describe sounds to me like it should work, although others may be able to discern the issue. If you post screenshots of the column properties for the 2 columns, someone may be to able to identify a detail that you're overlooking. For instance, ensure that the values from column A that may need to populate column B are indeed included among the valid values defined for column B.

[GSConseils]

Hi Dbaum,

thanks for your suggestion.

Here are the screen copy of the column A :

and the column B:

I may have to add more details.

• Column A offers to select a site
• Column B offers to select a sub-site

Then the user may select a Site for A, and a subsite for B

• But some sites (col A) don't have subsite, then , in this case
  • B does not appear in the form
  • I want to populate B with A
    
    
• Otherwise, 
  • the user select A with subsites, and B

Thanks

[dbaum · Accepted solution]

You should add a screenshot of the Valid if and Initial value properties for column B to confirm whether there are any issues there.

Also, in case you didn't realize, you could consider creating a Subsites table (with columns for ID, Site, and Subsite) and using the Dependent drop-downs technique for both column A and column B.