Database lookup

Hi,

Yes, that is possible but only in the versions of the plugin: Developer or Platinum, both versions of the plugin include an additional set of controls, with the text DS in their names, whose values are gotten from external data sources, the database is one of them.

So, it is possible to insert a DS field and to use other fields in the filtering options, in your case, get a result based on a calculated field:

https://cff.dwbooster.com/documentation#datasource-fields-settings

Best regards.

Thank you so much!
now, second question…
I’m planning to insert a button to calculate and get results.
with developer plugin is it possible to store the entered input and results got by a user?
I mean,
a user enters inputs, clicks on the “calculate” button and all inputs, results and username are stored in a DB table or in a CSV file.
is it possible with developer plugin?
thanks

Hi,

All the paid versions of the plugin are able to store the submitted information in the database’s tables included by the plugin, however, if you want to store the submitted information in another table or database, you will need the Developer or Platinum versions of the plugin. Both of them include a script file to interact with other MySql databases (please, visit the following link: https://cff.dwbooster.com/documentation#third-party-database).

If you want the registered users can submit their data, and accessing to the list of submitted information from their pages, you should install the developer or platinum versions of the plugins to use the “Users” add-on. Please, visit the following links:

https://cff.dwbooster.com/add-ons/users-permissions#begin

https://cff.dwbooster.com/documentation#users-addon

Best regards.

Hi,
I have used your plug-in on several sites with great success. I have a new client who needs some specific functionality. It looks like what he wants the form to do may be possible. It is an order entry system. Here are the requirements:

1. Enter a new order and have all the results stored in a table
2. Modify an existing order by selecting an order number from a drop-down populated from previous entries specific to him. The order number could be selected independently prior to showing the form if that helps. (SQL Filter?)
3. On selection of the order number have the form pre-populated from data in the associated database record.
4. Revise the entries and have the results over-write the old database record on save.

Does that sound possible? And if the form has entry fields hidden/shown based on the setting of some form element (a checkbox, say) and the state of the checkbox is stored in the database, would that area automatically switch to being hidden/shown on record load?

I understand some of these requirements will only be in the Developer version. I assume that this version can be used as is, if appropriate?

Thanks so much for taking the time to answer my questions. I really do want to use this plug-in.

Hi,

I guess you are needing in your project the “Users” add-on, distributed with the developer and platinum versions of the plugin. Please, visit the following links:

https://cff.dwbooster.com/add-ons/users-permissions#begin

https://cff.dwbooster.com/documentation#users-addon

Best regards.