Hello, I have 5 screens built into my app.
I have created a comment box in each screen to capture a log for everytime when someone modifies the form. I'm also trying to append all these comments into the comment log in the main screen.
So far, I was able to achieve appending comments from only one screen and I'm struggling to work with all the screens...Has anyone worked on this kind of scenario? Any help would be appreciated.
Solved! Go to Solution.
Hi @Ram3 ,
Do you want to combine data from multiple comment boxes in different screens to one main html box?
Actually, you could use data of multiple comment boxes from different screens directly in the main screen.
Just try Concatenate() function.
For example:
set the main html box's HtmlText:
Concatenate(RichTextEditor1.HtmlText,RichTextEditor2.HtmlText,....)
Maybe your data is more complex, you could try:
Concatenate(If(Not(IsBlank(RichTextComments1.HtmlText)), User().FullName & " " & Now() & " " & RichTextComments1.HtmlText & Char(13)) ,
If(Not(IsBlank(RichTextComments2.HtmlText)), User().FullName & " " & Now() & " " & RichTextComments2.HtmlText & Char(13)) ,
....,
ThisItem.Comment
)
If the solution that I post is not what you want, I suggest you describe with screenshoots in details.
I think I need to know more about what data that you want in the main html textbox.
Best regards,
It is a bit complicated than that.
If(Not(IsBlank(RichTextComments.HtmlText)), User().FullName & " " & Now() & " " & RichTextComments.HtmlText & Char(13)) & ThisItem.Comment
I'm using the above formula to concatenate the comments from RichTextComments into html box. Now, the question is I have other richtext comment boxes across other screens and I've to bring them into the main html box. Also, there might not be a necessity for comments in all the screens, there can be a comment in only one of them.
I've used this video if this adds any value.
Hi @Ram3 ,
Do you want to combine data from multiple comment boxes in different screens to one main html box?
Actually, you could use data of multiple comment boxes from different screens directly in the main screen.
Just try Concatenate() function.
For example:
set the main html box's HtmlText:
Concatenate(RichTextEditor1.HtmlText,RichTextEditor2.HtmlText,....)
Maybe your data is more complex, you could try:
Concatenate(If(Not(IsBlank(RichTextComments1.HtmlText)), User().FullName & " " & Now() & " " & RichTextComments1.HtmlText & Char(13)) ,
If(Not(IsBlank(RichTextComments2.HtmlText)), User().FullName & " " & Now() & " " & RichTextComments2.HtmlText & Char(13)) ,
....,
ThisItem.Comment
)
If the solution that I post is not what you want, I suggest you describe with screenshoots in details.
I think I need to know more about what data that you want in the main html textbox.
Best regards,
User | Count |
---|---|
184 | |
123 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
159 | |
132 | |
85 | |
78 |