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?
Like this:
IFS(
ISNOTBLANK([Province and MunicipalityCity]),
LOOKUP([_THISROW].[Province and MunicipalityCity], โRetail directoryโ, โProvince and Cityโ, โTDโ)
)
It wonโt avoid the warning message, but it will avoid the pointless LOOKUP() and the associated performance problems.
Note, too, you were missing [_THISROW].
in your LOOKUP() expression.
See also:
Good Day Steve thanks for your help.
Want to ask also with the formula in Province field, I indicated formula on valid if as โLocations[PROVINCE]โ but still sometimes the data on Province is blank. Province In my Form is the source of all the lookups that i made but sometimes it appears as blank on g.sheets even its required on my Form.
This can happen if you have two columns of the table next to each other, each of which uses a table-column reference (like Locations[Province]
). Is there a column before Province? If so, what is its Valid If expression?
Yes i have 3 columns on Table - Locations(Province, City and Barangay) my valid if beside Province is city which is โLocations[CITY]โ. Do i have to separate that 3 columns in to 3 tables?
Youโre running into a magic feature called dependent dropdowns, where AppSheet has tried to guess your intent and adjusted the appโs behavior accordingly. Please review the document linked below. If you donโt want this behavior, let us know and Iโll give you the workaround.
See also:
Hi Steve good day, Thank you so much for your big help. The workaround you are saying is this " Disabling Dependent Dropdowns or is there another way?
As Iโm looking back at the earlier posts, I realize I may not have understood your problem correctly.
How have you indicated that the Province field is required?
Yes i have set the Province field as required but still sometimes there is a blank cell or data on gsheet.
That should not happen. Consider engaging support@appsheet.com so someone there can dig deeper.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |