cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Konrad91
Level: Powered On

Select multiple lines in a Data Table and put the same comment for all of them

Hello,

 

I have a data table (SQL source) in which users select a line and in an edit form they put a comment and submit it. They can select one line at a time though and it would be very convenient for them to put the same comment for multiple lines. How could I achieve that?

 

Many thanks!

Konrad 

1 REPLY 1
Community Support Team
Community Support Team

Re: Select multiple lines in a Data Table and put the same comment for all of them

Hi @Konrad91 ,

 

Could you please share more details of your data source's columns?

Do you want to save multiple lines with one same comment?

You can try the following workaround, I test as next:

DataSource:[dbo].[Table_20190412SaveMore]  (the table name in my sql)

ID(int PrimaryKey)

Comment(nchar(10))

20190412savesamecomment1.PNG

App Test:

Add one ComboBox into the ID datacard, and ComboBox1.items:'[dbo].[Table_20190412SaveMore]'.ID 

Submit.OnSelect:ClearCollect(comtest,ComboBox1.SelectedItems);ForAll(comtest,UpdateIf('[dbo].[Table_20190412SaveMore]',ID=comtest[@ID],{CommentSmiley Very HappyataCardValue7.Text}))     (you can change the controls' name on your side)

20190412savesamecomment2.PNG

 

Result CheckSmiley Saduse the gallery can check or back to the datasource check)

20190412savesamecomment3.PNG

 

Hope this could be helpful.

 

Best Regards.

Yumia