iFormBuilder Smart Table Search Updates!

Follow

Permanently deleted user

March 19, 2019 14:16

Hey Zerion Community,

We are currently researching ways to upgrade our Smart Table Search Functionality. We are correcting and fixing current Smart Table Search Issues that are outlined on this community post which includes support for multi-select elements and fixes some current deficiencies in the functionality.

We are researching adding a new element designed for a Smarter Smart Table Search/Database Lookup. This functionality may include the following:

- New Element

- Visualize Multiple Columns in a table format in the lookup instead of a single column

- Ability to Filter the table based upon Javascript

- Fuzzy Search inside the table to 

 

The Device Functionality would look very similar to this screenshot below:

• When selecting the new element you would be brought to the screen on the right-hand side and see a list of columns and rows to select.
• Tap on a row you wish to select and the element will close and return details about that row.

This functionality now allows Group to View Multiple Columns in their lookup table whether it be for referencing previous data or for lookup purposes.

Within the FormBuilder this could be configured like this:

• Table Name - Select which table you would like to use
• Displayed Columns - Choose which columns you would like to display in you view when looking up information.
• Returned Columns - Choose which columns you would like returned for looking up into other fields.
• Filter Grammar - Enter your javascript filters to filter the list.

Please provide any feedback and suggestions below on how you could see this feature used or any features and functionality you would like.

Cheers!

-Ben

 

2

• 

  Rebekah Stevens March 19, 2019 17:28

  This sounds great! It will resolve a lot of the current limitations that we run into when using Smart Tables. Looking forward to seeing it in action!

  1

  Comment actions Permalink
• 

  Adam Rawlinson March 19, 2019 21:30

  Hi Ben,

  This seems good. A few considerations:

  1. Could I pass a parameter from an element in my form, into the filter? For example, I have selected a 'Material' of "Copper" and only want to retrieve rows from the smart table search where the material in the other table is "Copper". 

  2. Can we pass date ranges into the smart table filters? Could I ask to only retrieve rows with an inspection date of the current month, for example?

  The new functionality would be very useful, but I think it would be far more powerful if the filters are dynamic.It would enable implementers to be more creative in their designs. 

  Thanks,

  Adam

  0

  Comment actions Permalink
• 

  Jonathan Hsu March 19, 2019 21:32

  Adam,

  We're planning on allowing the filters to be dynamic so that it can be based off of another field like you described. The date example is a good one for us to keep in mind.

  Thanks for the feedback!

  Jonathan

  0

  Comment actions Permalink
• 

  Permanently deleted user May 06, 2019 14:27

  Hey Everyone,

  We have started on the development of how this new element will be configured within the FormBuilder. Take a look below to see what attributes users will have available to configure.

  

  0

  Comment actions Permalink
• 

  Permanently deleted user June 07, 2019 12:54

  Hey Folks, The New Lookup element will be available for Beta Testing here next week. In the meantime take a look at this video on how this works.

  NEW LOOKUP ELEMENT SNEAK PEEK

  Thanks,

  -Ben

  0

  Comment actions Permalink

Please sign in to leave a comment.