Select in Field Action - Can we pass multiple Field Names and Values?

[dmohanty]

Hi All,

Can we pass multiple Field Names and their respective Field values in a Single 'Select in Field' or 'Select Possible' action of a Button?

This is a requirement I need, so that if I click on an APPLY Button, those Fields and Values get selected. But I don't want to hard-code those values in Action; those has to be passed dynamically.

[swuehl · Accepted solution]

Maybe like this.

[dmohanty]

Thank you Swuehl,

This works wonder... Got the concept! Many thanks again.   Marking this thread as correct.

By any means can you help here in dropping all the Generic Tables after the Join????

[dmohanty]

Hi Jagan,

Many thanks to you for the help here in Macro. swuehl has helped here in achieving the desired results.

Also, you are free to take the latest attached app and play around for some alternatives and ideas.

I have used a Generic Load concept to convert all the Field Values to Columns/Fields. Now I also have a script to Join them and Drop the tables, but that's taking a lot of time and RAM.

Any suggestions please?

[jagan]

Hi Mohanty,

It takes time if you have huge data, what swuehl  has given is the correct one.

Regards,

Jagan.

[dmohanty]

Hi swuehl‌ and jagan‌,

I just came back to this post for some more help here -

• When I launch the app in AJAX mode in Access Point or simply Turn On the Web View, and then Click on the Button, it does not work. Probably the Macro is not working in AJAX.
• Any possible/futher help here please?

Regards!!

[jagan]

Most of the macros won't work in Ajax mode. Try using the Select In Field triggers for this.

Regards,

Jagan.

[dmohanty]

Hi jagan,

Thanks. I was thinking of the same to try.

Could you please show me a sample? Do I need to remove all that Macro?

[dmohanty]

Hey jagan‌ and swuehl‌,

This has worked in the Access Point from AJAX mode perfectly.

Here wanted one quick suggestions please -

Is it possible for change this VBScript code to JScript somehow?