Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

amp formulaire pdf conditionnel

New Here ,
Aug 04, 2024 Aug 04, 2024

Bonjour,

je n'arrive pas à écrire le bon scripte pour un calcul conditionnel dans le formulaire pdf acrobat:

Champ 1 (B2) = liste avec choix =1 ou choix =2

Champ 2 (C2) = chiffre à remplir par la personne

Champ 3 = résultat calculé

Dans excel cela donne:
=SI(B2=1;C2;SI(B2=2;C2*1,5))
Merci!

TOPICS
PDF forms
327
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 04, 2024 Aug 04, 2024

Try this code as the custom calculation script:

 

var B2 = this.getField("B2").valueAsString;
var C2 = Number(this.getField("C2").valueAsString);
if (B2=="1") event.value = 1;
else if (B2=="2") event.value = C2*1.5;
else event.value = "";
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 05, 2024 Aug 05, 2024

Hello and thank you, it's perfect like this and I understand 😉
There is just on the 3rd line, the modification *1

if (B2=="1") event.value = C2*1;

A beautiful day

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 05, 2024 Aug 05, 2024
LATEST

Ah sorry, I misread the syntax of the Excel formula.

Use this:

 

else if (B2=="2") event.value = C2;
else event.value = 5;

 

There's no need to multiply by one.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines