Hi,
I am trying to use a form to edit data from a table in my OneDrive.
The table has 2 column that together act as a unique record keys: 1) the asset name 2) the date. The rest of the columns have observation data on the asset for a specific date.
My form is always blank because I can't seem to select just one record. It's not clear to me what I should put as the "Data Source" vs "Item".
I have had luck indentifying the unique record in a Data table
First(Sort(Filter(Asset_Data, Gallery1.Selected.Asset = Asset),Date,Descending)) .... where Gallery1.Selected.Asset is the result of the user selecting the Asset from a gallery list.
But I can't seem to translate this code that works in a Data Table into what I need to identify a record for the Form.
Any thoughts? Thanks
Solved! Go to Solution.
Hi @schneice,
I think i get what you are doing. Could it work in two steps?
Hi @schneice,
It may be easier than you think if your data source for the Gallery is the same as the data source for your Edit form. If so, then the Item property is should be: Gallery1.Selected. If not, let me know. A couple of other suggestions.
I hope this helps.
Thanks!
They are from the same source. The issue with the Gallary1.Selected, is that it selects only one of the parameters - the asset. No need for the user to see the asset listed once for every day as they are drilling down.
It is not clear to me how a combined field would help here. I still need to filter the dataset for the asset and then pick the most recent record. The query to get the most recent record would still have to be on a second field, and it feels cleaner to have it on a date than asset+date.
It seems like there should be a way to use first or lookup to identify the unique record for the form. It works for Data table. But maybe you can't.
Hi @schneice,
I think i get what you are doing. Could it work in two steps?
Drrickryp - That was money! Thanks