Limit number of submissions - Post ID...

User 464893 Photo


Ambassador
1,611 posts

Sorry about that Marilyn but try terryprism at gmail.com. Not at home to others unless there are lots of pretty pleases. I will dig out some code in anticipation Marilyn.

Yes Eric php has reserved functions for things like count etc and a deletion of a page is rough but would be one option. Never "Killed" a file yet but why not. I think I pointed you at that flat file system Eric. A database system can be uploaded running without the necessity to open a MySQL database. The conditions can be hard coded for interaction. Could handle most requirements not Google's.

Basically the script will count the records and when it reaches the magic number either deletes the record and redirects to a sorry page or pulls the plug on the form. There are probably more elegant solutions. We will see when we go out to play.

I am hell bent on this A La Carte responsive program but I can see a back end for forms is a possibility to get my hands dirty on.


The Guy from OZ


User 2199435 Photo


Registered User
20 posts

Hi,
A backend would be great...I can easily bring down the data in Excel or Access, etc. but what about the other people using the forms that don't have programs like that and are not database savvy?

User 187934 Photo


Senior Advisor
20,271 posts

The backend would still be a online php script displaying the values in the csv.:)
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2199435 Photo


Registered User
20 posts

I meant a general backend.....when I think of backend I think more of being able to see the input data and manipulate it in a user friendly way. Like an admin area.
User 187934 Photo


Senior Advisor
20,271 posts

How do you want to manipulate it? Delete or alter entry's?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2199435 Photo


Registered User
20 posts

Kinda like what they have in another survey program (I wont mention here). It shows you the sql database entries and allows you to filter/change/add etc, entries...then you can download or print the info to use for things like the examples below.

For example lets say:
I want to send an email to everyone who filled out my form that lives in a certain state.
Or I want to contact everyone that is a certain age

Maybe make one and sell it as an add-on to FB?

I like the ease of use and the templates you have on FB much better than the other program which takes some time with the learning curve.

User 2147626 Photo


Ambassador
2,958 posts

If you save to an SQL file, you can always use SQL Manager Lite (it's freeware). Just google for it. It will display, let you edit, and a few other things. Just an option. :cool:
Graphics for the web, email, blogs and more!
-------------------------------------
https://sadduck.com
User 464893 Photo


Ambassador
1,611 posts

While I am working on Marilyns script for her I thought I might start on creating a back end producer. So if anybody could specify the different requirements that may be required from data sent to a csv file. I shall use a very capable flat file system that can be easily uploaded to someones host to hit the ground running.
I can be contacted at the address in a post above. Presently if I have had the need I have scripted just for the task at hand but never thought of a do all system. I like working on a couple of projects at once cause when I get bogged down on one I change then find I can go back fresh.
Anyone who contributes gets a final copy win win.
The Guy from OZ


User 187934 Photo


Senior Advisor
20,271 posts

That's going to be lot of variability as each user could have several different request as far as data manipulation. I think most would want calculations at this point because that's lacking from the form builder now. I already have a form that I'm doing calculations on using JQuery but you have to alter the form files to get it done. Next would be filtering,sorting,altering and finally deleting.:)
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 464893 Photo


Ambassador
1,611 posts

Yes I realize that. I am thinking I can transfer inputs into known variables ie. $001 to the number of items.
Then it depends on the requirements. There would be a number of variations but a user could specify the items and what should be done with them. I would write a script via the program to follow constraints entered.

How complex time will tell. things like addition, subtraction and other straight forward maths no problem. Display OK as well. Some scripts may require manual additions to them. Sorting will be done by functions available. So far I have only got the transfer into the number of variables matching the entries. I have never created an online GUI so my form will be a html page, I always bite off something that takes a lot of chewing. I am leaning towards a stay on top client program for entry with a server side display of the variables, but early days.
I will ask for input and critique if I may Eric. One thing if the items are extracted then that is the first step in doing something with them.

I was hoping to get some enquirers on what would be a good addition but nothing yet. Don't matter, I like to talk to myself, I am a good listener. ;)
The Guy from OZ



Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.