A new person accepting an invite and signing up should generate a log entry for the Owner.

[Christopher Adams]

This should be generated by the first time a new People signs up.

[Brad Phillips (brad-bradphillips)]

I've been working to make this happen, but I believe an aiki form bug is stopping me from getting all of the ppl_logs fields properly filled, when an invitation is accepted.

For the owner_id & message fields, I need to use some sql to grab data from the aiki_users table & insert it into the ppl_logs table. I'm using a similar method that's working in the ppl_invites table (placing the userid in the url & using that as the basis of the comparison for the select statement), but the form errors out when placed in an autofield that is sending data to another table:

This works:
sender_email|SystemGOD:sender email:value:(sql((select email from aiki_users where userid = (!(3)!)||[-[email]-]))sql)

This fails:
owner_id->ppl_logs|SystemGOD:owner id:value:(sql((select * from aiki_users where userid = (!(3)!)||[-[owner_id]-]))sql)

I've filed the issue on aikiframework's launchpad. Bassel, what do you think on this? Can you confirm that sql statements don't properly execute in the context of an aiki form field that's sending data to a 2nd table?