LinkedIn
Twitter
Thanks for the answer. I already had it this way but what happened was that the records were repeated in the lines, printing the same information 3 times in each line. Getting like this:
<<START:Produtos[Codigo Produto] >><<[CodigoBarra]>> | <<[CodigoBarra]>> | <<[CodigoBarra]>><<END>> |
thank you for the help
Thank you very much for the answer, Suvrutt_Gurjar I am starting with the appsheet and I have some difficulties yet, with your demonstration I got the result has not yet been satisfactory, because it was like this:
But starting from your idea I found a solution and solved part of the problem, now it is only left to find out how to make a range for each column in this piece of code in ([_ Rownumber], list (1,4,7) ... because in the first block All records should be located in this sequence 1,4,7,11,14,17 ... Until the end of the records, if I have an idea to help me get grateful.
Now the impression was as I needed.
Thanks also to Aurelien
The report was thus
Hi @Agasys ,
I tested my suggestion and it works perfectly. I realized that there was a typo in my earlier shared expression. Instead of comma "," there was a slash "/" in MOD() expression. The following template is corrected and it should work.
|
START:Produtos[Codigo Produto] >> <<IFS(MOD(COUNT( [CodigoBarra] )>> <<END>> |
<<START:Produtos[Codigo Produto] >> <<IFS(MOD(COUNT( [CodigoBarra] )>> <<END>> |
<<START:Produtos[Codigo Produto] >> <<IFS(MOD(COUNT( [CodigoBarra] )>><<END>> |
The test results in my test app are shown below.
The report looks like below
The products are arranged in the view as below. So you can see that in the report above, the images are aligned horizontally as 1, 2 , 3 and then 4, 5, 6 and then 7,8, 9 and then 10
Estimated friend Suvrutt_Gurjar, I greatly thank the attention to me, I had already detected the problem in the mod function and made the correction.
I now tested your solution again and I must be doing something wrong because the result is not expected.
The data is recorded like this
In the template it was placed like this
<<START:Produtos[Codigo Produto]>><<IFS(MOD(COUNT(SPLIT(ANY(SPLIT((" , " &Produtos[Codigo Produto] & " , "),(" , " &[Codigo Produto] & " , ")))," , ")) ,3)=1,[CodigoBarra])>> <<END>><<START:Produtos[Codigo Produto]>><<IFS(MOD(COUNT(SPLIT(ANY(SPLIT((" , " &Produtos[Codigo Produto] & " , "),(" , " &[Codigo Produto] & " , ")))," , ")) ,3)=2,[CodigoBarra])>> <<END>><<START:Produtos[Codigo Produto]>><<IFS(MOD(COUNT(SPLIT(ANY(SPLIT((" , " &Produtos[Codigo Produto] & " , "),(" , " &[Codigo Produto] & " , ")))," , ")) ,3)=0,[CodigoBarra])>> <<END>>
And the result presented is this
I could say where I am wrong
Again I thank you for your attention
Estimated friend Suvrutt_Gurjar, look at this situation, I got the expected result but it was necessary to include another information in the case " ", has any explanation for this fact?
In the template it was placed like this
And the result presented is this
Another question, if I want to put 4 columns instead of 3 what would the change be like?
<<IFS(MOD(COUNT(SPLIT(ANY(SPLIT((" , " &Produtos[Codigo Produto] & " , "),(" , " &[Codigo Produto] & " , ")))," , ")) ,4)=1,[CodigoBarra])>>
column1 = 1, column2 = 2, column3 = 3 and column4 0
Was this?
Again I thank you for your attention and apologize for my English
@Agasys wrote:
column1 = 1, column2 = 2, column3 = 3 and column4 0
You are correct.
@Agasys wrote:
Again I thank you for your attention and apologize for my English
You are welcome, You need not apologize at all. We all have different native languages. Even my native language is not English. Of course, I studied my college education in English.
This output looks decent. Even though I understand that each barcode can be in a separate cell. I will try different template format and revert , if I can manage to do the needful.
Your template is still not available. But anyway please do not share the document As I mentioned, your picture of template makes it clear how it is there. Please reduce the IFS() statement to just one per cell.
