How do i pull out the information from another table for the condition? for example, i want to display a column โcomplaintโ in table details only if the column โstatus of callโ in another table is set to โTroubleshootโ
Do you want to hide value or values in a table view and differently row by row?
yes sir
Iโm afraid you are not able to do that with a table view. If you need that functionality, you should create a virtual column and then show that column in your table view instead of your original column. You can achieve this with the app formula, not with the Show? option. App formula would be likeโฆ
IFS(LOOKUP(โSearchValueโ,โAnotherTableNameโ,โSearchColumnโ,โStatus of callโ)=โTroubleshootโ,[OriginalColumnname])
User | Count |
---|---|
33 | |
25 | |
22 | |
21 | |
15 |