l am developing a small app, where i need to count number of entries / selection a user does for Enum list in a column Named: “Application ID” while entering the values in a form.
i tried to use the following expression:
count([_thisrow].[Application ID]) , However i couldn’t get the count.
Issue -2 :
i have created a column "Allotted Time " type “duration” & i wanted to divide the value entered in this row with Number of counted entries in column “ID” which is pure number. However it is not going through.
Issue 3 :
i have a different forms BBF1,2,3 Etc. & a particular duration for each form in "Standard Manhours " column for that activity as below
Thank you @LeventK
Issue 1 :
Thank you for the expression. i tried to use the following expression :
“Application ID”, “Application ID”
but the result is not satisfactory. it is giving Zero as answer.
Purpose is to count number of items i select in Enumlist of “Application ID” column.
issue 2 :
i have two columns :
column 1 : Standard Manhours - Type : Duration in minutes
column 2 : Count from Enum list above - Type : Number
to do : divide column 1 by column 2
issue : the resultant type is not accepting as “Duration”
Issue 3 :
i have different tables :
Table 1 - Contains list of forms & standard Manhours against each forms
Table - 2 : contain the actual form in which this standard manhour is one column
required : need to bring the standard Manhour listed in Table 1 in to table 2 using reference and a valid if data validity function.
issue : it is displaying all values as appear in standard Manhours column irrespective of what is the form being used.
the Standard manhours is fixed for every form & when we open that form , the related standard manhours shall be displayed.
I have changed the Key column to Row Number & used the suggested formula.
However i was struck with App formula.
the app shall compute number of Application ID’s selected in the Enumlist using the formula which i placed in Virtual Column called " Count no.of Trainees "& use it to divide the Duration derived from “Standard Manhours” column.
Can you post a screenshot from your Application ID column details? I have tested and it’s quite good working actually so there might be something missing. Can you also elaborate what do you mean with:
please have a look at the column screen shot.
when i select the different Application ID’s from Enumlist , the column “Count no.of Trainees” shall count the selected lists in real time before saving.
this Counted number in turn would be used to divide the Standard Duration of work to get per group duration.
i have tried with both methods suggested by you & Leventk.
but the result is showing still “1” for any number of selections in the enumlist , values separated by “;”
i have used this row because it has to count only the selection from the current entry & not from entire column in table.
Hope i am clear in explaining.
Thank you for your support. looking forward for resolution.
Thank you for your support. I have shared the app as co author.
issues at hand :
counting the number of Application ID’s selected by user in the present form / present row ( Application ID is Enumlist which was referenced from other table called “form”)
Divide the Time duration with the count obtained from this ( count was done in a virtual column) - i did some expression. it is giving some result in the form of decimal. as i couldnt get the result from the count , i have introduced another column - [No.of Trainees] to enter the detail Manually & use this for dividing the duration.( but iw ant this to be from count function.
i use this [Allotted time] value to compare with total time taken for the activity & decide whether the candidate is with in time or exceeded Column 18. Here i face a issue of comparing duration with Decimal. any insight in this area?
i face another issue - based on the form i use , the standard Manhours shall be populated automatically, but presently it is giving all available items in the list for manual selection.
i tried to generate Names of the Trainees based on their Application ID’s in another column called [_Computedname] , i was not able to get names in Enumlist reference from table =form