is it possible to get a value from a table based on an entered value in the SAME form?

WilsonLee

Hello all,

I have a Field Maps form and have 2 fields. 

Field 1: Tree Species Code (SPECIESCOD)

Field 2: Botanical Name (BOTANICAL)

in a same form, after the user enter Field 1 (Species Code), can Field 2 (Botanical name) auto-populate based on a table in the same webmap?

 

SPC_CODE	BOTANICAL
ABBR	Abies bracteata
ABCI	Abies cilicica
ABCO	Abies concolor
ABGR	Abies grandis
ABPI	Abies pinsapo

 

Field 1: user enter ABBR

Field 2: will go to the table and look up ABBR , then the form will auto-populate "Abies bracteata"

(the table is a standalone table in the web map, and it's not join or relate w/ the layer with the form in Field Maps. I saw many sample with using relate table in arcade, how about a standalone table, is it possible? any tips or sample on setting it up in Arcade?

i have this in Arcade, but it gave me an error:

var SpeciesCode = $feature.SPECIESCOD

var table = FeatureSetByName($map, "TI2_DEV - SP_CODE_LOOKUP")

var botanicalName

var filteredTable = Filter(table, "SPECIESCOD = @SPC_CODE")

var result = First(filteredTable)

if (result) {

  botanicalName = result.BOTANICAL

}

return botanicalName

thanks so much!!

W

RhettZufelt

This seems to be working.  Stand alone table, but, added to the map.

 

var SpeciesCode = $feature.Species
var table = FeatureSetByName($map, "TreeTable",['SPC_CODE', 'BOTANICAL'])
var filteredTable = Filter(table, "SPC_CODE = @SpeciesCode")
var result = First(filteredTable)
if(!IsEmpty(result)){
  return result.BOTANICAL
}

 

May have to adjust the field names.

R_