Latest Contributions by WilsonLee

‎10-04-2023

Thanks Jeffery, this workaround works!!! 😊

‎10-03-2023

Hello, In a web map, there's a layer which i have a filter set to hide all records (polygons) and in experience builder, i want to set up a filter widget and allow user to select records with a query, but the filter widget didn't work, because that layer in web map has a filter to filter out all records. In Web App Builder, the Filter widget has a setting to uncheck "Append any expression to existing map filter. (ie, remove the existing filter in the web map) How can I do this in Experience Builder? please help and thanks a lot!!! Wilson

‎09-05-2023

THANKS again! it works!!

‎09-05-2023

Thanks Justin!!! let me try to update my codes🙏

‎09-05-2023

in Field Maps Arcade Expression, how can I differentiate between "selecting an existing point" and "adding a new point" within an Arcade expression. I'm trying to apply a different code based on the action selected by a user (SELECT vs ADD) from a same layer. currently, i have setup 2 layers in field maps for "Updating" and "adding a new point", but would like to combine them and make it more convenient for user. thanks, Wilson

‎08-21-2023

Hi, i'm trying to create a custom expression in a popup in web map for a mailto function. the mailto function is working fine in the web app (created in web app builder) but i would like to add a bold red color to a field in the email body: var recipient = 123@gmail.com var subject = "test email" var body = "Location: " + $feature["LOCATION"] + TextFormatting.NewLine + "Phone: " + $feature["phone_number"] var mailtolink = Concatenate(mailto:, recipient, "?subject=", URLEncode(subject), "&body=", URLEncode(body)); return mailtolink ----------> when a user click the mailto link in a popup. i would like the email body looks like this in outlook: Location: California Phone: 123-555-8888 how can i insert the color and bold text properties? I have tried <br> html code in the expression but it didn't work : ( thanks!! W

‎07-27-2023

it works!!! thanks a lot!!!!! 🙏

‎07-27-2023

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

‎07-25-2023

Thanks Johannes, for some reason it didn't work I had simplified the code for this post....the actual codes are like this For first 3 lines, i am able to get the value from other layer (point in polygon) - ie, GRID_ID but adding 4,5,6 break the code: 1. var treeGrid = FeatureSetByName($map,"Grid") 2. var result = Intersects($feature, treeGrid) 3. var GRID_ID = Upper(first(result).MAP_ID) 4. var GridFilter = Filter($featureset, "MAP_CODE = @GRID_ID") 5. Var NEWID = Max(GridFilter, "SEQ") + 1 6. return NEWID did i do something wrong? thanks!!!

‎07-25-2023

Hi, in the Field Maps form, I'm trying to calculator a new ID value based on a selected grid and the MAX value (+1) in the layer. How can I apply the filter in the expression correctly? Var GRID_ID_SELECT = AA Var GridFilter = Filter($featureset, ‘GRID_ID = GRID_ID_SELECT') Var NEW_ID = Max($feature.ID) + 1 return NEW_ID Grid_ID ID AA 1 AA 2 AA 3 BB 11 BB 12 BB 13 Thew NEW ID value should be 4. (I'm new to Arcade and trying to figure this out, i have read some samples but didn't achieve my goal) million thanks!!! W

‎07-25-2023

thanks Doug! i got the idea, thanks for your help

‎07-24-2023

Hi, I am creating a form for a layer. In 1 field, I want to get get a value from another layer (with joined table, it's map service published from a ArcGIS Server) in a same web map. var treeGrid = FeatureSetByName($map,"GROUNDS.SEQ") var result = Intersects($feature, treeGrid) return Upper(first(result)."GROUNDS.TI2_MAX_SEQ.SEQ") Test execution error: Unexpected text literal.. Verify test data. (It was fine if i am getting a value from another layer without joined table) Does Field Maps support accessing values from a layer with joined table in Arcade? is my code correct for this? thanks a lot!!! W

‎01-31-2022

Hi all, i have a layer PIPE and there's a relate inspection table (relationship class) in our geodatabase. In the layer, there's a field called "Material", in the relate table (inspection table) , there a field called "old material" when we add an inspection in the relate table, is it possible to auto-calculate based on the PIPE layer feature attribute? i tried to setup an express using arcade. but looks like it didnt work. any ideas? thanks, Wilson

‎09-09-2021

Hi, I have resized the popup using Web AppBuilder Developer Edition ( this.map.infoWindow.resize(600,600); in mapmanger.js) . the popup is cut off if i click a point that is located near the edge of the map area, Is there anyway that i can make the popup show up or auto shift to the center of the map area ? thanks!!! Wilson

‎03-28-2020

thanks, but i'm looking for the actual SQL Definition in the "Create New View" Tool , see my screenshot but thanks anyway

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by WilsonLee

Re: how can i reset a filtered layer in web map when i setup new filter widget in experience builder?

how can i reset a filtered layer in web map when i setup new filter widget in experience builder?

Re: is there an expression to differentiate SELECT vs ADD in arcade expression?

Re: is there an expression to differentiate SELECT vs ADD in arcade expression?

is there an expression to differentiate SELECT vs ADD in arcade expression?

custom expression in a popup in web map for a mailto function

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

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

Re: How to apply query in arcade and caluculate a new ID value?

How to apply query in arcade and caluculate a new ID value?

Re: Get a value from a layer (with joined table) in a web map

Get a value from a layer (with joined table) in a web map

calculate attribute value based on relate feature

Popup auto relocate or shift in the center of the map

Re: Create a VIEW (PIVOT) in Enterprise Geodatase

Re: how can i change a custom icon within the Widg...

Relate Table - unable to edit and missing in the p...

Re: Relate Table - unable to edit and missing in t...

Re: is there an expression to differentiate SELECT...

Re: Get a value from a layer (with joined table) i...