Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe like this.
I believe you'll need an action per field selection, but you can assign the field names dynamically ('field' is an expression entry box as well as the search string).
Hey Swuehl,
Can you please help more here with example?
In below image, for the selection = BM01-51 , I have the Possible Values in next two List Boxes.
BookmarkFieldName has the list of Fields to be used in Select in Field/Select Possible action.
BookmarkFieldValue has the list of corresponding values to be passed in Search String.
I want to dynamically pass the BookmarkFieldName field names, whenever the Bookmark_ID value is selected.
Hi Try this.
Hope this will help you.
Hi,
This is not possible normal triggers, since you have different number of fields for each bookmark. So you have use the macro with some looping and then select the values based on that. You can find some sample piece of code from
Hi Jagan,
Thank you for the great help here.
I applied the Macro action in the Button, but when I am clicking, only ONE possible value from BookmarkFieldName comes and ONE value is selected from BookmarkFieldValue. Image below:
Where as I need a selection set like this below:
Hi,
Attach sample file and your expected results so that it would be easier to understand and provide the solution.
Regards,
jagan.
HI Jagan,
Attach is the file and the source. Could you please support here?
As far as I understand, you don't want to select values in BookmarkFieldName, but use these values as field names to select in.
For example, you want to get 'Previous Month' used as field name with a selection of 'Active', right?
But your sample data does not show any field named like that...
If you just want something like shown in the second picture of your previous post, this should do:
Hey Swuehl,
Your Macro Solution worked superb! Many Thanks.
And Your Understanding is CORRECT.
////// JOIN & DROP loop to consolidate the Generic tables
FOR i = NoOfTables()-1 to 0 STEP -1
LET vTable=TableName($(i));
IF WildMatch('$(vTable)', 'Generic.*') THEN
LEFT JOIN (BM) LOAD * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
ENDIF
NEXT i