Simple Forms [Paid] [Deleted]

[Rob]

lsxforo, what you are describing is essentially how checkbox fields are stored. I assume you want to store multiple values per field to support multi-select combo boxes and checkboxes?? Also struggling to understand what you mean

 

[John L.]

As I know the input data being stored to the field_value in response_field table.

Look at the table that having the data,

response_id, field_value

response_id     field_value
1                        melon
2                        apple
3                        banana

Currently your entire data from input form is stored likely columns by entry as see.

It changed if you can we may expect the table type to be row array.

response_id, fruit1, fruit2, fruit3, more....
1                     melon,  apple, banana, ....
2                     melon,  apple,  banana, ....
3                     melon like, apple like, banana like, .....

I manipulated the data properly a little bit after getting from the field_value and tried to change the table type to row arrangement. But this case seems to me not suitable what I want to handle it for future.
So, I have to design my own form and DB structure.

But, I think that your form became more very useful and nice to easy expand for more advanced tools if the another destination of store could be supported.

Please understand I'm not a native english and nor expert programmer.

It's not a problem lsxforo, so don't worry about your English . I'm going to have the developer respond to you and get into more detail with this. Hopefully he can help you more than I can !

 

[lsxforo]

It's not a problem lsxforo, so don't worry about your English . I'm going to have the developer respond to you and get into more detail with this. Hopefully he can help you more than I can !

Very welcome, and hope it outcome with more powerful functions.
In addition add the upload file to the field one like others.

 

[lsxforo]

lsxforo, what you are describing is essentially how checkbox fields are stored. I assume you want to store multiple values per field to support multi-select combo boxes and checkboxes?? Also struggling to understand what you mean

As I mentioned at code I just want to the data to be store at it's own table with each field values as Thread, Post, Conversation. I'm not mean this

multiple values per field to support multi-select combo boxes and checkboxes??

Adding a new destination and point to the data store type what user want to choice for his project purpose, this could be provide more convenient.

1. design a new table scheme data to be stored
2. add a destination to form at choice step.
3. View the result (just simple, or more combined query)

 

[John L.]

Hi lsxforo,

Let me know if we are not interpreting this correctly, but the addon allows you to export the data as a CSV file which would be in the format you're requesting. According to the developer that is .

 

[lsxforo]

Hi lsxforo,

Let me know if we are not interpreting this correctly, but the addon allows you to export the data as a CSV file which would be in the format you're requesting. According to the developer that is .

Yes, I will. and CSV is unnecessary at this time. rapidly woo. ~

 

[John L.]

@Rob

Perhaps I forgot that we added this, but you can apparently edit the default value of fields via query string in the URL.

https://liquidpro.atlassian.net/wiki/display/SF/Set+Field+Values+Via+URL

In 2.1.9 we've added the feature that allows you to use variables like {$visitor.username} to set the default value of the field to a username. However tagging users via form submissions is a different issue that we may not be able to tackle in 2.1.9. The other suggestion of putting forms on page nodes will be moved to another release. We have to size up the complexity of doing it first.

Just a heads up

 

[Rob]

Cool. I already knew about the querystring and use it myself. I mentioned it above.
John, consider allowing people to set a custom HTML header per form instead of having to bundle a ton of (not too flexible) bbcode into the pretext of the first field. That should be an easy addition and overcomes the lack of page embedding for now

 

[John L.]

Cool. I already knew about the querystring and use it myself. I mentioned it above.
John, consider allowing people to set a custom HTML header per form instead of having to bundle a ton of (not too flexible) bbcode into the pretext of the first field. That should be an easy addition and overcomes the lack of page embedding for now

I'm still not quite sure what you mean by HTML headers for the forms. The form uses the base XenForo HTML for the pages. To change any of that structure would mean taking the form out of that template and putting it in a blank template that has 0 structure/css/js to pull from. Which would break a lot of things.

Can you explain to me what you would like to do in detail so I can understand better? Pictures would help.

 

[Rob]

Ok... when you go to the form edit page you can say if it's active, where it redirects to when filled in and other data.
Consider adding a box on that page where we can enter raw HTML - it could just be called HTML header.
Whatever is entered into that box would just be output directly BEFORE the form - this won't change the native xenforo header.

I'll PM you a link and you'll see exactly what I mean.

Cheers,

Rob

 

[John L.]

Ok... when you go to the form edit page you can say if it's active, where it redirects to when filled in and other data.
Consider adding a box on that page where we can enter raw HTML - it could just be called HTML header.
Whatever is entered into that box would just be output directly BEFORE the form - this won't change the native xenforo header.

I'll PM you a link and you'll see exactly what I mean.

Cheers,

Rob

The description section that goes right below the h1 supports HTML. Not full-blown HTML because that presents security issues. You could always use template modifications to adjust the form template and add HTML above specific forms based on conditionals.

 

[Rob]

The description box isn't suitable, I've already tried that approach. The conditionals approach is a nightmare if you have more than a few forms, especially when you want to add a fair bit of HTML above the form.

Almost all sites using this mod have forms created by admins for public use..... I don't see an admin defined HTML header as a security risk especially given that field titles, descriptions and other parts of the mod already accept HTML. #justsaying

 

[John L.]

The description box isn't suitable, I've already tried that approach. The conditionals approach is a nightmare if you have more than a few forms, especially when you want to add a fair bit of HTML above the form.

Almost all sites using this mod have forms created by admins for public use..... I don't see an admin defined HTML header as a security risk especially given that field titles, descriptions and other parts of the mod already accept HTML. #justsaying

I don't agree, but I'll talk to the developer about it.

 

[VGWoody]

Is there anyway to create a field in a form to all a user to upload a picture? A Field Type for uploading?

Something along the lines of:

Upload your picture: "Browse"

 

[John L.]

Is there anyway to create a field in a form to all a user to upload a picture? A Field Type for uploading?

Something along the lines of:

Upload your picture: "Browse"

There is an option to enable the uploading of files for each form destination you create. And on the form itself you can set it to be required. It simply puts "Upload a File" next to the submit though. It's not a field.

 

[VGWoody]

Yeah that's what I have right now, but it's a bit confusing for user.

In the future it would be nice to have the upload button next to a field. That way you can specify what you are wanting the user to upload.

EX:

Upload a photo of yourself: "Upload a File"

 

[John L.]

Yeah that's what I have right now, but it's a bit confusing for user.

In the future it would be nice to have the upload button next to a field. That way you can specify what you are wanting the user to upload.

EX:

Upload a photo of yourself: "Upload a File"

We will look into it

 

[sbj]

I had exactly the same request some time ago .
I think 2 fields are missing. An "Upload button" field and a "clock/time" field.

Still waiting for this to happen .

 

[John L.]

I had exactly the same request some time ago .
I think 2 fields are missing. An "Upload button" field and a "clock/time" field.

Still waiting for this to happen .

It will not be in the next release which is pretty much done. Just fixing a few issues. We will look into it for 2.2.0

 

[sbj]

Just for clarification, you said for a bug:

1) In my ACP, I have created a multiple-choice drop-down selection field. Next to the choices I created, I see arrows.
But I can't move the choices and change their order. How can I accomplish this?

this:

I believe this is a bug and will look into fixing this for 2.1.9. Should be an easy fix.

Is this bug now solved for the next release?