Automate

 View Only
  • 1.  Settings - Input number format

    Posted 09-05-2022 08:04

    Hello

     

    In Sitzerland we use the point instead of the comma.

    In our keyboard number block there is a point like on this picture

     

     

    But in the number fields in my forms I need to insert a "," to wirte perhaps 10,50.

    When the user now is using the point instead of the comma it will transfer into 1050.

     

    There is a high risk that my users insert it wrong because we use always the point.

     

    How can I transfer the point inserting in a comma?

     

    Freundliche Grüsse

    Jana Kuschmierz
    Leiterin Verkaufsinnendienst

    Tel. direkt: +41 62 887 70 34
    Mobil: +41 79 127 07 74
    jana.kuschmierz@rigips.ch

    _____________________________

    Rigips AG
    Gewerbepark – Hintermättlistrasse 1 – 5506 Mägenwil – Schweiz
    Tel. +41 62 887 44 44 – www.rigips.ch

     

     

    Es gelten die Allgemeinen Geschäftsbedingungen der Rigips AG, abrufbar unter rigips.ch/agb.

     



  • 2.  RE: Settings - Input number format

    Employee
    Posted 09-26-2022 11:31
    If the user's Excel and SAP number formats are set to match, I think there should be no need to transform anything in Winshuttle. It would cause more confusion to the users. As a developer, I would just rely on the users to be careful and follow your set conventions.

    ------------------------------
    Jayasri Varyani | SE
    Winshuttle North America |
    ------------------------------



  • 3.  RE: Settings - Input number format

    Posted 09-26-2022 11:50

    Hello

     

    We can insert a point in SAP that's works fine. But we never use the comma.

     

    So I need to make it like a textfield than it worked with point. But then there is a risk the user writes a letter.

     

    Or do you have an idea which rule can secured that only numbers with a point an maximum 3 decimal are allowed?

     

    Freundliche Grüsse

    Jana Kuschmierz
    Leiterin Verkaufsinnendienst

    Tel. direkt: +41 62 887 70 34
    Mobil: +41 79 127 07 74
    jana.kuschmierz@rigips.ch

    _____________________________

    Rigips AG
    Gewerbepark – Hintermättlistrasse 1 – 5506 Mägenwil – Schweiz
    Tel. +41 62 887 44 44 – www.rigips.ch

     

     

    Es gelten die Allgemeinen Geschäftsbedingungen der Rigips AG, abrufbar unter rigips.ch/agb.

     






  • 4.  RE: Settings - Input number format

    Posted 10-03-2022 09:38
    Hello

    I'm using the evolve form. There is the problem. When I choose a number field, then it ist not possible to insert a Number with a point like "10.5". When the user insert this, in the form the point will be delete and the value is "105". There is a very high risk that the user makes a fault. But when i choose the field typ = text, then the user can insert letters and this is also wrong.

    So I need a rule, that in the textfield it is only possible to insert a number without decimal or a number with max. 3 decimal.

    ------------------------------
    Jana Kuschmierz | Leitung VID
    Rigips AG | 0041628877034
    ------------------------------



  • 5.  RE: Settings - Input number format

    Posted 10-11-2022 03:58
    Hi Jana,

    we had same kind of problem for value of Net_Weight. We set it ot a textfield and use a Validation Rule for this field with the conditon:
    ( Net_Weight is not blank AND Net_Weight does not match pattern ^0$|^[1-9]\d*$|^\.\d+$|^0\.\d*$|^[1-9]\d*\.\d*$ )
    By using the pattern we can avoid the use of characters other then numbers.
    If the user enters different characters a message is shown "Value must be numeric".


    ------------------------------
    Jan van Asseldonk | Consultant
    CTAC | +31629078169
    ------------------------------



  • 6.  RE: Settings - Input number format

    Posted 10-19-2022 05:09

    Hi Jana,

    please reply in this site:

    Your response was:

    Hello Jan

    many thanks for your help.

    Now I can only insert numbers with a point as "comma"
    BUT I need to limited the amount of decimal places to 3.

    Mean, I should only insert numbers with max. 3 decimals like 10.555 BUT NOT MORE like 10.555555

    Do you know how can I limited the amount of decimals?

    Best regards
    Jana

    Answer:
    Try: ^(\d*)[.](\d{0,3})$
    {0,3} means you can use 0 to 3 decimals. * means unlimited decimals.

    Check https://regex101.com/r/9YXAkc/1/ for more examples and explantion of how you can use REGEX for setting up and checking field values.



    ------------------------------
    Jan van Asseldonk | Consultant
    CTAC | +31629078169
    ------------------------------