I'm really really grateful i've found your RUclips Page. This works a charm. Im in the process of creating an app for doctors in my clinic & this perfectly shows the relational data with the patients registered & patient seen by the doctors. THANKS A LOT!
Thx for your helps,i have created 2 tables according to your video,Controls and Spare parts, I need to save quantity of spare parts that are used in the control.
Very well made video with explanation. I have been working with appsheet for some hundreds of hours and I still do not get the logic behind it. I basically copied this app to learn something. I am actually trying to create something similar but with a quantity option. For example the "community" is actually a quantity. I understand its kind of similar (needs many to many relationship) but when i try to tweak it a little and do something different it never works and it gets me super confused. This is so annoying and disturbing.
Hi Kr. Everything in AppSheet starts with the data and builds from the structure that you establish. So if you want to capture quantity you have to decide are you using a number value to capture an input from the user, or do you want to calculate a count the number of values. The former requires a column in your table to capture the value and the latter requires a "virtual column" that will calculate the quantity automatically.
This is great! But I've noticed that if a row in one table is deleted, the reference to that record in the other table is duplicated rather than removed. Anyone know how to fix?
You can use "execute an action on a set of rows" action type. Target the table you want to delete from as the referenced table and the use list([key]) to target the respective records in the target table. Then choose the delete action to use. [Key] is whatever column is your ID field in the target table.
@@appify i think, the first commmentor ask about update in both side.... i have trouble too to execute operation like this.. maybe you can teach more detail?? thankyou
Thank you so much. This video has helped me a lot. However, I am facing a peculiar problem. in my case, "[_thisrow_before].[Users]-[Users]" and the flip one (columns for added and subtracted records) are occasionally working. I tried improvising with "[_thisrow_before].[Users]-[_thisrow].[Users]" but still sometime they work, sometime they don't. The behaviour is similar to enum list issue if the suggested value is not set. Can you help me solve this issue please?
There is some wonkyness in that sometimes enumlist columns are not parsed correctly as a list. Try using "split([Users])" and see if that helps. This will ensure that column is parsed as a list.
The problem with my case is: When i use EnumList as type and REF as base the name is showing with multiple select but is seem the table not connected (No related column generated). But When i use REF as first choice table is conedted but the EnumList automaticly convert to Enum (Can only Select One). How to resolve that? Note : I create database direcly from Appsheet not from Google Sheet.
Is there any work around use REF as first choice but EnumList not turning into Enum? so i can keep the related table generated by Appsheet. Becouse when i use EnumList as type and REF as base the Option is appeared and i can select multiple option but relation seem broke so i had to add virtual column to manualy connect.
You can select all of the communities at once through the forms enum list, rather than including each person individually. This didn’t seem like a big thing to me - and probably not you either - but explaining to to end-users is hard. They didn’t understand why they had to keep individually adding the people.
@@appify edit: from my understanding what you are referring to are commands in a relational database (those inner, out joins etc) what im asking is an implementation where there is a 3rd table holding the relationship between the two main tables (with 2 columns for the ids of both main tables), instead of the extra column (a list of the relationship) in this demo.
I'm really really grateful i've found your RUclips Page. This works a charm. Im in the process of creating an app for doctors in my clinic & this perfectly shows the relational data with the patients registered & patient seen by the doctors. THANKS A LOT!
Gold!! You said complex but I think my setup is so complex it’s unnecessary and in turn slowed my app.
Thank you for this!!
Thanks very clear video. Never found anything that good about many to many in appsheet.
Glad it was helpful!
Best tutorial i could find, thanks!
Thanks for the concept. this was very useful to resolve my issue.
Great to hear!
Excellent! thanks!!
Thank you very much brother
This was extremely helpful, thank you.
Glad to hear it!
hey, looks like the template app have an error
Thx for your helps,i have created 2 tables according to your video,Controls and Spare parts,
I need to save quantity of spare parts that are used in the control.
Very well made video with explanation. I have been working with appsheet for some hundreds of hours and I still do not get the logic behind it. I basically copied this app to learn something. I am actually trying to create something similar but with a quantity option. For example the "community" is actually a quantity. I understand its kind of similar (needs many to many relationship) but when i try to tweak it a little and do something different it never works and it gets me super confused. This is so annoying and disturbing.
Hi Kr. Everything in AppSheet starts with the data and builds from the structure that you establish. So if you want to capture quantity you have to decide are you using a number value to capture an input from the user, or do you want to calculate a count the number of values. The former requires a column in your table to capture the value and the latter requires a "virtual column" that will calculate the quantity automatically.
This is great! But I've noticed that if a row in one table is deleted, the reference to that record in the other table is duplicated rather than removed. Anyone know how to fix?
Agree, extremely helpful. Thanks a lot! When deleting a community or user, how can I make it update on both sides?
You can use "execute an action on a set of rows" action type. Target the table you want to delete from as the referenced table and the use list([key]) to target the respective records in the target table. Then choose the delete action to use.
[Key] is whatever column is your ID field in the target table.
@@appify i think, the first commmentor ask about update in both side.... i have trouble too to execute operation like this.. maybe you can teach more detail?? thankyou
Help, it's not working for me now. T.T
Thank you so much. This video has helped me a lot. However, I am facing a peculiar problem. in my case, "[_thisrow_before].[Users]-[Users]" and the flip one (columns for added and subtracted records) are occasionally working. I tried improvising with "[_thisrow_before].[Users]-[_thisrow].[Users]" but still sometime they work, sometime they don't. The behaviour is similar to enum list issue if the suggested value is not set. Can you help me solve this issue please?
There is some wonkyness in that sometimes enumlist columns are not parsed correctly as a list. Try using "split([Users])" and see if that helps. This will ensure that column is parsed as a list.
The problem with my case is:
When i use EnumList as type and REF as base the name is showing with multiple select but is seem the table not connected (No related column generated).
But When i use REF as first choice table is conedted but the EnumList automaticly convert to Enum (Can only Select One).
How to resolve that?
Note : I create database direcly from Appsheet not from Google Sheet.
Go to 6:38 in the video. I show how to use suggested values to get the drop down list to populate.
Is there any work around use REF as first choice but EnumList not turning into Enum? so i can keep the related table generated by Appsheet. Becouse when i use EnumList as type and REF as base the Option is appeared and i can select multiple option but relation seem broke so i had to add virtual column to manualy connect.
What's the benefit of doing this instead of creating a separate table to represent the association?
You can select all of the communities at once through the forms enum list, rather than including each person individually. This didn’t seem like a big thing to me - and probably not you either - but explaining to to end-users is hard. They didn’t understand why they had to keep individually adding the people.
Thanks for the response! That makes total sense considering it's a no-code platform
wish there was a guide for when joint table was used.
When you say joint table do you mean left, right, cross, inner or full?
@@appify
edit: from my understanding what you are referring to are commands in a relational database (those inner, out joins etc)
what im asking is an implementation where there is a 3rd table holding the relationship between the two main tables (with 2 columns for the ids of both main tables), instead of the extra column (a list of the relationship) in this demo.
Tried recentrly, id didnt work
Nice concept. How can I contact you?