Email a list

Ask for Help
1

In my app, Users create a favorite list of restaurants and I want each user to be able to send their favorites to different emails. The restaurants are separate row items.
I created an action to compose email which works but it is bringing back the first row of my data rather than those row items identified as a favorite.

What am I missing?

2

Do you store the “favorite” data in user-specific columns?

If not, there can be a way to do it, but it also depends on what you expect when you do the “sharing” part. Is it a public page that anyone can see, or the shared user must login to see the shared restaurants?

3

Be sure to target the user profile section for selecting your columns. Super easy to just select from the user table (which defaults to the first row) but you need to select the USER PROFILE selections.

4

i store the column of favorites in my table of restaurants and use an “if then” to bring over the unique user ID. I want the favorites to be visible only to the individual user and for that user to email the list of restaurants.

5

When you say “the column of favorites”, I assume it’s a user-specific column?

It might not be a huge issue if you configure downstream stuff correctly, but I assume it would have to be like this:

  • User-specific column that stores whether a user has favorited an entry.
  • A query in the users table to find entries where the user has favorited.
  • I assume the email would contain the restaurant info as well, opposed to giving them a link and open an app to view, that would be much harder, then you can design some HTML on each row and use a joined list column to get all favorited HTMLs back.
  • Design an email body and integrated the joined list above in.
6

The column in the restaurant table stores the user ID for that restaurant. If I toggle among users, I can see what each user selects as a favorite. I’m now wondering if it would have been better to store the favorites in the user table and bring over the unique restaurant ID for each?
As it is now, I have a column in the restaurant table that stores each user ID when they have favorited a restaurant.
I would like the email to be a list of restaurants with phone number and address.