Tag Archives: fulcrumapp

In a recent app (form) I wanted to be able to quickly see the last time I had visited a site. This form had the usual Parent/Child setup with a repeatable section that noted information every time I visited the site. Having the ‘last visited date’ on the parent side of the form meant that when I mapped the data in QGIS I could quickly create a categorised thematic by this date to see which sites might need a visit.

Here is the setup

  • App with a repeatable section called ‘observations’
  • Date field on the repeatable section for observation date  – observation_date
  • Calculated field on the ‘Parent’ (non repeatable) side of the app with the following expression

var dates = REPEATABLEVALUES($observations,’observation_date’);
var maxDate;

if (dates && dates.length > 0) {
maxDate = dates[0];

dates.forEach(function(currentDate) {
if (currentDate > maxDate) {
maxDate = currentDate;
}
});

maxDate;
}

If you have a fulcrum account and you would like an example of this, drop me a line via phil@… and I will share an app with you

Fulcrumapp – Support and helpdesk

I have been using Fulcrumapp for some time now helping out various not-for-profit organisations and unfortunately they have turned off their old public forum which I used to find quite useful for seeing how other users solved problems.

They now have a online one on one system so you cant see what everyone has been working on. All that past knowledge and learning, which I found quite useful, is no longer available.

They do have sites with code examples (Help, Expressions, data events) but for folks with no coding experience they get a bit geeky fairly quickly.

I have decided that when I have some success with an issue I will post it online here for all to see – hopefully someone will find it useful. In most cases these now come from the one on on one interactions I have with Fulcrum staff but I will try and make the notes as user friendly for non techie folks.