Create an auto increment numeric field

[madpato]

Hello

I need to create something pretty much like an id with auto-increment but then i encounter small issues like if i have a repeat. group if i create a new entry it shows me the next number despite its another record (since its using the ID field, i was expecting something like this).

So if i noticed this is not a viable option, how can i do this? See this link for details: http://desarrollo.tilatam.com/tns4/index.php/reuniones

Thanks

 

[cheesegrits]

How are you currently creating it? What is the element name/id? I don't see anything which looks like what you are describing in the element list on the backend.

Are you trying to do this on the main table, or one of the joined / repeated tables?

-- hugh

 

[madpato]

The name of the field is: tns_reuniones_capac___id this is for the repeated tables. ID of the item 344 Thanks.

 

[cheesegrits]

OK, I really don't understand what you are trying to do.

Can you give a fuller explanation of what you are trying to achieve?

-- hugh

 

[madpato]

Ok this is rather simple, all i need is a field (any type) with a number that autoincrements whenever i create a new entry in the rep. group, this has to be in order starting always from number 1 and so on whenever i press the "+" to add a new entry on the group. Is just that i dont see how simpler can i put it. Guess i have to contact you on Chat so i can answer bettter your questions. Regards.

 

[cheesegrits]

OK ... which is exactly what the 'id' we automatically create on repeated groups is. An auto-incremented integer value.

However, that 'id' is only available AFTER the rows are saved, on form submission, as it's generated my MySQL during the row insert.

Which is why I need to know more about what you want to use it for. If you need it displayed when you press the "+" button, then it's a lot more complicated than you might think. For instance, do you have more than one person using this form?

If so, consider the issue of two people, both with the form loaded, both pressing the + buttons in their form. Your number needs to be unique, but if it is being calculated in JavaScript in the browser when the + button is pressed, how can it take account of someone else doing the same thing?

The only way to achieve this with any hope of having a unique number is to maintain a separate table, like "my_repeat_ids" (with one row per table you want to do this for, which stores the list ID and the last number used), and have a user_ajax.php method which gets called via AJAX when the + button is pressed, runs PHP on the server to look up the next number to use in that table, updates that table to increment that numberm and return the value to your custom JS, which inserts that value in to the field on the form.

Of course, this means you'll have gaps in the number sequence, for instance if someone doesn't submit the form after adding new repeat groups.

So ... as I said, give me more info about exactly what you are trying to achieve, so we can nail down just how far we need to go to achieve it.

-- hugh

 

[cheesegrits]

OK, as per our live chat conversation, I now understand what you need, which is an incrementing serial number starting at 1 within each repeat group, rather than for the entire table.

So ... first thing, don't touch that 'tns_reuniones_capac___id' element, if it's the one that got created by Fabrik when you created the repeat group. That's "for internal use only", and you repeat group won't work if you mess with it.

Create a new field element, called something like 'serial_num'.

Add a form PHP plugin, running onBeforeProcess, which does this:

foreach ($formModel->formData['tns_reuniones_capac___serial_num'] as $key => $serial_num) {
  $formModel->formData['tns_reuniones_capac___serial_num'][$key] = $key + 1;
  $formModel->formData['tns_reuniones_capac___serial_num_raw'][$key] = $key + 1;
}

-- hugh

 

[madpato]

This worked like a charm except for one small detail, what if i need to apply the same thing but for another element on the same form? how do i add another element?

Thanks!!

 

[madpato]

friendly bump

 

[cheesegrits]

You should just be able to copy that code and replace the element name.

-- hugh

 

[madpato]

I tried copy the code on another php form plugin but it just return zeros it just works once: http://desarrollo.tilatam.com/tns4/index.php/reuniones/form/22/6

Can you please check? thank you.