Jump to content

gillyr7

Members
  • Posts

    10
  • Joined

  • Last visited

Everything posted by gillyr7

  1. @FaeFaeFae This is great. Thank you so much. One more related question... There might be a case where it is not the last two columns. Is there a way to add a conditional component to it? Like Below? If #Columns = 6 then color column 5 and color column 6 if #Columns = 5 then color column 5
  2. Hello, I have a working JS solution for my chart that shows my first 4 columns one color (default for my style), my 5th a new color, and my 6th another color. My JS is below. My issue is that while most of the time the chart will show all 6 columns, there are a few instances where less than 6 will show. In that case I need to adjust the colors based on how many there are. Basically, the last two columns should be the different colors than the original columns. Again, the solution works well if there are 6 columns like usual, but sometimes there might only be 4 columns. In that case, the first 2 columns should be my default color, while the 3rd and 4th should be the different colors. Any idea on how to make the code below conditional on how many columns there are? <style> rect.highcharts-point.highcharts-color-0:nth-child(5) { fill: #ffb32b; } rect.highcharts-point.highcharts-color-0:nth-child(6) { fill: #13B5EA; } </style>
  3. I would not say there is a straightforward answer to this question, as there is such a variety of things you can do, with or without custom coding through Caspio. Now to try and answer, I would say back-end SQL developers would probably make a good fit, just because a major component of Caspio, is building the data structure. That being said, you could get by creating apps in Caspio without writing any SQL at all. You would really just want someone who is really good with database structure, and knows how to put the complete picture together. In my experience, someone can pick up creating the front end datapages very quickly in Caspio, but the back-end databases are where it is important to really know what you are doing. The skills you listed (SQL, JS, and HTML) are all good to have. I've seen some pretty good Caspio developers who were really good Excel Modelers. If you want one person to handle everything, than all of those skills would be very beneficial, if you are only looking for someone to handle the databases, then a standard DBA would probably make a good fit. For your API question, we actually just use Zapier, and Integromat to work with 3rd party apps instead of writing out the API because it is much easier.
  4. Hello, I have a triggered action that works, however it is so slow and clunky, and sometimes it times out. I am wondering if anyone can suggest a fix to make it faster or more efficient. It takes 15-20 minutes just to open this thing to edit it... Attached is a screenshot of one block of the triggered action. This block is repeated about 400 times (one for each field. If you notice, the first field is: X2A1, and the second is X2A2 at the start of the second block on the bottom of the picture. Again, this is repeated for 400 fields. The way it works is detailed below... My GL Import table is a table which I will call tall (top to bottom). Here is a quick sample of the data for GL Import ClientID ProviderID PeriodID Field Value 1 1 1 X2A1 500 1 1 1 X2A1 1000 1 1 1 X2A2 1200 The balance sheet is wide (left to right) with each field displaying as one field left to right (the GL import table has all of the fields as labels in the row. Below is a sample layout of the Balance Sheet Table ClientID ProviderID PeriodID X2A1 X2A2 X2A3 1 1 1 Running this triggered action updates the balance sheet so it would look like this: ClientID ProviderID PeriodID X2A1 X2A2 X2A3 1 1 1 1500 1200 0 The triggered action sums the values for each label in the field in the GL Import table, and takes that summed amount, and moves it to the correct field in the Balance Sheet table. Does anyone have any ideas on how to make this more efficient?
  5. Why not just use the various Caspio Report datapages and deploy them to a site? You could build almost any .NET reports using the Caspio charts, tabular, or pivot table datapages. If you still need a different solution, you could use the Caspio API, but I really think you should explore the Caspio reports first.
  6. Hello, I have a Display Only Field that I am looking to hide if my Virtual2 field = 'Yes'. The rules do not allow to hide a display only field, and I cannot put it in its own section because I have necessary fields to the left and right of this display only field. Any ideas?
  7. Hello, I was wondering if it was possible to create a flag to alert the user if they enter data, but try to leave before hitting the Update button. I have multiple Details Datapages deployed on my website, and the user could theoretically navigate between pages, or exit out of the browser without pressing the update button. Is it possible to alert them to save if they entered data but did not hit the button before moving pages?
  8. Greetings, I have a script that works well to have a custom menu with 'Update' buttons. This means that any time they press one of the menu buttons, the data entry on the Details Datapage saves. Again this works great, but now I am looking for a way to have the current page show a different color than the rest of them. Does anyone know how to do this? My current script has one style for each button, but I am not sure how to get it so the current page is a different color. Below is my current script. <style type="text/css"> .cbUpdateButton{ background-color: #12b5ea; height: 75px !important; color: white; padding: 10px 7px; font-size: 12px; border-style: solid; border-width: 1.5px; cursor: pointer; font-family: helvetica, arial, sans serif; background: linear-gradient( #12b5ea, #12b5ea); border-radius: 5px; } .dropbtn:hover{ background-color: #006792; height: 75px !important; color: white; padding: 10px 7px; font-size: 12px; border-style: solid; border-width: 1.5px; cursor: pointer; font-family: helvetica, arial, sans serif; background: linear-gradient( #006792, #006792); border-radius: 5px; } </style> <table border="0" cellpadding="0" cellspacing="0" style="width: 100%;"> <tbody> <tr> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/gl-import'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">GL Import</button></div> </td> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/balance-sheet'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">Balance Sheet</button></div> </td> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/revenue'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">Revenue</button></div> </td> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/expenses-cost'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">Expenses &ndash; Cost of Goods Sold</button></div> </td> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/expenses-admin'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">Expenses General &amp; Administrative</button></div> </td> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/services-provided'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">Services Provided &amp; Patients Served</button></div> </td> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/accounts-receivable'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">Accounts Receivable &amp; Claims</button></div> </td> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/medicare-billing-benchmarks'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">Medicare Billing Benchmarks</button></div> </td> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/referrals-and-admissions'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">Referrals &amp; Admissions</button></div> </td> <td> <div class="dropdown" style="float:left;"><button class="cbUpdateButton" id="Mod0EditRecord" name="Mod0EditRecord" onclick="window.location.href='https://www.simione.com/data-analytics-portal/financial-monitor/quarterly-intake/referrals-and-admissions'" onmouseout="cbButtonHover(this,'cbUpdateButton');" onmouseover="cbButtonHover(this,'cbUpdateButton_hover');" type="submit">PDGM Statistics</button></div> </td> </tr> </tbody> </table>
  9. Please see my datapage: https://c1abv844.caspio.com/dp/91cf700006bdcab2be14446c8bce Is it possible to have a separate parameter for the chart than the tabular report in a combined chart and report? What I am trying to do, is only show the 'Total' category on the chart. This is the value in the series all the way on the right side of the chart. This is an actual value in the data, and not an aggregated field. I get I could do this using two datapages and just pass another parameter to the chart, but I was hoping not to waste another datapage just to accomplish this. Any ideas on if this is possible?
  10. Hello, It looks like your datapage is no longer deployed so I cannot see anything... You should be able to show these values on the chart if you create a calculated field in the tabular report with what you need. Based on what it looks like, you might need to use SQL in your calculated field to get the 3/5 year averages. When you get to your chart, you can select the new calculated field in the chart.
×
×
  • Create New...