Automate

Hello

in my evolve form the procurement department have to insert the order unit. But the value par ex. "PAL" have to be in the conversion table of the alternative unit of measure. The conversion table is a repeating table.
I have a validation rule: if order quantity is not equal to alternative unit than error. But the rule only checks the first line from the repeating table and not all alternative units from all lines of the repeating table.

Thanks for your help.

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

Hi Jana - validation rules only work on the first line of a repeating table.  It can be tricky to find a workaround.   Is the order unit a single field or also part of a repeating table?  Can you share a screenshot of your form to help me understand a bit more what you are trying to accomplish?

------------------------------
Krista Zinna | Supply Chain Planner
Timken Company | (234) 262-2008
------------------------------

Original Message:
Sent: 10-03-2022 09:48
From: Jana Kuschmierz
Subject: Rule in evolve form concerning a repeating table

Hello

in my evolve form the procurement department have to insert the order unit. But the value par ex. "PAL" have to be in the conversion table of the alternative unit of measure. The conversion table is a repeating table.
I have a validation rule: if order quantity is not equal to alternative unit than error. But the rule only checks the first line from the repeating table and not all alternative units from all lines of the repeating table.

Thanks for your help.

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

Original Message:
Sent: 10/5/2022 8:35:00 AM
From: Krista Zinna
Subject: RE: Rule in evolve form concerning a repeating table

Hi Jana - validation rules only work on the first line of a repeating table.  It can be tricky to find a workaround.   Is the order unit a single field or also part of a repeating table?  Can you share a screenshot of your form to help me understand a bit more what you are trying to accomplish?

------------------------------
Krista Zinna | Supply Chain Planner
Timken Company | (234) 262-2008
------------------------------

Original Message:
Sent: 10-03-2022 09:48
From: Jana Kuschmierz
Subject: Rule in evolve form concerning a repeating table

Hello

in my evolve form the procurement department have to insert the order unit. But the value par ex. "PAL" have to be in the conversion table of the alternative unit of measure. The conversion table is a repeating table.
I have a validation rule: if order quantity is not equal to alternative unit than error. But the rule only checks the first line from the repeating table and not all alternative units from all lines of the repeating table.

Thanks for your help.

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

What is the range you are using for the drop down list for Bestellmengeneinheit?  I would suggest instead of using a drop down list of all possible order units, pull directly from the repeating table so that you are forcing the second user to only be able to leave Bestellmengeneinheit blank (if basic unit), or select only the Alternate units of measure that were listed in the repeating table.  Do you know how to do that?  In the properties, under range, you can select "Repeating Content" as a source and then the drop down will only list the values that the first user entered under Alternativmengeneinheit in the repeating table.




------------------------------
Krista Zinna | Supply Chain Planner
Timken Company | (234) 262-2008
------------------------------

Original Message:
Sent: 10-05-2022 12:07
From: Jana Kuschmierz
Subject: Rule in evolve form concerning a repeating table

Hello

 

The first department insert all units they need, could bei 1 oder 3 or 5 rows.

 

 

The second department could insert the field the order unit (if the order unit = basic unit they insert nothing)

It's a drop down list

 

 

If there is a value in "Bestellmengeneinheit", this value has to be one of the values from "Alternativmengeneinheit" (PAL, VE, KRT).

 

 

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.

 

Original Message:
Sent: 10/5/2022 8:35:00 AM
From: Krista Zinna
Subject: RE: Rule in evolve form concerning a repeating table

Hi Jana - validation rules only work on the first line of a repeating table.  It can be tricky to find a workaround.   Is the order unit a single field or also part of a repeating table?  Can you share a screenshot of your form to help me understand a bit more what you are trying to accomplish?

------------------------------
Krista Zinna | Supply Chain Planner
Timken Company | (234) 262-2008

Original Message:
Sent: 10-03-2022 09:48
From: Jana Kuschmierz
Subject: Rule in evolve form concerning a repeating table

Hello

in my evolve form the procurement department have to insert the order unit. But the value par ex. "PAL" have to be in the conversion table of the alternative unit of measure. The conversion table is a repeating table.
I have a validation rule: if order quantity is not equal to alternative unit than error. But the rule only checks the first line from the repeating table and not all alternative units from all lines of the repeating table.

Thanks for your help.

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