Specific vehicle image to be viewable when specific combination of variables are present

[Jean_Woods]

I want a specific vehicle image to appear when specific variables are selected in form view.

So I would type in the year using the Text TYPE then select the MODEL, MAKE, and COLOR using the Enum TYPE:

This would then show a matching image in both the deck view and details view once summited.

Thank you very much!

[shahappsheet]

Hi!

Good day.

I think LINKTOROW should be fine. If you want to use FORM View then you suppose to need a table only for keyin the FOUR parameters.

[Jean_Woods]

Thank you very much for the response.

I don’t seem to understand. I have two data tables. One table for storing the vehicle information. One table for storing vehicle images. I often get the same vehicle year, make, model, and color in my inventory. I want a stock image of the vehicle to be automatically viewable when matching variables are inputted. I don’t need to see the image in form view. Just in the deck and details view.

It would work just like going to a car sales web app and selecting the different variables on a vehicle, which then displays an image of a stock photo for the vehicle.

[WillowMobileSys]

Jean_Woods:

One table for storing the vehicle information. One table for storing vehicle images. I often get the same vehicle year, make, model, and color in my inventory.

In your Image table you need to make sure that you include columns for all of the vehicle attributes you wish to match by - year, make, model and color.

In the Inventory table you would also have columns for each of these attributes but also include an Image column. In the Inventory Image column, you will want to set an App Formula to be something like this:

SELECT(Images[Image], AND([Year] = [_THISROW].[Year],
                          [Make] = [_THISROW].[Make],
                          [Model] = [_THISROW].[Model],
                          [Color] = [_THISROW].[Color])
)

I hope this helps!!

[Jean_Woods]

Thank you so much for the help! After a bit of changes, I was able to get it to kind of work. The issue now is that instead of the image being visible, the image hyperlink information is the only thing that appears.

Is there a step that I skipped

Thank you for the help!

[shahappsheet]

Actually directly dropbox link doesn’t work for appsheet, so far I have seem from my experience. You suppose to have a physical address of the link such as " Software Banner_Images/Inventory Management .Logo.120204.png". You can find in your image address there is no mention of image name. Actually that one works only for dropbox. Dropbox can manage that one for its viewing. If you browse to the dropbox, it will not work so far.

[Steve]

Your column named Image must be of type Image.

[Jean_Woods]

Steve. I tried it. But anything other then a List Type: results in the bellow message.

SELECT(VEHICLE IMAGES[Image], AND([YR] = [_THISROW].[YR],
[MAKE] = [_THISROW].[MAKE],
[MODEL] = [_THISROW].[MODEL],
[COLOR] = [_THISROW].[COLOR])
)

[Steve]

help.appsheet.com

ANY()

One arbitrary list item

[shahappsheet]

Hi Jean!
@WillowMobileSystems is correct.
It seems to me it is your deck view.

If the following is your detail view then no need any expression. Automatically, it will goto its detail view once the row of the deck is selected.

But the main issue is that I couldn’t get your point precisely yet. If you want to filter your existing data that contain same car several times. Then I think you need a separate table only for the targeted parameters and create a FORM. And create another detailed view using a slice having filtering condition. In the FORM your need to select the Detail View in the Finish View option, so that the view will be appeared once the submit button of the FORM is Clicked. I suggested though you mentioned you don’t need to see in the form. But I cann’t understand how you can filter.

FROM JEAN: I want a stock image of the vehicle to be automatically viewable when matching variables are inputted. I don’t need to see the image in form view. Just in the deck and details view.

If the data structure is available, people can suggest more precisely. If the two table have relationship then you can use the Inline View also for your purpose.