Hey @yashag2255 , thanks for your reply.
I have a gallery that shows all items from Table A, and when you press one item, it shows more detailed information in a form next to it. This data is stored in multiple items in table B (which are linked with the ID from table A).
Table A is full, but table B not necessarily. That means when I press on an item from A, for which are no corresponding items in B, it shows in the form 'No item to display'. My question is even though there is no item to display, how to show the form anyway but empty, instead of the message by which the form dissapears.
I want to be able to use the form to add items into table B that correspand to an item in table A, but that means I need to get access to the form. Even in Edit mode it gives the same message. Can't I just show the form without an item to fill it in?
I kind of found a solution, but it does not completely satisfy what I wanted to achieve. When an item in A gets made, it will automatically generate its empty corresponding items in table B, which then can be displayed in the form and edited. But as long certain items won't get used, I don't really see the point of already generating them beforehand, taking up unnecessary space and performance (especially in case when dealing with a largeamount of data).
@yashag2255 thanks, that's a great idea.
I don't want to get the edit or new form right away and I work with Patch(). Not all the data to store comes from the form. But basically it's the same idea. Only now I do:
If(IsEmpty(Filter(Table2, Field1 = ThisItem.Field1)),Patch(DATA))
Then it can automatically show in a view form as well, showing as an unedited item instead of no item. And then it only gets created when it needs to.
Thank you very much
Continue your learning in our online communities.
Let's thank our top community contributors
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Features releasing from April 2019 through September 2019!