Only Display Entries From Survey123 By Rolling Date Range (weekly)

[GregReinecke]

Hello All,

Weekly I collect a respondents First and Last Name and the Date Created (hidden) for an event. The SignUp opens On Sunday and closes Thursday at noon).  Currently I clear the survey data every Saturday night and reset the Survey123 date range opening and closing for the coming week.

I really don't mind that I delete the data but also wouldn't mind keeping the data for later analysis BUT no matter what I just only want to see the current weeks data.

Currently I show the results in a table widget in Experience Builder.  Here is the survey link https://arcg.is/8T4q  and I have attached a simple .xlsx form.

I think this could be done a few ways supporting "IF an entry falls within the upcoming week THEN display it ELSE don't display it" 

1. Arcade expression in ArcGIS to create a field that adheres to the criteria
2. Some sort of expression in ExB
3. A calculated field in Survey123
4. ModelBuilder script

Any suggestions or kickstarts would be very helpful. Thanks in advance,

GR

[GregReinecke]

I started getting some code together. I have two features, one from a previous week and one from this week.

The feature last week generates a boolean "false" which makes sense based on the signup date.

The second point has a signup date of yesterday which I would think would prove out to be "true" but it doesn't.

Perhaps it could be due to the way the date is formatted.  Here is the code if anyone wants a look.

var now = Now();
var timeZoneOffsetHours = -5; // Eastern Time is UTC-5

// Adjust the current date and time to Eastern Time
var easternNow = DateAdd(now, timeZoneOffsetHours, "hour");

// Get the current day of the week and hour
var dayOfWeek = Weekday(easternNow);
var currentHour = Hour(easternNow);

// Define the time range for Sunday midnight to Thursday noon
var isWithinTimeRange = (dayOfWeek == 1 && currentHour >= 0) || // Sunday midnight
                       (dayOfWeek >= 2 && dayOfWeek <= 4); // Monday to Thursday
var isBeforeNoon = (dayOfWeek < 4) || (dayOfWeek == 4 && currentHour < 12); // Before Thursday noon

// Check if the feature's "_date_time" is within the specified time range
var featureCreationDate = $feature._date_time;
var isFeatureCreatedThisWeek = DateDiff(Week(easternNow), featureCreationDate, "day") >= 0;

return isWithinTimeRange && isBeforeNoon && isFeatureCreatedThisWeek;

[GregReinecke]

Still searching….     Is it possible Now() and 

featureCreationDate

 actually have a different output format/structure so they always compare as false?  Thanks to all in advance. 

[GregReinecke · Accepted solution]

This does what I want.

// This Arcade Expression assigns an attribute "Show" or "Hide" to a feature 
// based on the day and time it was created. Also assigns "Hide" if not created
//during the current week.

// Get the current week for comparison to previous weeks
var currentDate = Now();
var currentWeek = Week(currentDate);

// Get the day of the week the feature was created
var dayOfWeek = Weekday($feature._date_time);
var dayOfWeekString = "";
if (dayOfWeek == 0) {dayOfWeekString = "Sunday"} 
    else if (dayOfWeek == 1) {dayOfWeekString = "Monday"}
    else if (dayOfWeek == 2) {dayOfWeekString = "Tuesday"} 
    else if (dayOfWeek == 3) {dayOfWeekString = "Wednesday"} 
    else if (dayOfWeek == 4) {dayOfWeekString = "Thursday"} 
    else if (dayOfWeek == 5) {dayOfWeekString = "Friday"} 
    else  "Saturday"

// Get the time of day (_hour) the feature was created
var dateTimeField = $feature._date_time;
var _hour = Hour(dateTimeField);

// Get the time of day (_minute) the feature was created
var dateTimeField = $feature._date_time;
var _minute = Text(Minute(dateTimeField), '00');

// Create _hour_minute
var _hour_minute = _hour + _minute

// Get the week the feature was created
var _week = Week($feature._date_time)

if (dayOfWeek == 0 && _week == currentWeek) {return 'Show'}
    else if (dayOfWeek == 1 && _week == currentWeek) {return 'Show'}
    else if (dayOfWeek == 2 && _week == currentWeek) {return 'Show'}
    else if (dayOfWeek == 3 && _week == currentWeek) {return 'Show'}
    else if (dayOfWeek == 4 && _hour_minute <= 1200 && _week == currentWeek) {return 'Show'}  
    else return 'Hide'