Hello, I am still pretty new to AppSheet, but...

references
(Carlos Rivera) #1

Hello, I am still pretty new to AppSheet, but I have having some issues trying to edit Reference Views. Any ideas on where / how to edit this? I would like to hide a few items and place text heads on some of the columns. Thanks!

(Aleksi Alkio) #2

One way is if you set your columns manually from the detail view’s definition. The option name is “Column order”.

(Steven Coile) #3

To modify the order of columns as they appear in forms, you can either reorder the columns in the spreadsheet and Regenerate the columns in the app editor; or you can define a slice and reorder columns there. Over the long-run, slices are the way to go, but there is a learning curve.

To modify the order of columns as they appear outside of forms, you can use the options for forms as above, and/or use the various options available in the view definitions themselves. In my experience, I’ve found it best to use the view definition to control column ordering outside of forms.

To affect the column headings, the only option you have (short of renaming the columns) is to use the Display Name and Description properties of the columns. If I recall correctly, Display Name (if defined) is used in place of the column name anywhere the column name would be presented to the user; if Description is defined, is supersedes Display Name in forms only.

In the formula for the Display Name and Description properties, you could also use the CONTEXT() function to conditionally change the text according to the view type or view name. This is an advanced approach and gets riskier the more complex your app gets. I mention it for completeness but don’t recommend it.

(Carlos Rivera) #4

Thanks Steve / Aleksi. This helps, but doesn’t quite solve my problem. I am trying to change the “Related” header in my reference table. For example, I have two data sets. One table that contains gym locations. The other contains “Scheduled games” at the location.

In the app, I am telling the locations to display the games tied to a location. When I create this relationship, it is creating a “Related” view but calling it “Related Games”. I want to change the name of “Related” to “Scheduled”. See attached screen shot.

Also, I still can’t change headers in the “related games” view. If you see where it reads “Basketball” in the UX view, to the right of that there is a 0. That zero indicated number of people who have signed up for that game. I want to display that name.

Thanks again for your help!

#5

Hi @Carlos_Rivera You can change the name of the virtual column . Just click on the edit button next to the column and change it to whatever you like.

(Steven Coile) #6

Ah, OK. I suspect your ref view has a Display Name of its own defined (in the view’s DISPLAY section). If so, change it there.

(Steven Coile) #7

You said:

Also, I still can’t change headers in the “related games” view. If you see where it reads “Basketball” in the UX view, to the right of that there is a 0. That zero indicated number of people who have signed up for that game. I want to display that name.

Do you mean you only want to display the name, Basketball, and not the number of people signed-up? That’s straight-forward: in the ref table view, go to DISPLAY > Column order and include only the column(s) you want.

(Carlos Rivera) #8

Thanks +Steve Coile. The Display Name was exactly what I needed! Thanks to all for the help!