Help Needed - Merging 2 tables values together

Need help
1

Hi,
I need help here.
I have this table that collect users input on the services that they’ve selected. After they have selected them, I want to send out a summary email.
I want the format of the product code to be display like

image
BW13 Duda Start Package, OT01 Domain Registration

at the moment i am only able to do it in this manner.
BW13 OT01, Duda Start Package Domain Registration

Is there a way to achieve this?
Thanks.
Alvin.

1 Like
3

Yes so I would approach as follows:

  1. Change your email body to have the following dynamic expressions
  2. For the first record: In the “Body” field of the email action, you can refer to the first record by doing a search:

  • Use the expression: Search for Products: first item's Field Name

  • Replace Field Name with the actual field you want to display (e.g., Product Name, Price, etc.).

  1. Steps to Display the Second Record
  2. Retrieve the Second Record:

  • In the same “Body” field of the email action, after the first record’s information, add the expression:

  • Use the expression: Search for Products: items until #2:last item's Field Name

  • Replace Field Name with the specific field you want to display.

If you have more than 2 products - then repeat step 4 (then just conditional statements on them all to say ‘If this exists then show if it doesn’t don’t show’. By the way, we have an online community where there are tons of people building awesome Bubble and AI products - it’s free to join here -Lightning Accelerator

4

This topic was automatically closed after 70 days. New replies are no longer allowed.