Jump to content

emarchewka

Members
  • Content Count

    4
  • Joined

  • Last visited

About emarchewka

  • Rank
    Newbie

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I had a similar issue and did a workaround. Albeit, not perfect, it is functional. I setup an OTP table to capture, email or mobile and then two fields, to auto fill the USERID from members table based on cascading text field in the datapage. There are two more fields, one with a auto gen 8 digit code, and one with a time stamp. This table has a TA to put the code and time stamp in the members table. My authentications then look at the email, password, and code from the members table. I then have 4 tasks that run every hour in 15 min increments. These tasks clear the entries from the OTP table and nulls the code and timestamp in the members table based on the age of the time stamp. I have a datapage that the user fills out before they sign in to generate their code. They can deliver it via EMAIL or SMS. Then they can sign into the app. Hope this helps. Again, not perfect but it works.
  2. Hi @Randy I used one of my expert sessions and they built a really complicated triggered action to move and update the values into another table. Another thing I did was show some of the values in a combined chart and table and then modify the iframe to show only the chart. Thereby hiding the table part. -Edward
  3. Thanks @Vitalikssssss This doesn't fully produce what I am looking for. In order to chart the values I need combined Chart and Table. The table, to be effective, needs to show aggregate values by Reporting Period. There are 7 total values that need be be charted and displayed. With the limitation of 5 aggregation fields in Caspio this causes a problem. Therefore, I am trying to get the values into another table. Cheers!
  4. Been struggling with this for a bit and can only get pieces to work. Before someone says just use aggregation in the reports, that doesn't meet the needs and there are limitations that prevent it from working. Table A: Metric_ID (unique), Company_ID, Reporting_Period, Score, Score_Max, C_Value, C_Value_Max Table B: Summary_ID, Company_ID, Reporting_Period, Score_Sum, Score_Max_Sum, C_Value_Sum, C_Value_Max Sample: Table A: Metric_ID (unique), Company_ID, Reporting_Period, Score, Score_Max, C_Value, C_Value_Max MET1, Acme, 1/1/2018, 3, 3, 2, 3 MET2, Acme, 1/1/2018, 2,3,1,2.5 MET3, Acme, 2/1/2018, 3, 3, 2, 3 MET4, Acme, 2/1/2018, 2, 3, 1,2 Based on this data: Table B should look like this: Table B: Summary_ID, Company_ID, Reporting_Period, Score_Sum, Score_Max_Sum, C_Value_Sum, C_Value_Max SUM1, Acme, 1/1/2018, 5, 6, 3, 5.5 SUM2, Acme, 2/1/18, 5, 6, 3, 5 The logic is, find the metrics for a company, sum the score by date insert into Table B. Repeat for each field, Score_Max, C_Value, C_Value_Max. Also, in the event, MET1 is updated, then SUM1 needs to update. Thanks in advance!
×
×
  • Create New...