Latest Contributions by ChrisRoberts2

‎02-23-2023

The Info Summary widget and lack thereof in EB is a showstopper for us to move a number of web apps over. For example: Code Amendment Map Viewer (geohub.sa.gov.au)

‎12-05-2022

I actually think I managed to work it out myself 🙂 var fs = FeatureSetByPortalItem(Portal('https://xxxxx'), 'a81b87605d0346599ea5cffbebab66e6', 0, ["*"], false); // load data // flatten the table var flat_dict = { fields: [ {name: "Species", type: "esriFieldTypeString"}, {name: "Obs", type: "esriFieldTypeInteger"}, {name: "Obs_date", type: "esriFieldTypeDate"}, ], features: [{attributes: {Obs_date: Number(`obs_date`)}}], geometryType: "" } var max_species_number = 7 for(var f in fs) { for(var i = 1; i <= max_species_number; i++) { var new_f = {attributes: {Obs_date: Number(f[`obs_date`]), Species: f[`Species${i}`], Obs: f[`Species${i}Obs`]}} Push(flat_dict.features, new_f) } } var flat_fs = Featureset(Text(flat_dict)) // group by species and return return GroupBy(flat_fs, ["Species", "obs_date"], [{name: "Obs", expression: "Obs", statistic: "SUM"}])

‎12-05-2022

Hi Johannes I hate to push my luck because you have been super helpful.....but is it possible to further group/split by Observation Date {obs_date}

‎12-04-2022

Awesome! Thanks so much!!

‎12-01-2022

Thanks for the prompt response Johannes The code you gave me just seems to take a table of data. What I need to do is interegate the dataset in the portal, combine all the species and sum the observation

‎11-30-2022

Hi All I'm sure this can be done but I'm new to data expressions and just cant seem to get started. I have a dataset that has fields Species1, Species1Obs, Species2, Species2Obs, Species3, Species3Obs and so on The species are defined via a dropdown list so what I want to do is to be able to sum the total number of observations per species across all fields. For example the data table might look something like this: Site Species1 Species1Obs Species2 Species2Obs Species3 Species3Obs Little Swamp Red Kangaroo 5 Wallaby 3 Eastern Grey 10 Big Swamp Fox 5 Red Kangaroo 10 Eastern Grey 5 What I want is to use a data expression so I can transform the data to use indicator(s) eg: Species Total Red Kangaroo 15 Wallaby 3 Fox 5 Eastern Grey 15 It seems like it would be possible in a data expression, I just need some help with a starting point. Cheers, Chris

‎10-13-2022

Hi @LisaDong Can you elaborate further is there something we need to add to our Portal settings to allow the export? Cheers, Chris

‎09-01-2022

Just started seeing the same issue myself. A form that was saving fine yesterday is getting errors this morning. Yet if I hit save a second time it saves without errors.

‎09-01-2022

Hi All I have recently change my forms to generate the list from csv's hosted in my Portal using select_one_from_file. This is really useful as I can keep lists updated/maintained without having to get the user to download the form again each time a list is updated. My question is currently I have a note stating 'Taxonomic lookup lists current as of May 2022' which I previously manually updated each time I updated the list. Would it be possible to grab the updated date from the csv so that the date is automatically calculated? Cheers, Chris

‎08-31-2022

Thanks Ruth Things look OK now Cheers

‎08-16-2022

Thanks for this, its got me part way there 😊. However I noticed that it changes the order of the fields, is there a way to display it as per the schema order?

‎08-11-2022

Thanks Ruth! This workaroud has fixed the issue for now. Cheers

‎08-10-2022

Hi All There is something strange happening with the date picker when viewing Survey123 forms as a WebForm. When you select the date picker, the date is correct, but the day is two days in advance. For example todays date is Thursday 11th August 2022, yet the date picker calender is showing the date as Saturday 11th August 2022. This is happening with any form published to our enterprise portal, either created in Connect or the Web Form designer. The example below is just a simple date to show whats happening. The first example is the published view and the second is the preview which displayed ok. The survey123 app is showing the date as expected, its just happening on the web form. Plus go forward or back a month and the day and date display correctly, but August still remains off by two days Does anyne have any idea whats happening here? This seems to be a relatively new occurance, I cant recall this happening before August 2022 Published form previewed form

‎08-09-2022

A simple if else statement should work in the Mailing Address calculation column ie if(${IsMailingAddess} ='Yes', ${address}, "")

‎07-18-2022

Hi Robert Have you found a soultion for this?

Online Status	Offline
Date Last Visited	‎04-11-2024 03:31 PM

My Ideas

Latest Contributions by ChrisRoberts2

Re: Info Summary in Experience Builder?

Re: Combine and sum fields in data expression

Re: Combine and sum fields in data expression

Re: Combine and sum fields in data expression

Re: Combine and sum fields in data expression

Combine and sum fields in data expression

Re: Unable to Export CSV Files Using an Embedded Web AppBuilder in Experience Builder

Re: Error converting XLSForm [Errno 2]

Get date from csv

Re: Weird behaviour from date picker in web form

Re: Can i eliminate empty values using arcade in my pop up?

Re: Weird behaviour from date picker in web form

Weird behaviour from date picker in web form

Re: Survey123 calculation ?

Re: Thumbnails no longer show up in Dashboard

Re: Combine and sum fields in data expression

Use Button to filter list

Hide form from app ... Webform only

Re: Survey123 with Collector: set geotrace

504 Error with survey with Multiple Repeats