Selection from menu not output

Questions and Help
1

Hi {dbselect: SELECT Name FROM YarnClub ORDER BY Name ASC; space=0oHW1VyHXG2WbhwJSzZCS6; multiple=no; menu=yes; name=name}

PayPal Invoice on {time: ddd Do MMM} for {time: MMMM YY} Yarn Club

1 x Yarn Club 100gm skein @ £16.00
Postage: Royal Mail Tracked48 @ £3.55
Total: £19.55

I can select the name from the menu but it does not get output?

2

Hi @tonyd to output the name, please update the snippet to include the name in the contents, like so:

Hi {dbselect: SELECT Name FROM YarnClub ORDER BY Name ASC; space=0oHW1VyHXG2WbhwJSzZCS6; multiple=no; menu=yes; name=name}{=name["name"]}

PayPal Invoice on {time: ddd Do MMM} for {time: MMMM YY} Yarn Club

1 x Yarn Club 100gm skein @ £16.00
Postage: Royal Mail Tracked48 @ £3.55
Total: £19.55

Note the {=name["name"]} I added on the first line. Please let me know if it works for you.

You can see more in this video: https://www.youtube.com/watch?v=A4QzalgudAw

3

Thanks but that brings up [Error - "["name": "Belinda"]" is not in the list "name"]

4

Sorry I left out the "". Works now thanks

1 Like