Record ID (2)

  • jchermant
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

jchermant created the topic: Record ID (2)

Hello,
on request # 234501, it is a question of modifying the ID of the form.
On the same principle, is it possible to modify the ID by adding a prefix (the current year for example)? That would give as identifier: 20190001 instead of identifier 1 etc.
This would quickly rank forms created by years.
If this is possible how to do it?
Thank you in advance.
#236579
  • Posts: 5737
  • Karma: 118
  • Thank you received: 530

MarioPuco replied the topic: Record ID (2)

Hi,

Only this comes to mind where you can UP your record number inside your DB.
This will apply on all records/Forms but you can set it to go from 20190000

This is the query you need :
ALTER TABLE #__facileforms_records AUTO_INCREMENT=20190000;

Just replace # with your DB prefix and you are good to go.

Regards;
Mario

Satisfied with our Support ?
PayPal Tip
===============================================
Need to renew Pro Support?
Buy Here!
===============================================
Satisfied?
Consider a membership!
===============================================
Like us on Facebook
===============================================
#236581
  • jchermant
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

jchermant replied the topic: Record ID (2)

Hello,
Thank you for this answer, can you tell me where I need to make this request? I guess it's using PhpAdmin ...
Is there a risk of losing data?
Thank you, Jean Claude Hermant
#236597
  • Posts: 5737
  • Karma: 118
  • Thank you received: 530

MarioPuco replied the topic: Record ID (2)

Hi,

You are correct this should be done in phpMyAdmin inside your Cpanel.
Go to SQL Tab and simply add the query I posted before and "Press GO", that's it :)

Regards,
Mario

Satisfied with our Support ?
PayPal Tip
===============================================
Need to renew Pro Support?
Buy Here!
===============================================
Satisfied?
Consider a membership!
===============================================
Like us on Facebook
===============================================
#236598
  • jchermant
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

jchermant replied the topic: Record ID (2)

I just tried but I have this message:
"MySQL returned an empty result (ie no line). (Processing in 0.0000 second (s).)"
and the IDs are not changed
#236600
  • Posts: 5737
  • Karma: 118
  • Thank you received: 530

MarioPuco replied the topic: Record ID (2)

Hi,

Just replace # with your DB prefix and you are good to go.
ALTER TABLE #__facileforms_records AUTO_INCREMENT=20190000;

Did you took care of this ?

Regards,
Mario

Satisfied with our Support ?
PayPal Tip
===============================================
Need to renew Pro Support?
Buy Here!
===============================================
Satisfied?
Consider a membership!
===============================================
Like us on Facebook
===============================================
#236601
Moderators: ForumSupporttomeperica
Time to create page: 0.044 seconds

Summer Sale!

50% discount on all of our extension subscription plans & templates!

Get Your Subscription Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99 for just 49! (Summer Sale)

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here