Hello,
I've got a problem regarding the usage of Photoshop. I am using Chronoforms for a very long time with very much pleasure. But I am stuck with a new kind of form I need to create, and I don't know if it's possible. That's why im asking it here.
I have a form with fields that needs to be filled in by the admin of the website. As soon as he is done, he wants to send this form (half filled in) to a client which fills in the remaining part of the form. Now when he presses enter, the form needs to be saved in it's entierity to the database.
Now the part that I am stuck at is the handing over the form between the client and the admin. Is this possible? And how?
I've got a problem regarding the usage of Photoshop. I am using Chronoforms for a very long time with very much pleasure. But I am stuck with a new kind of form I need to create, and I don't know if it's possible. That's why im asking it here.
I have a form with fields that needs to be filled in by the admin of the website. As soon as he is done, he wants to send this form (half filled in) to a client which fills in the remaining part of the form. Now when he presses enter, the form needs to be saved in it's entierity to the database.
Now the part that I am stuck at is the handing over the form between the client and the admin. Is this possible? And how?
Hi Huubs,
I would assign the form a unique ID* save it after the admin enters data and then send the user an email with a link including the id. When he clicks the link have that go to a form event that will check if the id is valid and, if it is load the saved data and display the form with the additional fields. When he submits update the previous record in the database table with the new/changed data.
Bob
* I have a Unique ID [GH] action that generates a short unique random string - PM me if you'd like a copy.
I would assign the form a unique ID* save it after the admin enters data and then send the user an email with a link including the id. When he clicks the link have that go to a form event that will check if the id is valid and, if it is load the saved data and display the form with the additional fields. When he submits update the previous record in the database table with the new/changed data.
Bob
* I have a Unique ID [GH] action that generates a short unique random string - PM me if you'd like a copy.
Thanks for the plugin and the explanation. Although I'm unsure what to do. What do you advice me?
The most beatiful solution would be to use a multi page form? Or do I have to use different forms but using the same table?
The most beatiful solution would be to use a multi page form? Or do I have to use different forms but using the same table?
Hi Huubs,
You could use one form with two pages, but it might be simpler to understand if you use two forms.
First create a database table that contains all the columns that you need. including the Unique id.
Create an admin form with the elements that the admin needs to complete; in the On Load event add an Authenticator action to limit access to admins only.
In the On Submit event add the Unique ID to generate the ID and then a DB Save to save the new record. After that have an Email action with the link that goes to a second form with the remaining inputs (you can show the existing entries in a Custom Code element, or using elements that are read-only). In the On Load event use an Event Switcher to check that the ID is valid (you may also want to check that it hasn't already been completed). Load the saved data, show the form and when it submits save the new data using the ID to identify the record.
Bob
You could use one form with two pages, but it might be simpler to understand if you use two forms.
First create a database table that contains all the columns that you need. including the Unique id.
Create an admin form with the elements that the admin needs to complete; in the On Load event add an Authenticator action to limit access to admins only.
In the On Submit event add the Unique ID to generate the ID and then a DB Save to save the new record. After that have an Email action with the link that goes to a second form with the remaining inputs (you can show the existing entries in a Custom Code element, or using elements that are read-only). In the On Load event use an Event Switcher to check that the ID is valid (you may also want to check that it hasn't already been completed). Load the saved data, show the form and when it submits save the new data using the ID to identify the record.
Bob
Ok, I'm almost done, but I am stuck at the second part. I have a link to the form with a parameter ?checker=99AA99, where the checker is the unique ID. I have a DB read in the onload event but I'm not really sure how to use the DB read action. Do I need to check in the condition field if the Unique ID and the checker parameter is the same? I'm a bit confused by the Event Switcher and the DB read how they need to work together.
If I can check this I can add another check to see if the fields aren't filled in already, but I have to tackle the first problem.
If I can check this I can add another check to see if the fields aren't filled in already, but I have to tackle the first problem.
Ok, I almost got it. My last issue is updating the record instead of creating a new one. I am trying to set the form->data['id'] as the idea I got from the DB read but it's not working, it keeps overwriting the id with the next one in line in the table.
OK I tried using a text field named id and inserting the id of the record into the textfield with form->data['id'] but when I submit it glitches and sends me to the homepage. If I remove this field the form gets submitted again, altough without the right id and in a new record. I've tried custom codes before the DB save and before the handling of the arrays but it's not working. I guess I try again tomorrow. Hm.
This topic is locked and no more replies can be posted.
