LinkedIn
Twitter
Iโm not sure @Bellave_Jayaram , I think this would cause issue
Things like this
have trouble some times. Your syntax looks solid.
[Email] is the Key, right?
Thanks for all your suggestions. So some feed back for @MultiTech_Visions @Bellave_Jayaram and @Steve
ANY(Select([Related Peoples][PeopleID],[Label]=[_ThisRow].[Training Contact]))
Using Matts suggestion of changing of changing [Email] to the key column [PeopleID] does not change the issue. But it does prove that this formula always returns the first value it finds in [Related Peoples][PeopleID] if [Training Contact] is blank
ANY(Select([Related Peoples][PeopleID],[Related Peoples][Label]=[_ThisRow].[Training Contact]))
Jays suggestion does not work because [Related Peoples][Label] is a list
ANY(Select([Related Peoples][PeopleID],[_ThisRow].[Training Contact]=[Label]))
Steves suggestion works fine. I think Iโm a shocked about this as Matt is.
@praveen this is not a complaint, more of an โobservationโ
As someoneโs whoโs programming expertise does not extend beyond Appsheet, I think Iโm well placed to make this comment. In order for Appsheet to be available to the masses, its important to remove any barriers. Having little quirks like this in Appsheet could stop a new user in their tracks. As a user with almost 3 years of experience of Appsheet, I understand how good the platform is and will diligently find a workaround or ask in this community. But there is the risk that someone who is new will try Appsheet, hit an issue like this and โbounceโ to a different platform.
I think the shortcut solution is simply to make people aware of any usual behaviour. In a former career I ran an IT support company who used some ticketing software called Connectwise. Which on the whole was very good. But now and again I tie myself in knots for hours trying to get some part of it working, usually because figures or time was not adding up correctly. What they do is to host user group meetings (https://www.connectwise.com/theitnation/share/agenda) at least twice per year in each location. The key thing I found out from these meetings was what didnโt work as expected so I didnโt have to waste time myself. Incidentally Praveen, Iโm still open for a discussion to do something similar if your interested?
A short term solution would simply be to make users aware if this bugs in the help.appsheet.com files and also in a known bugs section of this community.
But a long term view should be to fix these quirks and make everything much more intuitive. Steveโs listed his pet peeve, here are mine:
1 = A virtual column showing a different result in a form view vs a detail view. I know this is because these are calculated via 2 separate bits of code. And they are calculated at different times. But I once spent a week on one formula because I had to take into account the order in which where calculated and which items were VCโs
2 = Having to specify 2 as 2.00000 in the code so that the result doesnโt get any random rounding. Surely if we set the column to 5 decimal places the backend code could simply change 2 to 2.00000 as a short term fix?
3 = Iโm based in the UK. So for me, date is DDMMYYYY. If I put <<[Date]>> in a report I get DDMMYYY. But if I do <<CONCATENATE([Date])>> I get MMDDYYYY. To rectify this I have to do <<CONCATENATE(TEXT([Date]))>>
Hope this helps 
@Steve it was just and example. You could do CONCATENATE(โfoo โ,[Date],โ barโ) and the issue is the same 
Just today, another little quirkโฆ
I have a workflow with a start condition that wasnโt working. With this formula in a Virtual Column, it is an empty list:
Select(Booking[BookingID],AND(
[People].[Company]=[_ThisRow].[CompanyID],
[Valid Until]<=Today(),
ISBLANK([Superseded]),
ISNOTBLANK([Qualification Code])
))
Yet if I wrap it in ISNOTBLANK() and use it as a start condition for a workflow or report, it triggers
If change it to COUNT()>=1 then it does not trigger (the expected behaviour)
