Hi everyone may i ask if there’s alternative way to avoid blank data when using LOOKUP and SELECT
I’m with my Form.
With the Field - Province am using formula as Locations[PROVINCE] the locations is from another table.
With the Field - TD Name am using formula as LOOKUP([Province and MunicipalityCity], “Retail directory”, “Province and City”, “TD”) -
When Field Province is blank or no data my TD Name field also dont have data.
What will be the alternative way to avoid the error as: Note, this expression could significantly impact sync time?