You’re offline. This is a read only version of the page.
166
Hi, In this picture below is the collection that has column: license_number, and I do not want to show the record has "-" in the gallery.
This is the code that I've tried.
I am looking forward to hearing your feedback and advice
Thank you
Share
ReportForAll(
tbl_hist_insurance,
If(
license_number = "-",
Hidden
);
Collect(
col_insuranceData,
{
SaleCode: SaleCode,
license_number: license_number,
sale_TName: LookUp(
tbl_mas_saleagents,
Title = tbl_hist_insurance[@SaleCode]
).sale_TName,
sale_FName: LookUp(
tbl_mas_saleagents,
Title = tbl_hist_insurance[@SaleCode]
).sale_FName,
sale_LName: LookUp(
tbl_mas_saleagents,
Title = tbl_hist_insurance[@SaleCode]
).sale_LName,
license_name: LookUp(
tbl_mas_license,
licenseCode = tbl_hist_insurance[@licenseCode]
).license_name
}
)
);
Thanks very much for your help! You are a magician.😘
if you mean you want to hide the record has "-" in column license_number.
Maybe you can try this before ForAll function.
All responses (
Answers (
Remove(
tbl_hist_insurance,
First(
Filter(
tbl_hist_insurance,
license_number = "-"
)
)
);
you have to define what it doesn't equal to,
for example:
LookUp(MyColl, Column1.Value = stringA && Column1.Value != stringB)
Yes I'd like to hide the record completely and This is error: Expectation Operator, I'm not sure what's my mistake.
Or if you want to hide the record completely from the gallery,
just specify in the LookUp function that you don't want records that contains "-" in the column license_number..
I'm not sure what your source looks like, but i guess you got the point:
LookUp(
tbl_mas_license,
licenseCode = tbl_hist_insurance[@licenseCode] && tbl_hist_insurance[@licenseCode] != "-")
The easiest way is:
If(license_name = "-", "")
= if licence name = "-", then it's replaced by empty string.
Hope it works!
