eetimm

Thanks so much for helping me out on this. I really appreciate the community's willingness to assist others!

I am trying to dynamically change the shading on a table column, based on the value of a drop-down, to reflect which column is being sorted by the drop-down. I am able to change the shading with no problem, but am having problems with identifying the index number of the drop-down box. I am attempting to use the following script to get the index number for the drop down and use that to change the shading. <script> function display() { var index = document.getElementById("DROPDOWN_ID").selectedIndex; document.write(index); } </script> My questions are: 1. I know that there are different forms of "document.getElementby" based on what element you are looking for. Is this the correct form? and 2. Based on the Chrome developer tools element inspector, it appears that the dropdown ID is "asorting" (see attached picture). Is this how to find the ID for the control so I can query the index? I suspect that the answer is somewhere between #1 and #2, which ends up with me spinning my wheels. I am just learning to dive deeper into the code and really appreciate any guidance. Thanks, ET

Thanks! I suspected that it would be that easy, but decided to make it a whole complicated thing! I really appreciate your quick response. ET

I have created a gallery report for a company directory. The report presently shows only 2 columns, but I would like to expand the page to display 4 or 5 columns. Searched the forums but cannot find anything related to this. I also cannot find how to make any change to the layout via styles. I suspect that this is easier than I am making it out to be, but I am stuck. Any guidance would be appreciated!

If you use a barcode scanner that can read the barcode, you can dump the scanned data into a field. Essentially, a scanner just interprets the data encoded in the bar code and sends the data to the field (it essentially acts like a keyboard entering in the data). Therefore, if you hook up a scanner, it will scan your barcode into the current field. You will need to make sure that the data is captured correctly...match the field type to the data you are scanning. I don't have a lot of experience with complex barcodes (I have used Code39 and other 2D codes), but as long as your scanner can read the codes, you can capture the data. ET

I will test that out. That might work for me. Thanks for the suggestion!

Thanks for the help. The data in the search_alpha field is text, and I am using a multi-select listbox to create the field, and then using JS to format the field as "8426 OR 7506...". I use this field to create a subset of my overall database by passing the string as a parameter and using "contains" to limit the data. In this particular case, I am hoping to do some calculations (Min, Max, Avg) on the subset. My approach was to see if I could pass the string to the WHERE clause of a SQL Select statement so I can make the calculation only on the values in the subset. Not sure if this is the correct approach. The overall project is an online analysis tool that allows users to select a subset of industry firms and then view some basic metrics. There will be multiple users running the tool at the same time, and each one will be able to save their own subset of the industry for analysis. I appreciate any help!

I am going to document my efforts here just in case anyone else is looking for a similar answer... When I use the "target.[@field:search_alpha] with a single entry in the field (using '8426' rather than the string "'8426' or cert='7506'"), I do get the correct response. So, it appears the issue is calculating the max value from the multiple records I am submitting. It appears that the SQL needs a match of a single data point in the WHERE clause. Any other methods to grab the max value out of a range of values in a calculated field, using another field as the criteria?

I found some info on the use of "target." here https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/. This looks like it is getting closer. I will keep messing with it. Thanks!

Thanks for your response! I appreciate the help. Unfortunately, it did not work. I was not aware of the "target." designation. Can you give me a brief explanation of how that works?

Thanks for your response! I appreciate the help. Unfortunately, it did not work. I was not aware of the "target." designation. Can you give me a brief explanation of how that works?

I am trying to use a SQL query in a calculated field to calculate the max value in a sub-group of data. When I hard code the formula as below, it works fine. SELECT Max(CY_Inc) FROM Pohl_Data_Temp WHERE cert = '8426' OR cert='7506' OR cert='660' OR cert='11681' OR cert='29679' OR cert='9507' What I am trying to do is fill in my where statement dynamically from a field in my database. When I use the following formula, it returns a blank result. SELECT Max(CY_Inc) FROM Pohl_Data_Temp WHERE cert = [@field:search_alpha] Field [search_alpha] = '8426' OR cert='7506' OR cert='660' OR cert='11681' OR cert='29679' OR cert='9507' Field [cert] is a unique ID field Since the hard coded formula works, I believe that I have the syntax correct, leading me to conclude that a SQL Select in a calculated field cannot use a field to provide the conditions for the where statement. I have not used a lot of SQL in calculated fields, so it is possible that I am missing something here. I appreciate any thoughts and insights!

Check your fields for null values...Caspio cannot add values if any of them are null. Try using the form: IsNull([@field:field1],0)+ IsNull([@field:field2],0) + .... + IsNull([@field:fieldx],0) This has worked for me. ET

Aurora...thanks so much for this, it works perfectly. I really appreciate your taking the time to figure this out! Regards, ET

Thanks again for your help. Unfortunately, that did not do the trick. I am suspecting that the problem lies with the use of virtual fields, so I will try this in plain HTML. ET