hi,
i create a new collect by click a button
add a new gallery by using source data from collect "tblNewItemData"
in the combobox is set datasource from collect "tblMaterialMaster.Title"
when user is able to add new item data
using plus sign to add new line item:
Patch(tblNewItemData,ThisItem, {Product:(LookUp(tblMaterialMaster,Title=cbProductName.Selected.Title,Product)),ProductName:cbProductName.Selected.Title, DelQty: Value(txtQty.Text), BaseUnit:txtBaseUnit.Text, ShipTo: txtShipTo.Text, ShipmentNo: txtShipmentNo.Text, VesselNo: txtVessel.Text, ItemText: txtItemText.Text, New:"Added"}); Collect(tblNewItemData, {Product:"", ProductName:"", DelQty: "", BaseUnit:(LookUp(tblMaterialMaster,Title=cbProductName.Selected.Title,Base_Unit.Value)), ShipTo: "", ShipmentNo: "", VesselNo: "", ItemText: "", New:"New" })
the problem is combobox doesn't update and display blank
how to fix this problem?
Thanks,
Ratana
Solved! Go to Solution.
Hi @ratanapouy ,
Could you please share a bit more about the cbProductName? Is it the ComboBox within your Gallery?
Could you please show more details about the DefaultSelectedItems property formula of the cbProductName in your Gallery?
Please consider set the DefaultSelectedItems property formula of the cbProductName ComboBox in your Gallery to following formula:
{ Title: ThisItem.ProductName }
set the Items property of the cbProductName ComboBox to following:
tblMaterialMaster.Title
Please take a try with above solution, then check if the issue is solved.
Best regards,
What is the default property formula for cbProductName (added).
Hi @ratanapouy
Also can you check the below:
The datasource of combobox is set to collection - tblMaterialMaster
when you add new record, you can write Collect(tblNewItemData, {}) // defaults will be considered
Also you need not have "+" icon for each row, it can be placed above the gallery
Thanks.
If the item got added to tblNewItemData correctly using Collect() and ProductName has the correct value but isn't showing in the combobox afterwards then it most likely has to do with how the Default/DefaultSelectedItems is configured.
I understand that the combobox has the Items property set to tblMaterialMaster but is the formula used for the properties Default and DefaultSelectedItems?
Hi @ratanapouy ,
Could you please share a bit more about the cbProductName? Is it the ComboBox within your Gallery?
Could you please show more details about the DefaultSelectedItems property formula of the cbProductName in your Gallery?
Please consider set the DefaultSelectedItems property formula of the cbProductName ComboBox in your Gallery to following formula:
{ Title: ThisItem.ProductName }
set the Items property of the cbProductName ComboBox to following:
tblMaterialMaster.Title
Please take a try with above solution, then check if the issue is solved.
Best regards,
(added) below cbProductName is an indicator textbox to identify it is new item or saved item.
User | Count |
---|---|
142 | |
142 | |
78 | |
75 | |
72 |
User | Count |
---|---|
228 | |
143 | |
78 | |
62 | |
57 |