Forum Discussion

Lucian's avatar
Lucian
Responsive Resident
5 years ago
Solved

How to pass column name as parameter into a function

Hello, I need some help understanding how to pass a column name as parameter into a custom function.   I have a table (Accounts) from which I need a specific column (No) using a function that will...
Need Help
  • Lucian's avatar
    Lucian
    5 years ago

    After some more digging, I find the answer => Record.Field(_,srcColumn).

    So, changing the following line from:

     

    fx(strStartWith, srcColumn) and fx(srcColumn, strEndWith)

     

    to

     

    fx(strStartWith, Record.Field(_,srcColumn)) and fx(Record.Field(_,srcColumn), strEndWith)

     

    Will  make the code work.

    Kind Regards,

    Lucian

Lucian's avatar
Lucian
Responsive Resident
5 years ago

After some more digging, I find the answer => Record.Field(_,srcColumn).

So, changing the following line from:

 

fx(strStartWith, srcColumn) and fx(srcColumn, strEndWith)

 

to

 

fx(strStartWith, Record.Field(_,srcColumn)) and fx(Record.Field(_,srcColumn), strEndWith)

 

Will  make the code work.

Kind Regards,

Lucian

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks, this solved a problem for me 🙂