By the way ever since i have watched the SELECT function video of yours....i m using that one all the time.... Thanks for that video as well that was so useful❤️
hello! thanks for the video. I have an original table that i need to draw from, and i just need to add one further column in another table. so it's a 1:1 relationship between tables. In order to add new instances to the 2nd table, would ref-rows be a good candidate for this?
Check out the video Parent child relationships ua-cam.com/video/18N4TpxiwK4/v-deo.html. This will show you how to create the relationship between two tables and AppSheet automatically generates a REF_ROWS () virtual column for you! You will then be able to add new records to the new table through the inline view.
New subscriber! I have a question I have an table labeled students where each row represents a student, and each column represents variables for each student (Name, email, address etc...) I also have a table called associates that refs to to the rows in the students table. The associates table allows me to select a row from the student table and link it to another row within the student row but keep the notes on the associates table. Problem is, when I create an associate entry for one student, I have to do the same for the other student. Is there a way to have student rows automatically know that they are referring to each other as associates?
What fields are in the associates table? Are associates and students the same type of entity? Does it make sense for the associates and student table to be a single table? In general you can create an automation that with do what you are asking...
@@appify The associates Table will allow me to make notes of each association dynamically. Each note worthy interaction between the two individuals can be timestamped and paired with notes unique notes. As of now, I can make the association of one individual to another, but I pretty much have two enter the info twice, once for both individuals. I'm just looking to make it so that association entried are reflected on both individuals
@@bellacintron4963 In the associates table you will need two separate fields, one for each student. ie. "Student A", "Student B". I couldn't tell if you already have this or not. if so, great! Now we can add the part where these associations automatically show up for each student. Follow these steps: 1. In the student table you are going to add a new virtual column called Associates with the following formula. This formula creates a list of IDs from the associates table where that student is in either Student A or Student B field. We are adding these two lists together, hence the two select() functions. select(Associates[Student A], [Student A]=[_thisrow].[Student ID])+select(Associates[Student B], [Student B]=[_thisrow].[Student ID]) 2. Save the app and view the student detail record. You should see a new inline view with the same name as the virtual column you just created. Which should contain the appropriate associate records for that student. If you do not see the new inline view make sure that the new Associates column is added to the detail view if you have customized the column order in the detail view. Let me know if that works. There are some other ways to accomplish this as well but this is probably the most straight forwards for your scenario.
@@appify Ok. So I followed the instructions. And the associates inline view is visible. Problem is. Student A is displaying student A in the box where student B should appear. It's just mirroring itself in the associates section
By the way ever since i have watched the SELECT function video of yours....i m using that one all the time....
Thanks for that video as well that was so useful❤️
Glad to hear that!
hello! thanks for the video. I have an original table that i need to draw from, and i just need to add one further column in another table. so it's a 1:1 relationship between tables. In order to add new instances to the 2nd table, would ref-rows be a good candidate for this?
Check out the video Parent child relationships ua-cam.com/video/18N4TpxiwK4/v-deo.html. This will show you how to create the relationship between two tables and AppSheet automatically generates a REF_ROWS () virtual column for you! You will then be able to add new records to the new table through the inline view.
Thank you!
New subscriber! I have a question
I have an table labeled students where each row represents a student, and each column represents variables for each student (Name, email, address etc...)
I also have a table called associates that refs to to the rows in the students table.
The associates table allows me to select a row from the student table and link it to another row within the student row but keep the notes on the associates table.
Problem is, when I create an associate entry for one student, I have to do the same for the other student.
Is there a way to have student rows automatically know that they are referring to each other as associates?
What fields are in the associates table? Are associates and students the same type of entity? Does it make sense for the associates and student table to be a single table? In general you can create an automation that with do what you are asking...
@@appify The associates Table will allow me to make notes of each association dynamically. Each note worthy interaction between the two individuals can be timestamped and paired with notes unique notes.
As of now, I can make the association of one individual to another, but I pretty much have two enter the info twice, once for both individuals. I'm just looking to make it so that association entried are reflected on both individuals
The fields right now are a ref to the Unique ID + Name of individual, friendship type as a enum, timestamp, and notes as long text
@@bellacintron4963 In the associates table you will need two separate fields, one for each student. ie. "Student A", "Student B". I couldn't tell if you already have this or not. if so, great!
Now we can add the part where these associations automatically show up for each student. Follow these steps:
1. In the student table you are going to add a new virtual column called Associates with the following formula. This formula creates a list of IDs from the associates table where that student is in either Student A or Student B field. We are adding these two lists together, hence the two select() functions.
select(Associates[Student A], [Student A]=[_thisrow].[Student ID])+select(Associates[Student B], [Student B]=[_thisrow].[Student ID])
2. Save the app and view the student detail record. You should see a new inline view with the same name as the virtual column you just created. Which should contain the appropriate associate records for that student. If you do not see the new inline view make sure that the new Associates column is added to the detail view if you have customized the column order in the detail view.
Let me know if that works. There are some other ways to accomplish this as well but this is probably the most straight forwards for your scenario.
@@appify Ok. So I followed the instructions. And the associates inline view is visible. Problem is. Student A is displaying student A in the box where student B should appear. It's just mirroring itself in the associates section
so if I use a slice ... when I creat a new line on the parent table.. Appsheet will allow me to addd a line to the child table?
This is not related to the slice. To do this, you will need to enable "is a part of" in the REF column settings.
Thanks sir❤️