Setting the values in a data table using the expression in "AddDataTableColumn" activity

Permanently deleted user

March 29, 2017 19:36

I am attempting to develop a workflow that does the following:

1. User selects accounts on map
2. User completes form
3. Data from account is merged with information from form, such that each account record will include the same form information
4. Report generate that includes account information plus values from form

To achieve this, my workflow does the following:

1. CaptureGeocometry to select accounts
2. Query accounts based on geometry – result is account feature set
3. Display form to allow user to enter general project information
4. Convert feature set to datatable (FeatureSetToDataTable)
5. For each item in form, add a column to the datatable (AddDataTableColumn) and use the expression to set the values to the variable from the form.

What I want is a resulting datatable which includes one record for each account that was selected and every row will have the same value for each column that was populated in the form.  This works great if the value pupulated in the form does not have a space. For example, it will run if one of the values is “1234”, but if I set the value of the variable to “12 3”, it fails.

 

I am I just approaching this the wrong way trying to use the expression in the AddDataTableColumn?

0

• 

  Permanently deleted user

  April 01, 2017 09:55

  Hi Shana,

   

  I didn't go through your issue exactly, what I understand is that you are trying to add a column to a datatable with spaces in the FielName. I think datatable columns should not allowed with spaces, hence you can replace the spaces with underscores.

   

  Regards,

   

  Mohammad Ashraf 

  0
• 

  Permanently deleted user

  April 18, 2017 13:32

  Update: I replaced the expression with this format, which worked perfectly:  string.format("'{0}'", VARIABLE_NAME)

   

   

  0

Please sign in to leave a comment.