Formidable Forms Community Site

The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk
Subscribe

Pre-Sales Q: Consecutive numbers possible?

Labels

This Discussion is public

Notifications

Hello, everyone šŸ™‚

This is a pre-sales question. I need to create a sign-upĀ form for a dance studio which can serve as a legal contract between the school and new customers. The client needs to include a function to create a unique ID for each submission in the format date+consecutive number (e.g.20170428-001). Is this possible with FormidableForms?

I am NOT a programmer, so my question is also about the feasibility for me as a designer.

Thanks a lot for your advice!

Regards

Nico

ps: I hope the category "Filter & Action Hooks" is correct. If not, admins please move to the right category. Thanks.

To output the first portion of that UID requirement (for example, inserted into an email) is simple:

[created-at format="Ymd"]

...gives you theĀ 20170428

 

Keeping track of a sequential number that resets per day is not a built-in feature.

However, there is a unique ID recorded for every form entry, and that is easily accessible using the [id] shortcode.

In the email(s) sent upon a form fill:

Contract ID:Ā [created-at format="Ymd"]-[id]

This will give you something like 20170428-1340

(meaning, I filled the form on April 28, 2017 and there had been 1339 previous form entries stored across all Formidable forms on the site. It will not reset per day but is guaranteed to be unique because stored form entries never share an ID)

 

So, short summary: the original scheme you described can be done by a developer, most likely requiring a custom database table to keep track of a daily ID. But if the client will bend on the contract ID format you'd have it done in 30 seconds all on your own by usingĀ [created-at format="Ymd"]-[id] in the responder

All the best,
-- Josh

Awesome Josh!

This is a very good solution I think. I will propose it to my client and hope he can accept it.

Wish you a nice weekend. Thanks & Regards

Nico

Question solved!

Discussion closed.