You’re offline. This is a read only version of the page.
Announcements
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
Hi @Anonymous ,
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))
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],{Comment:DataCardValue7.Text})) (you can change the controls' name on your side)
Result Check:(use the gallery can check or back to the datasource check)
Hope this could be helpful.
Best Regards.
Yumia
Share
Report
All responses (
Answers (
765
