I would like to build a repeating group that refers to data from two data sources.
I have a data type that contains all the list of TEST required. And i have another DAILY LOG INPUT data type that is input from users on the TEST that they have conducted and the completion percentage %.
I would like to display the repeating group with the first column showing all the TEST from the TEST datatype. And the 2nd column & 3rd column to show the Input data from the Users. If there are no INPUT data from the users, the 2nd column and 3rd column will show 0% or NA.
Are the 2 datasets related? If not, could you just use 2 repeating groups side by side? If they are related, you may have to create a joint table bringing in both sets of data into one place, as a repeating group can only reference one source
I have created an additional field for TEST Datatype which is a list of DAILY LOG INPUT datatype. But i dont think that is what you mean.
How about would you create a joint table to bring both set of data? Using workflow? I am concerned that take a lot of resources as the DAILY LOG INPUT datatype is expected to have up to 2000 rows of data.
I still don’t quite understand the relationship between what you are displaying in column 1, and then in columns 2 and 3. Describing it more in table terms, are you expecting each row to have related data? So what displays in cells 2 & 3 is related to what is shown in the first cell? Or are these 2 entirely separate lists that you’re just needing to show on the same page simultaneously?
I have a TEST Datatype listing a series of tests required to be conducted on a equipment i.e. Test 1 to 10. Now i have another 10 equipment that requires to do all 10 tests respectively, i.e. total i need to conduct 10 test x 10 equipment = 100 tests. However, each test might be conducted at a different time and by different people. So i have a DAILY LOG INPUT Datatype which is filled out by the users / testers, indicating which tests was conducted that day. The testers will fill out the DAILY INPUT LOG every day for a period of say, 2 months, indicating which tests was conducted on which equipment and the respective completion progress.
I have designed the page to display all data for Equipment A, and another page to display all data for Equipment B. Column 1 will display all 10 tests of Equipment A. Column 2 and 3 will show the respective Test 1 to 10 data such as the completion % , testers name, date of test etc.
If i was doing it in excel, i would have column 1 as Test 1 to Test 10, while column 2 and 3 will VLOOKUP the DAILY INPUT LOG Datatype (table) to fill in the details. Any error from the VLOOKUP i.e. no test found was conducted for Equipment A, would then show as error or 0%.
I cannot make Column 1 or TEST Datatype to be an Option Set because the number and description of Tests will differ depending on client requirement. So the TEST Datatype has to be dynamic
Thanks for the thorough explanation, I think I understand more what you are looking to do. This one feels above my scope so I’m hoping someone else can jump in and save the day
If I’m thinking of this correctly, I feel what you may need to do is create a summarized log, where every time a tester updates a specific test, it triggers a value update on the summary. So if something is completed, it will add +1 to an already existing number, which would display on the dashboard you are building, but shown as a percentage.
Summarized Log is correct, but no maths required. There is an option for the Tester to declare completion % for the test in the DAILY INPUT LOG (thought it would be easier that way), so i can just do a search for :last item.
My problem now is i cannot make Column 1 display all tests i.e. TEST 1 to TEST 10. It only display whichever test that has been input by the testers in DAILY INPUT LOG. I want column 1 to show all available test and column 2 and 3 to show the data / details from the DAILY INPUT LOG, with regards to the Test 1, 2, 3 etc .
