Iโve created a valid_if statement for a column. Based on the values input into that column, I want my ref_row to filter the results prior to syncing. Is this possible?
Solved! Go to Solution.
Sorry, Iโm dumb, I didnโt see the computed name was the label and something elseโฆ
IFS("None"<>[AffilateCode], FILTER("Affiliates", [_THISROW].[AffiliateCode]=[AffiliateCode]))
@Bahbus, are these the details you were referring to?
โLeadsโ[Customer]
โCustomerโ[EmployeeID]
โCustomerโ[AffiliateKey]
For that CustomerKey column, try a Valid If of [AffiliateKey].[Related Customers]
Iโve figured it out, sort ofโฆ I used the example you provided with the ENUM with a base as REF and VALID_IF, but it doesnโt auto select the option. Is there a way to do that. Iโve tried using Initial Value and App Formula, but I get errors.
What, if anything, did happen when tried [AffiliateKey].[Related Customers]?
Unfortunately, no . This does not provide the desired results.
Nothing happened. the Expression I used was [Related Leads][AffiliateKey] as we needed to pull the AffilateKey used in the Leads table and not the Customer. The initial Form starts from the Leads table & not the customer.
When I use initial Value as stated in some of the community forums, I get this error.
Column Name โEmployeeIDโ in Schema โCustomers_Schemaโ of Column Type โEnumโ has an invalid โInitial Valueโ of โ=[Related Leads][EmployeeID]โ. The type of the Initial Value does not match the column type. Consider using โโ instead.
It say consider using " which confuses me.
I believe the error is because that method brings over your information in List form. Try:
INDEX([Related Leads][EmployeeID],1)
Once again, youโre a genius! Thank you so much! I you!
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |