I'm building an app for matching donations with receivers. I have 2 database tables. When looking at donor details (Table 1), I show potential matches from receivers (Table 2) for whom the donation would be suitable, based on some filters. The user can click on one of the potential matches and see details about the potential receiver.
If the user thinks that it is a suitable match, we'd then send an email to the possible receiver informing that we've found a match. For this I've created an email action in Table 2. However, I'd like to include some details about the donation from Table 1 (such as the Unique ID and product dimension). I'm unable to do that because the Email action in Table 2 doesn't know which donor from Table 1 we are referring to.
Is there some way for the Table 2 detail view to know which record from Table 1 it was opened from, and then refer to the Unique ID column for that record in Table 1, so that it could be included in the email? I'd also want to be able to update other columns in Table 1 (eg. to reserve the donation for the receiver to whom we've sent the email)
All help appreciated, as I'm quite new to using AppSheet. Thanks.
โ
User | Count |
---|---|
18 | |
12 | |
8 | |
4 | |
3 |