I want predefined keyword to fetch when we select options from drop down

AppSheet AppSheet Q&A
,
1

HI friends,

Suppose i have options

  1. John

  2. Martin

  3. Alex

as dropdowns

so as i choose the dropdown, in the next TEXT type field, a predefined keyword must appear.

Example :

Select John then its keyword JH must appear in next text field & same for other options also

2

Hi @pcreport

Would this help you?

Re: How to calculate a result based on values in a… - Google Cloud Community

1 Like
3

Thanks a lot for your reply..

its working but the virtual column is uneditable. So i need a field which is editable, as user will input some numbers ahead of the code.& after adding the code, appsheet will also check whether this new num is unique or not…

i dont have an issue adding extra new column in google sheet for this purpose..

4

OK.

Then you would need a real column, with the expression in the “INITIAL VALUE” field.

1 Like
5

ok, but for every option , how would i set an initial value. Pls guide me here

6

Hi @pcreport

  1. let’s name your dropdown column detailed in your first post “people”. This is ENUM type, with options values: John, Martin, Alex

  2. Add another column in your sheets, and name it “result”. This is TEXT type, for the example.

  3. regenerate the table structure.

  4. go in the INITIAL VALUE field of the column “result”, and set this expression:

Aurelien_0-1678866887909.png
Aurelien_0-1678866887909.png1348Ă—171 13 KB

IFS(
  [people]="John", "J",
  [people]="Martin", "M",
  [people]="Alex", "A"
)
  1. give it a try on your app
1 Like
7

hi, appreciate your response.

The newly created entry shud also be unique, like it should not be there already on google sheet (at the backend).

8

What did you try so far?

9

I tried The one u listed..

10

Hi @pcreport

This ?

Can you share a screenshot of your columns in your app editor?