Many to Many References With SELECT() in AppSheet || The Brute Force Method

Поделиться
HTML-код
  • Опубликовано: 13 сен 2024

Комментарии • 7

  • @tom-greg
    @tom-greg Год назад

    Great video as allways! I would love to see a video on how to generate a custom/filtered CSV-file. Lets say you have Customers -> Locations -> Inventory. I would like a button in the customers list that generates a CSV with the Inventory of that customer, sorted/grouped by locations.

  • @tanjidahmedjony4667
    @tanjidahmedjony4667 2 года назад

    Love 😍 You Big Brother 🥳🌻

  • @gnorpflorbsen8665
    @gnorpflorbsen8665 Год назад

    Why this over dynamic slices of a lookup table associating primary keys? Would that not be cached on the device?

    • @MultitechVisions
      @MultitechVisions  Год назад

      A lookup table is actually how I prefer to do it; it future proofs everything. Just offering an option. ;)

  • @bellacintron4963
    @bellacintron4963 Год назад

    I'm trying to follow but I can't figure it out.
    I'm trying to connect persons in a STUDENTS TABLE with a FRIENDS TABLE.
    The student table has all the people in the class, and the friends table is used to connect who's friends in the class. The friends table uses the student table as a reference for names.
    How can I make it so that when I make student 1 a friend of student 2... student 2 reflects that it is a friend of student 1?
    Currently I have to enter the friendship connection on both student 1 and then student 2 to show that they are friends.
    Is that even possible? Thank you in advance.

    • @MultitechVisions
      @MultitechVisions  Год назад

      Many-to-Many is difficult to get your mind around; but once you finally figure it out and things click, it get's easier to implement.
      The hard part is making sure you get all the appropriate update actions in place, in the right order; check out the sample app linked in the description.

  • @richinman9721
    @richinman9721 Год назад

    So helpful! I really like the client side solution.
    Looked under the hood at your app and it looks like `[_THISROW_BEFORE]` does work. 👍