I have completed the bubble training lessons and have also gone through the documentation, however I am finding it difficult to implement a search feature.
So, I have a Customer data type with fields: Mobile_number, Name and email
I need the user to enter his mobile_number and search. When the search button is clicked, I want to search from the database and load all the fields as input fields if an entry is found. If there is no entry for that mobile_number in the database, the user will continue to enterthe rest of the details like Mobile_number, Name and email in the same input fields and click on “Update” button, so a new entry is created in the database.
In the search button workflow, I am using Display Data to search the database and load the results. But I am finding it hard to load the search result fields into the corresponding input fields.
Most of the examples shown in the forum and the training lessons are to do with Repeating groups. But I dont think I need to use a repeating group here as the search result will have only one entry (mobile_number is unique/primary key).
What’s the best and most efficient way to implement this ?
Appreciate if anyone can help me out here.