Share
Report
3I am trying to 1. make a collection and 2. patch that collection to a table
I will illustrate both to make sure others who have similar issues can use my case to help themselves. Assuming someone helps me.
1. Make a collection (no issues with this collection written below)
Why: to store information when the internet is not available on a device to be submitted to a table once the internet is available.
Collect(storedtickets, {'Item Column':'Item Drop down'.Selected.Value,'Start Time Collumn':'Start Drop down'.Selected.Value, 'End date column':'End Drop Drop Down'.Selected.Value});
SaveData(storedtickets,"LocalSavedtickets")
The two photos below demonstrate the collection written in blue working:
2. Patch that collection to a table using a button
Table= (Mytabl99) where collection= (storedtickets) needs to be added:
The table is in excel under one drive:
I tried:
on select= Patch(Mytabl99,stored tickets) <<<gets the below error
So then tried:
on select= Patch(Mytabl99,First(storedtickets) <<< using (First) command to try and make it only one record instead of a table
I can't figure out why it says the above column 'End date Column' does not exist when as shown above it clearly does.
If anyone can assist or propose an alternative solution I would be very grateful thank you for taking the time to read.
All responses (
Answers (
