Hi, I have a question about references.
I have a spreadsheet that is labelled Employee Reviews and it has a column โNameโ that is referencing another spreadsheet in my app called โstatsโ. This adds an inline view at the bottom of each of my stats pages with a chart.
I would like to have my spreadsheet โEmployee Reviewsโ references a spreadsheet called โprevious Pay periodโ but then add the inline view to the bottom of my โstatsโ view stillโฆ How can I do that since I am no longer directly referencing โstatsโ?
Could I have two reference points on one table that each link to a different spreadsheet?
@Timothy_Martin Yep, thereโs no limit on the number of reference columns a table can have.
@Timothy_Martin It sounds like you need to add a reference column to your stats table from the table that you want an inline view of. I canโt say how to do that, because I donโt know the details of your app.
But if you want to have an inline view of TableX show up when viewing a record of your Stats table, youโll need to add a reference column to TableX that references your Stats table. This could be a virtual column
with an app formula.
I have a table that shows my employees what they have made for money. I have a table that shows them what they have done for stats. I have a review form that references the stats table to populate the form with their stats and saves it into a spreadsheet. I then want to take the reviews and add that inline view to the bottom of the table that shows what they have made for money. All of my tables have a [name] row.
Currently it will take the reviews inline view and it will show it at the bottom of the stats page for each rep because that is the one I have referenced. If I add a second reference to say my email column that each table has it shows that there is no data.
???
@Timothy_Martin Itโs still difficult for me to figure out the layout of your data, so I canโt give any more precise advice than I gave above. If all of your tables have the same [name] column, then consider making that column a reference to some central table, maybe?
If I have two references and they both have the same columns, how does it know which one to reference
@Timothy_Martin The two reference columns will store two separate values. When adding a new row to your table, there will be two dropdown menus where you can choose each reference value independently.
I apologize for sounding dense but I canโt seem to get this to work. Each column only has one reference you can set in
the columns definition section. I have that setup properly. I want to take my inline view and now attach it to the bottom of another slide in the app. Since I have already references the colmn it is showing in the bottom of the slide that I referenced but how can I get it to show elsewhere.
I want to take that inline view and now attach it to a different slide that I didnโt refence the info on
@Timothy_Martin I might be confused at what youโre trying to do. I was suggesting that you have two columns on your table, ReferenceColumn1 and ReferenceColumn2. Both of those columns can point to the same table.
I want to take my inline view and display it on a different page of my app. I can only get it to display on the table that I have referenced.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |