Forums

Further form development

Mizpah 10 Apr, 2008
Hi all,

well I am back after aq long abscense, so to start with I have posted a mini write up of my forms, and how its all been put together. It can be found here:

http://www.chronoengine.com/index.php?option=com_fireboard&Itemid=37&func=view&id=7355&catid=7

I would welcome any feedback and advice as to what I have done so far!

Now moving on, I aim to the do the following:

[list]
  • Add form validation to all fields, with customised messages indicating whats wrong

  • Split the form into 'pages' for easier viewing (is this possible? I would want people to be able to navigate forwards and back pre-submission without losing info)

  • Add submission status to the database (a field with a value of 'submitted' for every form

  • create (and populate)a field for 'number of submissions' (i.e. based on char name or email let us know how many times previously someone has filled a form in)

  • Create a simple screen where the extra information can be viewed and the status field adjusted by guild officers

  • Automatically send an pre-configured email to the original user when the status field changes, differing templates based on the value of the field (Greyhead, I know this is not in chronoforms, but I am hoping I can call the existing process's in chrono to do this?)

  • Allow an end user to view the status of the application via a query to the database

  • And a biggie for me - find a way to output the entire form, in a formatted way to a phpBB3 forum on initial submission
  • [/list]

    So, as you can see, there is a lot done, but still a lot to do. Would anyone care to share thier experiences of doing the same or suggest any code snippets etc ?

    All feedback greatfully recieved,

    Mizpah
    Max_admin 11 Apr, 2008
    Hi Mizpah,

    Sure, let me comment on all your points :

    #1- use the built in validation and edit the validation.js file to edit the warning messages!
    #2- possible but each page will not submit, you will divide form code into divs and switch show/hide every div!😉
    #3- this is not needed, once form is submitted its saved, why include this field ?
    #4- this will need writing a php query to be executed before saving data to count the previous number of submissions from database and add them to a database field!
    #5- cant understand this one!
    #6- you can do this by calling the joomla mail function after counting the number of submissions!
    #7- this also will need some PHP code written!
    #8- You will need to analyze the phpbb3 database tables structure then write the appropriate insert SQL statement and then use PHP to execute it!

    Not much code is provided but this is a good start point, you can post your problems with individual points!

    Best regards,

    Max
    Max, ChronoForms developer
    ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
    ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
    Mizpah 11 Apr, 2008
    Thanks Max!

    3 and 5 are linked,

    In short I want to create a default field of 'submitted' as the standard 'status of an application. I then want to create a seperate page (password controlled - or even doable via the joomla/chrono backend ? hmm...) where guild officers can change that status to 'pending', 'accepted', 'denied' etc, and people who have applied can check the status of thier application.

    This is a first step in being able to manage applications better!

    However, the biggest priority for me as of now, is the submission to phpBB3, has anyone here done anything similar with phpBB3 ?
    Max_admin 12 Apr, 2008
    Hi Mizpah,

    Ok, add a hidden field with value submitted, later create a new form to update the first one data, you will need to write the update statement!

    I never seen any phpbb3 code integration here!!

    Sincerely,

    Max
    Max, ChronoForms developer
    ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
    ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
    This topic is locked and no more replies can be posted.