Skip to main content
K
klothos
Known Participant
October 18, 2018
Question

app.alert

  • October 18, 2018
  • 12 replies
  • 2595 views

Hello.I have this

// Get field values as numbers

    v1 = +getField("Text8").value;

v2 = +getField("Text9").value;

v3 = +getField("Text11").value;

v4 = +getField("Text12").value;

v5 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep").value;

v6 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep0").value;

v7 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep1").value;

v8 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep2").value;

v9 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep3").value;

v10 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep4").value;

v11 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep5").value;

v12 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep6").value;

v13 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep7").value;

v14 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep8").value;

v15 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep9").value;

v16 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep10").value;

v17 = +event.value;

if( v1+v2+v3+v4>v5+v6+v7+v8+v9+v10+v11+v12+v13+v14+v15+v16) {app.alert("ΛΑΘΟΣ! 712 μεγαλύτερο του 711 οι Εξαγωγές αγαθών εντός του ομίλου πρέπει να είναι μικρότερες η ίσες με τις Συνολικές Εξαγωγές αγαθών"); event.rc = false;

}

if( v1+v2+v3+v4<v5+v6+v7+v8+v9+v10+v11+v12+v13+v14+v15+v16) {app.alert("ΛΑΘΟΣ! 712 μεγαλύτερο του 711 οι Εξαγωγές αγαθών εντός του ομίλου πρέπει να είναι μικρότερες η ίσες με τις Συνολικές Εξαγωγές αγαθών"); event.rc = false;

}

I want this to work after the summing is completed from v5 till v16.

THANKS

This topic has been closed for replies.

12 replies

K
klothosAuthor
Known Participant
October 23, 2018

οκ. let's do something else.Let the sums be done without any control but this should be done when we save the pdf file.When we will save the file then the alert appears.Ι think this sounds easier.Thanks

    K
    klothosAuthor
    Known Participant
    October 18, 2018

      HELLO

    v1           10EU
    v2           10EU

    v3            10EU
    v4            10EU

                  THIS IS 40EURO   

     

    v5
    v6
    v7

    v8
    v9
    v10
    v11
    v12
    v13
    v14
    v15
    v16
    v17   locked calculate pick(v5+.....v16)

    v17=v5+v6+………..v16

    FOR EXAMPLE FOR ONE CASE I CAN USE ONLY V5,V6 AND V7 OR MAYBE MORE OR LESS

    IF V5+V6+V7>40 WRONG

    IF V5+V6+V7<40 WRONG

    IT MUST BE V5+V6+V7=40

    I USED THIS CODE

    if( v1+v2+v3+v4>v5+v6+v7+v8+v9+v10+v11+v12+v13+v14+v15+v16) {app.alert("ΛΑΘΟΣ! 712 μεγαλύτερο του 711 οι Εξαγωγές αγαθών εντός του ομίλου πρέπει να είναι μικρότερες η ίσες με τις Συνολικές Εξαγωγές αγαθών"); event.rc = false;
    }
    if( v1+v2+v3+v4<v5+v6+v7+v8+v9+v10+v11+v12+v13+v14+v15+v16) {app.alert("ΛΑΘΟΣ! 712 μεγαλύτερο του 711 οι Εξαγωγές αγαθών εντός του ομίλου πρέπει να είναι μικρότερες η ίσες με τις Συνολικές Εξαγωγές αγαθών"); event.rc = false;

    BUT IT WORKS WHEN I START TO SUM THE CELLS.I WOULD LIKE THIS TO APEAR WHEN I WILL FINISH THE SUM.

    THANKS

    Bernd Alheit
    Community Expert
    Bernd AlheitCommunity Expert
    Community Expert
    October 18, 2018

    Use a form button for the calculation and the test.

    Or remove the app.alert and display the message in a text field.

    Karl Heinz Kremer
    Community Expert
    Karl Heinz KremerCommunity Expert
    Community Expert
    October 18, 2018

    Let’s take a step back: What exactly is it that you want to accomplish? Please describe with words and not a formula.

    T
    Test Screen Name
    Legend
    October 18, 2018

    So your actual need is just to make sure that V5+V6+V7 is exactly 40? That's easy.

    But your code doesn't do anything like that.

    You have if( v1+v2+v3+v4>v5+v6+v7+v8+v9+v10+v11+v12+v13+v14+v15+v16)

    which means the same as

    if (

      ( v1+v2+v3+v4>v5+v6+v7+v8+v9+v10+v11+v12+v13+v14+v15+v16) != 0

    )

    and seems to have no connection to anything.

    I don't think you have given us your full needs. If your only need is just to make sure that V5+V6+V7 is exactly 40, then what do you do with the other values? Why are they there?

    We just don't understand at all, and can't help you write code that works until we do understand. Please explain your WHOLE JOB, not examples of pieces of it.

    K
    klothosAuthor
    Known Participant
    October 18, 2018

    where can i have your mail ?

    K
    klothosAuthor
    Known Participant
    October 18, 2018

    i am so confused.

    Lets try to do it without all fields.It would help if i will sent you all the file?

    Bernd Alheit
    Community Expert
    Bernd AlheitCommunity Expert
    Community Expert
    October 18, 2018

    This will not help because I don't know what you want you check.

      K
      klothosAuthor
      Known Participant
      October 18, 2018

      i am sorry forget the preview.Read this

      ok but when i decide to stop at v5+v6+v7 or v5+v6+v7+v8 it works only if this sum is >v1+v2+v3+v4 if it is <v1+v2+v3+v4 it does not work.It works only if i use all the fields. v5+................+v12. What am i say is that there are cases that i have to stop to field5 or field6,and it does not work if this sum<v1+v2+v3+v4

      Bernd Alheit
      Community Expert
      Bernd AlheitCommunity Expert
      Community Expert
      October 18, 2018

      Want you fill all fields or not?

        K
        klothosAuthor
        Known Participant
        October 18, 2018

        ok but when i decide to stop at v1+v2+v3 or v1+v2+v3+v4 it works only if this sum is >0 if it is <0 it does not work.It works only if i use all the fields. v1+................+v12. What am i say is that there are cases that i have to stop to field5 or field6,and it does not work if this sum<0

        K
        klothosAuthor
        Known Participant
        October 18, 2018

        // Get field values as numbers

            v1 = +getField("Text8").value;

        v2 = +getField("Text9").value;

        v3 = +getField("Text11").value;

        v4 = +getField("Text12").value;

        v5 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep").value;

        v6 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep0").value;

        v7 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep1").value;

        v8 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep2").value;

        v9 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep3").value;

        v10 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep4").value;

        v11 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep5").value;

        v12 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep6").value;

        v13 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep7").value;

        v14 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep8").value;

        v15 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep9").value;

        v16 = +getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep10").value;

        v17 = +event.value;

        if (getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep").value !=""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep0").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep1").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep2").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep3").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep4").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep5").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep6").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep7").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep8").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep9").value!""

        &&getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep10").value"")

        if( v1+v2+v3+v4>v5+v6+v7+v8+v9+v10+v11+v12+v13+v14+v15+v16) {app.alert("ΛΑΘΟΣ! 712 μεγαλύτερο του 711 οι Εξαγωγές αγαθών εντός του ομίλου πρέπει να είναι μικρότερες η ίσες με τις Συνολικές Εξαγωγές αγαθών"); event.rc = false;

        }

        if( v1+v2+v3+v4<v5+v6+v7+v8+v9+v10+v11+v12+v13+v14+v15+v16) {app.alert("ΛΑΘΟΣ! 712 μεγαλύτερο του 711 οι Εξαγωγές αγαθών εντός του ομίλου πρέπει να είναι μικρότερες η ίσες με τις Συνολικές Εξαγωγές αγαθών"); event.rc = false;

        }

        i have done this and i have syntax Error:missing) after condition 25 at line 26

        Bernd Alheit
        Community Expert
        Bernd AlheitCommunity Expert
        Community Expert
        October 18, 2018

        Use != "" not !""

        I miss also {   }

        K
        klothosAuthor
        Known Participant
        October 18, 2018

        I FORGOTTO TELL YOU THAT v17=v5+v6+v7+v8+v9+v10+v11+v12+v13+v14+v15+v16

        Bernd Alheit
        Community Expert
        Bernd AlheitCommunity Expert
        Community Expert
        October 18, 2018

        You must first check the content of the fields:

        if (getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep").value != ""

        && getField("MtaBO_Kal_nepoia8LaTWV_TOI1IK6V_110VQTUWVOTnV_flep0").value != ""

        && ...

        ) {

        ... your code ...

        }

        K
        klothosAuthor
        Known Participant
        October 18, 2018

        TO V17

        Show more replies
        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices