NickL

Hi @futurist thank you so much responding to this post. this is working out great for me. am i able to replace my chart with this? just like how is showing on the picture above. i want to be able to see this above my reporting. can this be done using the Combined Chart and Report?

We just recently moved from Google to Caspio. I'm trying to find a way to recreate the same reporting we used in google and the report was created by an outside source. Right now, we are using a bar chart. I would like to do something similar to our previous reports.

Hi @CoopperBackpack, I'm getting this response Invalid formula: Subqueries are not allowed in this context. Only scalar expressions are allowed. using this Formula SELECT Collection_Unit_Charges FROM Collection_units WHERE Collection_Unit = target.[@field:Collection_Unit]

Hello @CoopperBackpack, Thank you so much for your response. I do have a Chart and Report where all the Datas are sent to. this is my submission form. Friendly Fresh Hertz/Dollar/Thrifty (caspio.com) The "Collection Unit Charges" field is not part of the submission form.

Hi, I've been working on this for a while now trying to figure this out. Please see photos below. I hopefully this will help give a little visual of what I'm trying to accomplish. Photo 1 is my table and photo #2 is my submission form. Here is what i need help with. I want to setup an automation where if I select any of the option from the submission form, and based on what i select the price will be added to an empty cell under my "Collection Unit Charges" in my Table. so far i've been manually adding the numbers in my table under Collection Unit Charges. If i select from my submission form option 1 "Smoking collectable $400 I want then 400 to be added to my table under "Collection Unit Charges" again i've been adding these manually so far.