masterfight
Forum Replies Created
-
Forum: Plugins
In reply to: [Calculated Fields Form] Database connected but fields emptyHello
After another download (1.0.145), my form works perfectly.
https://www.fondationdelille.org/climat/cest-a-vous/calculez-votre-empreinte-carbone/Thanks for your attention
Best regards.
Forum: Plugins
In reply to: [Calculated Fields Form] Database connected but fields emptyHello
I dont’t understand “outdated” !
My version is 5.0.23 but the online version is 1.0.141 (cf capture).
If i really outdated (!!!), please send me URL for download an another version.In detail, you see my form here
https://www.fondationdelille.org/climat/?page_id=101… and capture of settings here
… and database structure here.
Thanks for your attention
Forum: Plugins
In reply to: [FB Display Events Shortcode] Shortcode not workingHello !
Same problem : shorcode not working.
Can you help us Krzysztof Kuziel ?Best regards
https://www.masterfight.net/Forum: Plugins
In reply to: [Calculated Fields Form] Dropdown from database with conditionsThank you very much for your response.
Great plugin !Forum: Plugins
In reply to: [Calculated Fields Form] Dropdown from database with conditionsHello
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 RegardsForum: Plugins
In reply to: [Calculated Fields Form] Dropdown from database with conditionsHello 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=101However 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 ?