what would be the "formspider way" to do this in best way( not much programming, as possible only defining some selects for validation ) :

Table with some data( gaugeclass, gauge_from, gauge_to, valid_from, valid_to, deviation ). Primary Key is gaugeclass and valid_from, gauge_from and gauge_to may not overlap/coincide.

The Value to set is the deviation.

History is needed, means no real delete, delete will set/update valid_to on actual date, actual record are these, where valid_to is null.

Situation 1 = update of deviation :

The new record shall get the same gaugeclass, gauge_from and gauge_to, a new Valid_from( actualdate) and the new deviation. The valid_to of the old record must be set onto the actual( or given ) date minus one day.

Situation 2 = ( new respectively ) splitting a gauge class :

If a gaugeclass shall be splitted into i.e. 2 classes, the program has to check against overlapping inside the new classes and against the existing gaugeclasses. So this action consists of 1 update of the old record, several check actions( selects ) and 1..n inserts if checks are ok.

At the moment its unclear for me whats the best "Formspider-way" to work with the tool :

  • how to control/limit user behaviour
  • where/how to get the data for building the checkselects
  • where to place the checkselects and how to get the results back
  • where and how to define the update/insert statements

Thanks a lot and best regards


asked 24 Aug '15, 10:44

A112's gravatar image

accept rate: 0%

edited 24 Aug '15, 10:50

Hi Dirk,

Excellent questions. I'll try to answer them soon. We are putting the final touches to the new Formspider version. So it might be a few days before I get to your questions. In the meantime though, I recommend that you install our reference application or go over the tutorials in the learning center. A while ago I put together a resource list and wrote a blog post named "How to start learning Formspider?". I believe it can also be useful. You can read it at this link: http://theformspider.com/blog/2013/04/29/how-to-start-learning-formspider/

Kind Regards,

(25 Aug '15, 08:31) Yalim Gerger ♦♦

Hi Dirk,

I built a small sample application and sent it to the email address you used when you registered after downloading Formspider. I think it is your company email address.

Please let me know if you do not receive my email and I can send it to an alternative email address.

Kind Regards,


answered 01 Sep '15, 03:06

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 24 Aug '15, 10:44

Seen: 1,512 times

Last updated: 01 Sep '15, 03:06

© Copyright Gerger 2017