Looping through a local DB

Questions about Thunkable
1

I’m trying to loop through a local DB, I want to get property objects for object j. I tried doing this:

Edit:
Sorry wrong screenshot
image

But the data returns nothing, any advice?

Local DB Image:

image

1 Like
2

Can you share an screenshot of your DB? As far as I can see, you’ve done it wrong. Firstly, you’re looping through the Profile Pictures of the homework helpers. Change that to ID.

1 Like
3

There’s more wrong too, but I can only explain that after you’ve shared a screenshot of your DB.

4

thanks! The pictures in the post.

1 Like
5

Instead of
image

Use
image
Of course, my table names are wrong- replace them with your table names and column names.

1 Like
6

Something like this? And thank you for the help!

image

1 Like
7

Also, do the same with
image

1 Like
8

Yep, that’s right. Can you test it an tell me?

1 Like
9

It works!

image
image1026×93 15.3 KB

I was using the Gmail API to send an email within the app (Tutorial from cttricks: Sending Emails From Thunkable App | Gmail App)

It works fine now! Thanks for the help!

1 Like
10

Great work! I’d love to try this out myself!

1 Like
11

Sure! I’ll send a link!

1 Like
12

Thanks!

1 Like
13

Alright, my computer was being slow, but here’s a mock up version!: Thunkable

1 Like
14

Oh yeah I forgot to mention: It’s being sent from my teams email if you want it to be sent from an email of your choice head over to the tutorial!

15

Wow! This is amazing! I just tested it out, and it worked great. Will check out the tutorial. Sorry, I tested it and got an email from your team’s email.

1 Like
16

Glad to hear it worked and that you liked it!!

And thanks to @cttricks for the awesome tutorial :slight_smile:

2 Likes
17

Could you share the APPSCRIPT code if you don’t mind? The link to @cttricks’s code isn’t working.

1 Like
18

sure, pretty sure this was it …

function doPost(e) {

  var recipient = e.parameters.recipient;
    recipient = decodeURI(recipient);
  var subject = e.parameters.subject;
    subject = decodeURI(subject);
  var body = e.parameters.body;
    body = decodeURI(body);

  MailApp.sendEmail(recipient, subject, body);
}
1 Like
19

Thank you so much! Am trying this myself right now.

1 Like
20

awesome! Let me know if I could help with anything else

1 Like