Data display depending on choice

Hi,

I have a case where I need to display text from the base when Country and Type are selected in the choice button. How to do that?

Always I have a first row and in text filed I cant use fitler.

Make a text or hint box with the Description text. Only show this when both Country and Type are not empty.

I tried this but doesn’t work because I can’t use function Filter Data.

I’m not sure I’m following.
Why don’t you only show component/text when both Country and Type are not empty?

Am I misunderstanding something?

Screenshot 2022-12-08 at 10.32.36

In the table that you are writing those choice selections to, you need to create a template column that joins those two selections together, and then create a single relation joining the template column to the name column in your Visas table. Then you can create a Lookup column that return the appropriate Visas column value.

Sounds great, but I dont see my choices in column chociceCountry (user-specific). I can use this data only in Screen option. Like on the image. May be the reason is that my choices are in form container?

I missed the fact that you are within a form. When you are in a form container, a record isn’t written until you click on submit. For that reason, a relation and lookup will not work because it doesn’t have a row with those selected choices for the relation and lookup to work. It’s not until you submit the form, that the values are written and the relation/lookup populates.

In your second screenshot, I’m not sure what you are trying to do. It looks like you are trying to filter your list of choices??? This wouldn’t help to get the appropriate value for your hint component. At most, it will reduce the list of available choices.

I think there are a few things that don’t look right.

  • First, is the Visas table really where you want to write new rows when a user clicks on submit? That seems odd to me since you are trying to use the same table to retrieve the type description.
  • Second you mentioned that you are writing your choices to user specific columns. In the past, that has never been an option when adding new rows. Regardless, if you are adding individual rows, then why does it need to be user specific columns that you write your choices to. Normally, you would fill regular non-user specific columns since each submission writes a new row…and in those cases, you would typically include the signed in user’s email when writing the row.

If you stick with a form container, you will not be able to populate the hint component the way you want.

  • One solution would be to create a collection or even a custom collection that would show all rows from the Visas table. Then filter that collection based on the screen values from your selected choices. If you use a custom collection, then you could place a hint component within that collection and it would retain the look and feel that you are going for.
  • Another solution would be to get rid of the form container and instead use a regular container. In that container, place your choice components and have them point to your user specific columns. Then you should be able to create a relation/lookup to retrieve a value to use in a hint component. This works because the choices are updating the user specific columns in an existing row in real time. Since the values are written to the table in real time, then the relation/lookup will return the appropriate description. Then you can add a button that will write those selections any table you want. This is typically what we call a custom form.

Like I said, there are a few things that don’t quite make sense to me with your current setup. For that reason, it’s hard to say what is the best approach, but hopefully the information I provided above will help you out.

2 Likes

@Jeff_Hager
Jeff - Thank you, I realized my mistake.
I used Custom Collection and created whole form also I added columns (user-spec) in user table. Now looks and work very well :slight_smile: Thank you one more time! :slight_smile:

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.