Creator : Stateless form as a search parameter - using result in Page panel
Hi,
I have a stateless form containing a single lookup to a list of portfolios. I've put this form on a Page containing a lot of panels that will sum the results from a form where it matches certain criteria - how can I add the ID chosen in the stateless dropdown to the panel filter ?
- <panel>
- <pr width='fill' height='fill'>
- <pc padding='0px' bgColor='#FFFFFF' width='100%' hAlign='center' vAlign='middle'>
- <pr width='fill' height='fill'>
- <pc paddingTop='17px' paddingLeft='17px' paddingRight='0px' paddingBottom='17px' bgColor='transparent' width='50%' hAlign='center'>
- <pr width='auto' height='auto'>
- <pc>
- <text color='#333333' size='20px' uppercase='false' underline='false' bold='false' italic='false' type='Text' value='Group Carbon (Last report) - Scope 1'> </text>
- </pc>
- </pr>
- </pc>
- <pc padding='20px' bgColor='transparent' width='50%' hAlign='center' vAlign='middle'>
- <pr width='auto' height='auto'>
- <pc>
- <text color='#DA242A' size='24px' uppercase='false' underline='false' bold='true' italic='false' type='Form Data' displayType='actual' decimalPlaces='2' thousandsSeperator='LOCALE' decimalSeperator='DOT' numberScale='none' criteria='Added_User == zoho.loginuser && emission_source.scope_field == "Scope 1" && end_date in last 447 days' value='thisapp.carbon.carbon_emitted.sum'> </text>
- </pc>
- </pr>
- </pc>
- </pr>
- </pc>
- </pr>
- </panel>
So the panel value is currently returning a sum of selected values where :
Added_User==zoho.loginuser && emission_source.scope_field=="Scope 1" && end_date in last 447 days
how do I add :
&& portfolio.portfolio_ID==[The ID result of the stateless lookup here]