Inline view without virtual column

[Raaj_Agrawal]

Hello,

I have an attendance table and an advances table. I have another table to prepare salary. Now in salary table I want to show advances I gave to that specific employee whose data will be in advances table. I know this can be done using VC (Ref_rows). But my app is already containing much formula’s and I don’t want to add any more load on processor. So kindly No VC’S. Is it possible to show some rows data from advances table in salary table just like an inline view without using VC?

Thanks

[AleksiAlkio]

You can avoid VCs with an action.. using LINKTOFILTEREDVIEW(). The difference is very small.. are you scrolling the detail view, or pressing an action/icon.

[Raaj_Agrawal · Accepted solution]

@AleksiAlkio Hello.

i am trying to show the data rows from another table in detail view as well as in form. So are you suggesting i create an action with LINKTOFILTEREDVIEW() and attach it to a column inline where i am trying to show the data. And when user clicks it, he will be able to see those filtered rows... Good idea... 

But apart from this, is it possible to show data in table format inside detail view or form view without VC so that user doesnt have to click the action inline and may get idea of the table shown along with rest of the data in detail or form view?

Thanks!

[AleksiAlkio]

#1 - The action approach doesn't work with the form view as you can't trigger an action from that view type. You can show them after the form view is closed with the Event action , if it helps.
#2 - You can show the data with a Show/Text column on a form view, but though it's not the same than Inline view with rows. Without VC, it's not possible to show Inline views.

[Raaj_Agrawal]

@AleksiAlkio Thank you so much. Sometimes, the solution so simple skips our mind. I tried using linktofilteredview() and it serves my purpose for now. Thank you so much buddy.. 🙂

[AleksiAlkio]

Good to hear!