Dynamic Row Key for Forms

[Marius1]

Hi guys.

I am currently working on an app for taking documentationpictures, and i am having an issue with row keys under the view option on some form.

To give you some insight on what i am trying to achieve, i have a list of locations, which when pressed, links to an info page on those site. That works fine. Furter ive put in behaviour that links to a separate tab in my sheet with general info on the different types of pictures that are to be taken. This is in the form of a list, where the user can click on each picture type, to get some info on what that picture needs, and some example photos. On that page, they can click a button, to start taking pictures. Here starts my problem.

What i want, is for the general picture tab, to be used for all the different locations i have. This is to keep the amount of tabs minimal. So ive set up my sheet so that it stores the link to the pictures all in the same sheet, for all locations. So when i go to take a specific picture, i want the view to ref to the row of the location. Basically making the row key dynamic to the row ive clicked earlier in the path. So far ive only been able to hardcode rows, but that will only bring me back to the same location, no matter which row i click. I might be explaining this whole thing badly, but hopefully you get what im trying to do.

I will happily try to explain it in a different way if anything is unclear.

Thanks for all help!

[Suvrutt_Gurjar]

Welcome to the AppSheet community.

If you could explain with the help of your relevant table structure and a few relevant screenshots, the community could help you better.

[Marius1]

Hopefully my explanation makes sense in the replies, let me know if theres anything else I can do to clarify

[Suvrutt_Gurjar]

Thank you @Marius for all the details. I am afraid, it is still not clear, at least to me, the exact relation between the two tables and the functionality you wish to achieve.

However, it sounds that you are probably looking for either [_THISROW] functionality or referencing between tables. Please take a look at the below articles/tips and tricks.

About [_thisrow] Questions

hello, i need some explainations about this formula : concatenate("A: ", [_thisrow], " B : ", [_thisrow].[statut] , " C : ", [key] , "D : ", [statut] , " E : ", [key].[statut]) Result : A: apBFg1Mt B : C : apBFg1Mt D : Pending E : I don’t understand why there is nothing in B and E EDIT : i change my formula, [etat] was a mistake, it’s [statut]

When to use [_thisrow] Tips & Tricks 💡

[AppSheet Explained | [_ThisRow]] A very common question, here’s a short video in an attempt to answer this question. (I’m not satisfied with this video, I will do another at some point) Short Answer: When you need to pull data from the table where the formula lives When you’re building a SELECT() formula: [Shared with CloudApp]

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

[Marius1]

Of course.

Ive set up some moch sheets that show the structure of my main table, and the table i referance for the picture guide.

The LocationId is the identifier used for each location. Pic X are the different pics to be taken, and the numbers represent each picture that can be taken for that photo. Since some of the pictures need several angles i need the option to save several pictures for each picture type.

It wont allow me to post with more than one picture since I am a new user, so ill split up my post.
I am brand new to appsheet, so i apologize if im going about this whole thing wrong.

[Marius1]

Here the index is the identifier for each picture, the menu text is the type of picture to ba taken, examples is a description for what information the pictures should have, and then some example pics.

My idea here is to use this simple table as a referance for each location, then link back to the part of the main sheet to store the images.

[Marius1]

This is the main page of the app, where the user can select the relevant location they want to take pictures for.

[Marius1]

This is the detail view of the main page, with some general information, and a button that takes them to the picture guidance.

[Marius1]

Overview of the different pictures to be taken for each location. This is a view from sheet2

[Marius1]

Detail view of each picture type. Giving the user some information on what the picture is, and some examples. The button links to a view for each picture, where i need it to link to the correct LocationId

[Marius1]

I figured out I can use the “Row Key” under view options to tell appsheet which row to go to, but i need it to be dynamic according to which LocationId the user clicked at the start of the app interaction.