ID not showing in database column

[marioms]

Hello guys!

I am trying to do something very simple but is not working for me.

I have a calc element that acts as an ID in a form: return "EQ-PRO-COP20-2018_{rowid}";

Once I save the entry on the form, I get this on my list: https://gyazo.com/d0add0b33db6d63346c32a043c6dc069

but the problem is that I get this on the database: https://gyazo.com/22b2a6d28a64443f37526f1e5fd3520d

And I am using that column on another form as a joint element and I get this: (there's no id number at the end of the proposal number as it doesn't show up in the DB either) https://gyazo.com/8e7f6cf77ae8fb256cd09225f8e1c998

So, is there a way to solve this? am I doing something wrong? also, if I put the two fields on the Concat option (proposal_number, id) I get a 500 Fabrik error. I also can see this error if I try to see the list: https://gyazo.com/e4f1660d61fcedd1e31e1f7ba95f0a7a

Thanks in advance!

 

[troester]

The "id" element is the primary key, an integer, autoincrement.
Use an other column for your calc element.

BTW: meanwhile Fabrik has a "sequence" element.

 

[cheesegrits]

Yup, the sequence element is definitely what to use for this.

-- hugh