Setting Null Value based on other Cell [Hosted Feature Layer]

McMP268 — Tue, 18 Jun 2024 12:40:59 GMT

Hi,

Summary:
Looking to reset a specific table cell to Null as it's currently showing as Blank (due to deleting previous data within that cell)

Context:
Working with a ArcGIS Online Hosted Feature Layer, which is being updated by Surveys.
I've made a dashboard to display the results, however when I ran a test on two of the surveys that update fields I filled out a response which skewed the pie charts based on Responses.

Initially the data was showing as below (example):

CompanyID	RespondentA	ResponseA	RespondentB	ResponseB
ABC123	TestUser	Accept	TestUser	Accept
ABC234	TestUser	Reject	TestUser	Reject
ABC345	User1	Accept	User2	Accept
ABC456	User1	Reject	User2	Reject
ABC567	<null>	<null>	<null>	<null>
ABC678	<null>	<null>	<null>	<null>

Where ABC123 and ABC234 were the test data. With the pie chart showing 2 Accept, 2 Reject and 2 Null values per Response (A or B)

However, having deleted the data from the fields for ABC123 and ABC234 the table now looks like:

CompanyID	RespondentA	ResponseA	RespondentB	ResponseB
ABC123
ABC234
ABC345	User1	Accept	User2	Accept
ABC456	User1	Reject	User2	Reject
ABC567	<null>	<null>	<null>	<null>
ABC678	<null>	<null>	<null>	<null>

This now displays as 2 Blank, 1 Accept, 1 Reject and 2 Null on the pie chart.

Is there a way to reset the specific Respondent A/B or Response A/B cells to <null> by CompanyID, specifically for ABC123 or ABC234 without resetting all cells in the Respondent A/B or Response A/B columns?

e.g. Where CompanyID is ABC123 set ResponseA is None (<null>)

Thanks in advance.

Re: Setting Null Value based on other Cell [Hosted Feature Layer]

McMP268 — Tue, 25 Jun 2024 15:48:57 GMT

Found solution, within the Feature Layer data table.

Just needed to add a full stop/period "." to the blank cell. then delete the full stop, then cell reverted to <null>

topic Re: Setting Null Value based on other Cell [Hosted Feature Layer] in ArcGIS Online Questions

Setting Null Value based on other Cell [Hosted Feature Layer]

Re: Setting Null Value based on other Cell [Hosted Feature Layer]