Hi all,
I am trying to create a edit form, the items for the form are selected from the gallery.
I have the following currently:
List = ep_users
gallery = gallery_edit
form = form_edit_user
Within the gallery_edit.items I have the following code:
SortByColumns( Filter( AddColumns( ep_users, "PersonsName", user_info.DisplayName ), StartsWith(user_info.DisplayName, txt_search_edit_screen.Text) Or EndsWith(user_info.DisplayName, txt_search_edit_screen.Text) Or StartsWith(user_info.Email, txt_search_edit_screen.Text) ), "PersonsName", Descending )
Within the form_edit_user.DataSource I have:
ep_users
Within the form_edit_user.item I have:
gallery_edit.Selected
I am getting the following error under form_edit_user.item
Invalid formula. Expected a value compatible with 'DataSource'
Any help on this will be greatly appreciated.
Thanks 🙂
Solved! Go to Solution.
I have managed to find a solution, for the select icon for each item in the gallery, for OnSelect instead of it being Select(parent) (or whatever it defaults to) I have created a variable which is updated whe the icon is pressed to capture the ID, the item field for the form is then set to this variable.
The item() property of a form I believe needs to relate back to the datasource in its DataSource() property. You should retreive one item from the datasource to populate the form. So something like the below example:
First(Filter(myDatasource, valueInDB = selectList.Selected.value))
You need to relate some (probably a distinct) value back to a record.
I have managed to find a solution, for the select icon for each item in the gallery, for OnSelect instead of it being Select(parent) (or whatever it defaults to) I have created a variable which is updated whe the icon is pressed to capture the ID, the item field for the form is then set to this variable.
User | Count |
---|---|
159 | |
86 | |
68 | |
63 | |
62 |
User | Count |
---|---|
209 | |
150 | |
93 | |
81 | |
68 |