I have four columns in my excel table..
Those are textInput with numbers ..
Everytime user enters the value in textInput .. values should get updated in excel sheet .. when second user enters the value the same values in same row and same column should get updated ..
Instead of adding next row everytime values should get updated in same row ...
Can someone help me with formula for the button ? So that on clicking button, details must get updated in excel..
Thankyou
Solved! Go to Solution.
@Shahin1 To track the Same row you can keep a unique ID column and when the user changes, you can Patch that row. Your formula will be something like,
Patch(ExcelTable, LookUp(ExcelTable, ID=SelectedID, {Column1: Text1, ........}
Hope this helps!
@Shahin1 To track the Same row you can keep a unique ID column and when the user changes, you can Patch that row. Your formula will be something like,
Patch(ExcelTable, LookUp(ExcelTable, ID=SelectedID, {Column1: Text1, ........}
Hope this helps!
If I follow your same formula by changing one closed bracket to the right of selected ID...
Thankyou @CNT
User | Count |
---|---|
256 | |
111 | |
95 | |
48 | |
40 |