Hello,
I am trying to get an "autocorrect" function within my application built. This is so that if a user has already input the data in a past form, a user can simply start filling out the form and it will search the collection allowing the user to select from the list.
In the example below I would like a user to start input into the "Manufacturer" column of the form and start typing "Rau" where it would bring up a list of items, one of them being "Rauland" where they can simply click on that to input the value.
Second example would be in the "Part Description" field where a user could start typing "351" where it would bring up "351000 - R5 Corridor Light" where again a user can simply click on that item.
"Items" function for each of the form fields that I have, which obviously doesn't work.
Filter(LotCodeCollection, StartsWith(Value, Self.SearchText))
I have the submit button setup to add the current values from each desired item to a collection.
I also have a function setup for a couple fields to use a variable, so that it pulls in the same value as the last filled form field.
If(Not IsBlank(Parent.Default), Parent.Default, IsBlank(Parent.Default), Facility, "")
Problems that I am running into
1) If a user "edits" an existing form - The data on the original entry does not appear in the form fields. (Default.Parent)
2) If a user presses "submit" on an existing form, it replaces the data with a "blank" value.
3) If the above happens it inputs a "blank" value into the collection
3) Once a user inserts their own value into the form field, it goes blank because that value doesn't exist in the collection.
22
Share
Report
All responses (
Answers (
