Dropdown from database with conditions

Hi,

You should use aliases in the queries. A DropDown field requires a column for the values of the choices, and another column for the texts of the choices, so the query would be:

SELECT DISTINCT CITY as value, CITY as text FROM DONNES WHEREFROM=<%fieldname1%>

For selecting the KMS and CO2 columns after selecting the field1 and field2, insert two Hidden DS fields in the form, with similar queries, but with two filtering options and only one element in the SELECT clause, for example:

SELECT CO2 AS value FROM DONNES WHEREFROM=<%fieldname1%> AND CITY=<%fieldname2%>

Best regards.

Hi,

I’ve tried to use escape symbols in the name of column ‘FROM’, in the queries of the previous ticket, because FROM is a reserved word in SQL, but this editor does not allow me insert the correct symbols.

Best regards.

Hello and thanks a lot for your help.

I have replaced my first query with yout suggest and it work perfectly.

However I must apologyze, because i’ve changed name of my columns with english words for your best comprehension (I’m french and i thought… so…). Ok, my columns are named like this :
DE, VILLE, KMS, CO2
DE (start city), VILLE (end city), KMS (distance between both), CO2 (pre-calcultated value).
No problem with FROM, the word reserved in SQL because your query became like this :
SELECT DISTINCT VILLE as value, VILLE as text FROM DONNES WHERE DE=<%fieldname1%>

And this, work perfectly, you know ??
https://www.fondationdelille.org/climat/?page_id=101

However for KMS an CO2, I do not understand the operations of hidden fields ?
I have filled these queries in hidden DS fields :
field KMS = SELECT KMS AS value FROM DONNES WHERE DE=<%fieldname1%> AND VILLE=<%fieldname2%>
field CO2 = SELECT CO2 AS value FROM DONNES WHERE DE=<%fieldname1%> AND VILLE=<%fieldname2%>

But how use this field ?

Hello

I used a “number DS” instead “hidden DS” and my calculator works perfectly now (hidden DS stay blank).

Few questions again :
– how get a field (number DS for example) on read only ?
– how send result to another page (to fill another field) ?

Thanks again for your attention, your work and your response.
Best Regards

Hi,

You can use the “Hidden DS” fields in the same way than “Number DS” fields, with the same queries, and use them in the equations.

If you want convert some fields as “readonly”, please follow the steps below:

1. Assign a class name to the fields you want convert in “readonly”, through the attribute: “Add Css Layout Keywords”, for example: myclass

And then, uses the equation below, in any of the calculated fields in your form:

(function(){
jQuery(‘.myclass’).prop(‘readonly’, true);
…
})()

In the previous equation replace the “…” by the rest of the equation.

To use the submitted information from a form, in another one, please, follows the intructions in the following entry of our tech blog:

https://blog.net-factor.com/how-to-use-the-data-submitted-by-a-form-in-another-one/

Best regards.

Thank you very much for your response.
Great plugin !