Hi,
I am trying to validate the data in column by using formula. Let's say column key is Column1.
The formula i am writing is IF([Column1]=[/ultragrid1/Column2(1)],[Column1],'error').
I am getting the error of circular reference as i am using same column name in the formula. My objective here is validating the data against some standard list of data loaded in another grid. I can't use the dropdown list to acheive this.
Is there any way to acheive this by using formula refering to same column?
Thanks for your help.
Srinivas
Hello Srinivas,
I try to reproduce your issue in a small sample, using our latest version - 12.1.20121.2024, but without success. Could you please tell me what is your current version and do you have any installed service release and which one If you are using older build, you could download the latest available service release from our site: Infragistics.com -> Accounts -> My Keys and Downloads.
Please let me know if you have any questions.
Regards
I am using version 11.1.20111.2090. You are writing the formula in column 2. But my case is to write the formula in column 0 itself while column 1 in some other grid loaded on the same form. Follow the steps to reproduce the error.
Step 1 : Create a form and add two wingrids and name as ultragrid1 and ultragrid2
Step 2 : Add a column named "Items" in ultragrid1 and add rows with data {Apple,Mango,Grapes}. This is just an example my original grid will have lot of other information
Step 3 : Add two columns named "Items" and "Price" in ultragrid2.
Step 4 : Write the formula for column "Items" in ultragrid2 as IF([Items]=[/ultragrid1/Items(*)],[Items],'Error')
Step 5 : Add a row or bind with some data in datatable , you can come across the error of Circular reference for the column "items".
The objective is to validate the data entered in grid ( "ultragrid2") for column ("Items") against the data present in grid ("ultragrid1").
I can't use the dropdown list because i have huge number of rows from 50000 to million.
I can provide a sample application if you are not able to reproduce the error.
Thanks,
Thanks for provided details, but for such kind scenario this is absolutly expected behavior. You apply a Formula to the "Items" column, by this way you change (modify) the data in the current cell in that column and apply again formula and so on .... That`s why you get circular reference error.
I`m not familar with your scenario and final goal, but maybe you could try to use additional Unbound Column. Also if you need to validate your data, you could try to implement UltraValidator.
Please let me know if you have any further questions.