Thanks for your interest in Formulize and Pageworks.

These tools are meant for rapidly creating a new application or database, not for working with one you already have. However, you could create a form (think of it like a table) in Formulize, and then import data from your existing database. You would have to get a spreadsheet copy of the data in your existing database, and make sure the options in the form matched the possible values in each field of your existing database...the information in the Import popup box should guide you.

Let us know how it goes if you pursue this further. Good luck,

--Julian

Yeah, Formulaire is made in France. Philou is the user on XOOPS who maintains it.

--Julian

Can somebody with admin access please, please, please update the copy of Formulize that is in the repository? The version in the repository is 2-and-a-half years old. The latest version can be got here:

http://www.freeformsolutions.ca/formulize

Also, I apologize for not paying close attention on this, but can anyone fill me in on when/if the info that was in dev.xoops.org will be part of another site? There was three years for support postings and examples and stuff in those forums that was very useful to Formulize users and I would like to see them back on the web sometime.

--Julian

Unfortunately, no. There is no import process between Formulize and Formulaire, or vice versa. The data structures are very similar though. If you're good with phpMyAdmin, you may be able to copy entries from the _formulize table and _formulize_id table to the _form table and _form_id table. It may work as is with no modifications, or maybe some of the data would have to be altered to fit. I'm not sure if all the fields are a perfect match still.

--Julian

I am not sure what you are doing wrong. Maybe nothing, maybe it is a configuration problem.

It would help if you can paste in the exact code you are using, and say the name of the path and file with the code.

--Julian

Sorry for the delay. Code stuff always requires more thought. So I tend to put it off.

Quote:

Yes, I think I left out something important. You need to include the following file:



You might need other files too from time to time. You should look for the function names in the modules/formulize folder and include the files that have the functions you are using.

Quote:

I'm not sure what you're asking. You could use PHP code like the code above. If you put that code in your file, then you could assign $age to the smarty template.

Is that what you are asking?

--Julian

Hello, thanks for your interest in Formulize.

Some answers...probably not all good, but here we go:

You cannot currently have more than one subform displayed at once. That will be changed in the next release.

Permissions are per-form. So if someone has rights to create an entry in a given form, it has no bearing on their rights to create an entry in another form. Permissions in a form cannot be limited based on the content of entries. That would be a nice feature though!

There is a complicated way you can get global search to work with Pageworks. If you really, really want to do this, we can provide more details. It's limited in is usefulness though. The intended route is to let people search using the list of entries interface (or a subset of it that you make available through the "screens" controls, which are on the settings page (fourth icon, @ symbol and envelope on the admin page beside each form)).

We haven't tested with XOOPS 2.0.18 so I can't say what the issue is there at the moment.

Registered Users are often excluded for consideration in Formulize. Registered Users literally means everyone with an account. It's almost always counter-productive to give permissions to Registered Users, because what you really mean is you want to give permission to "all staff" or something like that. All users who have accounts is different from all staff, even though it may be that the two groups of users are identical.

It's a semantic thing, but it's important. Because later on, you might have a new bunch of users in your site, and all your permissions are tied to Registered Users. But as soon as the meaning of Registered Users changes because you have new users in your site who aren't staff, now all your permissions are screwed up.

You should create specific groups for every collection of people you want to assign permission to, and only use Registered Users for things that are genuinely for every single person who has an account in your site, no matter who they are.

Sorry if in your case, this distinction is academic. It's central to most sites that make interesting uses of Formulize. To make it easy to manage users in groups, and copy, or move, users from one group to another, you could install the Registration Codes module. You don't have to do anything in terms of creating codes or making a custom profile form like the Reg Codes readme describes, you just have to install the module, and then in the Reg Codes admin area, you will have a link to the "User Manager" and it will help you re-organize your users.

Sorry I don't have better news on these points. Let me know if you'd like more details.

--Julian

Hello,

In the Formulize 2.3 RC1 zip file, there is another .zip file called xoops_2.0.x_datebox_patch.zip. That's the patch file referred to. It's not critical for the operation of Formulize, but does greatly improve the behaviour of dateboxes, by introducing a true non-date default value (YYYY-mm-dd).

If all you want is a form that people can fill in and the results get sent to an e-mail address, you may want to try Formulaire.

In Formulize, you can click the Notifications button on the list of entries page, and specify there what e-mail messages you want sent to whom when entries are created, modified or deleted.

--Julian

You're using a really old version of Formulize, possibly 2.0 something. It is not compatible with PHP 5. You need to upgrade to the latest version. You can get the latest version here:http://www.freeformsolutions.ca/formulize

Read the readme file. Follow the upgrade instructions carefully, especially step 6. If the main admin page of Formulize does not say 2.2 at the bottom, then you need to do step 6.

Let us know if that fixes the issue. Good luck,

--Julian

Hello. This is an interesting post. If I understand what you are saying, then I think the answer to your question is this:

If you have a custom profile form, how can you use that information in other modules?

OK, imagine that your profile form is form number 3, we will use that in this example. You will need to use the actual number from your site. If your profile form is 5, use that number. If it is 1, use that number.

Also, imagine that the "age" question is number 12. Each question in a form has a unique number. You can find this number by editing the question and looking in the URL. The "ele_id" in the URL is the question number.

Last...you need to know the user ID number (uid). Each user has their own number, and you need to know the user you want to get information for.

You will need to work with the PHP code in your module. Once you are working with PHP code, you can do what you need.

In PHP, do this:



Does that answer your question at all?

You can get more information about Formulize here (including documentation about the PHP functions):

http://www.freeformsolutions.ca/formulize

--Julian