Help in Requirement

[Prithvi Ramesh1]

There is a catalog item with a variable that references the "ast_contract" table. Whenever a contract number is selected, it should be in numerical order. The following attributes have been used for the variable:

• ref_auto_completer=AJAXTableCompleter
• ref_ac_columns=contrct
• ref_ac_order_by=vendor_contract
• ref_ac_columns_search=true

Each time a value is selected, it should be unique. Additionally, after selecting a value, the latest value should be set as the default without needing to select it manually. How can this be achieved?

[Ankur Bawiskar]

@Prithvi Ramesh1 

it's a reference variable

I didn't get this part -> Each time a value is selected, it should be unique. Additionally, after selecting a value, the latest value should be set as the default without needing to select it manually. How can this be achieved?

can you explain with screenshots what is required exactly?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Prithvi Ramesh1]

Let's say, for example, CNTR0009001 has been selected for the first time.

The next time, the next available number should be set as the default, and so on.

[Ankur Bawiskar]

@Prithvi Ramesh1 

then basically you want to know the previous value selected

I doubt you can access the mrvs value of already selected row

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Prithvi Ramesh1]

MRVS does allow us to select the same value multiple times, as shown in the screenshot below -