Hello FM Gurus, good morning.
Currently, I'm making a solution it's called "Enrollment and Grading System" of a certain school here in our place.
I'm having a problem here with this Checkbox. (Image Below)
As you can see in the image, I checked all the boxes on the checkbox list but unfortunately it will display only the letter "M".
I want the output should look like this "MTWThF".
I really need your help guys. Does anyone here can help with this?
Thanks and God bless!
I am attempting to use the following script in a Database:
Set Variable [$supplierCount; Value: ValueCount ( List ( Suppliers::UUID ) )] Set Variable [$month; Value: MonthName ( Get ( CurrentDate ) )] Set Variable [$suppliers; Value: List ( Suppliers::UUID )] Loop Set Variable [$i; Value: $i+1] Exit Loop If [$i > $supplierCount] New Record/Request Set Field [Month::Month; $month] Set Field [Month::fk_Supplier; GetValue ($suppliers ; $i )] End Loop
When I run it, however, it creates zero New Records within my "Month" database.
I'm not sure what the issue is. My only hunch is that the List function isn't properly creating a List of the "Suppliers::UUID" field, and is causing the ValueCount taken of it to return 0.
Please let me know of any additional information I can provide, and thank you in advance for any assistance you can offer!
Hi, I have a bit of a dilemma that I've tried a number of solutions to sort out, to no avail.
I have a portal that lists the participants in a class. In each row is a checkbox that can be used to indicate whether that participant has withdrawn from the class.
I've used a summary field to count the number of checked boxes and have a field that subtracts that number from the total of records in the portal - easy peasy.
Where it gets tricky is that, one of the fields relates to the number of children associated with a participant (a mum may have 3 kids in the class if it's one of the playgroups). Now I need to know how many kiddies there are in the class. I have a field that totals the number of children in total and that works fine, but...
... and here's my problem -
where a parent has withdrawn (and the box is checked), I need to subtract the number of children associated with that parent from the total number of children).
The checkbox is a value list with a single value, 1.
All the solutions I've tried so far are fine unless it pertains to portal rows - and I can't figure it out for the life of me.
Can anyone help me out?
I want to create a Dropdown List of numeric options to select a range of records. For example, the Dropdown list would contain:
Each option would select the next 5;10;20;50 or 100 records to the right. A Checkbox would be populated (with an X) in the selected number of contiguous records; Then, a Find Selected Checkboxes would return the selected records. The contiguous selection should be independent of whatever the current state of Found (Sorted/Unsorted) is.
Any help will be gratefully acknowledged.
I have a Value List "Quarter" with values:
I planned to loop through these values and assign to a field using the various posts in the forum, but in testing the basic steps it's not working:
Set Variable [$i; Value: 1]
Set Variable [$quarters; Value: ValueListItems (Get (FileName); "Quarter")
Set Variable [$count; ValueCount ($quarters)]
Set Field [Program::ProgramQuarter; GetValue ($quarters; $i)]
The field ProgramQuarter is not being set to any value....