Forums

Hi, could you please help me, how to read table in database and go to end of record and email it ?
​
Regards.

Well it depends - how are they stored? Is there a created field? Or a sequential automatic id field? Because you could sort by that field in ascending order and return first matching.

They stored from registration form. I want to put increment number as invoice number to my customer.

OK so if I were you I would very much NOT simply read whatever the last record is and email it to the customer because inevitably you'll end up sending someone else's data.
​
What you want to do is use a save data action to save your record, and then use {var:save_data_name.model.id} which will give you the automatically generated ID of the record you just saved.

and how to put it to my email body?

Exactly how I said to

Hi,
I've tried writing this in body email, but cf_id is not there.
​
<li>No. Invoice: {var:save_data8.Data8.cf_id}</li>
​
do you have solution ?

Is CF Id what your ilID field is actually called? Is it set to primary key Auto increment? Add a debug action and check there