View record generic link Formula (HTML) ‘<a href=”/app/accounting/transactions/transaction.nl?id=’||{internalid}||’” target=”_blank”>View Record</a>’ Multi associated transaction into one column using nsconcat &replace Formula (HTML) REPLACE( ns_concat( DISTINCT( CASE WHEN {applyingtransaction.type} = ‘Wave’THEN ‘WAVE #’ || {applyingtransaction.number} || ‘—><b>’ || {applyingtransaction.status} || ‘</b>’ END ) ), ‘,’, ‘,’ )
Tag: search form
Discrepancy in Field Level Search Results
In a custom record, it has an item sublist (another custom record added as a child). When users try to search the item by using the field-level search option in the admin role it fetches all active items by default but when using a custom role it brings both active and inactive items.Checked the field… Continue reading Discrepancy in Field Level Search Results