Desire to use a model field as the conditional value. Is this possible?
Irvin Waldman, Champion
-
9,026 Points
Posted 5 years ago
Pat Vachon, Champion
-
44,396 Points
Irvin Waldman, Champion
-
9,026 Points
-
2,468 Points
Rob Hatch, Official Rep
-
44,828 Points
Our condition value fields do not current process merge templates (except in the case of Reference field filter conditions). So.. no.. this would not work.
Sorry.
It is a cool idea though.
Sorry.
It is a cool idea though.
Rob Hatch, Official Rep
-
44,828 Points
Peter - you should be able to do rendering conditions based on specific number of rows in a model.
Peter Bender, Champion
-
6,296 Points
Yup, but I need to be able to render if the number of attendance records for today (count of records in a child model) < the number of enrolled students (a value in a field on a parent record). Would love to hear an alternative solution, though.
Rob Hatch, Official Rep
-
44,828 Points
Ok, this solution is ugly. Add two more fields to your parent object. One is rollup summary of current days attendance records and Two is formula evaluating Current Day's Attendance against Total Enrolled studants. I think this can be a boolean field.
Then do your conditional rendering based on Field Two.
Then do your conditional rendering based on Field Two.
Peter Bender, Champion
-
6,296 Points
Unfortunately, you cannot do rollups in Salesforce based on dynamic criteria, such as "TODAY()", so I can't get the number of child records for current date. That's actually why I was hoping Skuid could do that because I also need my page to be more flexible then that, able to navigate to any date and see whether there might be missing child records for that date.
Rob Hatch, Official Rep
-
44,828 Points
I think you'll need to go to Javascript. You know... The dark side...
You can use filters to limit attendance data to one day. Then you have model.length. You can compare that to the total enrollment number from another model. Use that comparison to present an appropriate message, render a component, etc.
You can use filters to limit attendance data to one day. Then you have model.length. You can compare that to the total enrollment number from another model. Use that comparison to present an appropriate message, render a component, etc.
Irvin Waldman, Champion
-
9,026 Points
-
1,252 Points
Hi Irwin,
I ran into the same issue in a similar scenario. The situation however allowed me to compare the current row to a URL parameter I set, which is an option even for Render Conditions. It might not help in your case, but thought I'd mention it here since this is could be relevant for another project.
Regards,
Robin
I ran into the same issue in a similar scenario. The situation however allowed me to compare the current row to a URL parameter I set, which is an option even for Render Conditions. It might not help in your case, but thought I'd mention it here since this is could be relevant for another project.
Regards,
Robin
Irvin Waldman, Champion
-
9,026 Points
Thanks for the suggestion.
Jack Sanford, Champion
-
9,714 Points