You have a collection of books or movies that you lend out to friends and family, but you’re tired of trying to remember who has what. You need a doc that is going to:
Have a record of every book or movie in your collection
Hello! So I’m trying to create a doc for this exercise, but I’m already stuck with a formula
I’ve created two databases (Books and Friends) and I wanted to create two buttons (One for books that are borrowed and one for books that are returned) with a dialog box, so I could select the books and the friend.
The first thing to note is that the reference to the friend in the helper table is a reference to the row, so you don’t need to do the Filter().ModifyRows, you can just do Friend.ModifyRows, which is much simpler and neater.
I have added an additional button column to your helper table called “ConfirmTest” with an updated formula.
Also note that I have used the ListCombine formula, otherwise any existing entries in the “HasBooks” column for the person would be replace, whereas you want them added to.