Jump to content

BeffreyJezos

Members
  • Posts

    13
  • Joined

  • Last visited

Posts posted by BeffreyJezos

  1. Let me try this and hopefully it works for me.

    On 10/9/2021 at 4:40 PM, Tubby said:

    You can use javascript to get the copy the value of the first date field's criteria and pass it to the other fields then hide them so it would show only the first date field with 2 criteria (start and end).

    There is quite a lot of steps to follow here but it worked for me.

    First, add two Criteria to all of them. One for Start Date, another for End Date.

    Configure one criteria as “Greater than or Equal” and the other as “Less Than or Equal” to include all Dates within the selected range. This goes for every single one of the date fields.

    Afterwards, hide all of the Date Fields except for the first Date field using what I call the "HTML block method". Like this:
    image.png.6f8492477437c8fba6e97daf64b3b5dc.png


    Just use the same code I used on HTML Block 1 then put </div></div> to HTML Block 2. This creates a separate section for those fields and hides them.

    Next, add a Header and Footer block and put the script below in the Footer. Dont forget to disable HTML editor:

    <script>
    document.addEventListener('input', function drange() {
    document.getElementById('Value3_1').value = document.getElementById('Value1_1').value;
    document.getElementById('Value3_2').value = document.getElementById('Value1_2').value;
    document.getElementById('Value4_1').value = document.getElementById('Value1_1').value;
    document.getElementById('Value4_2').value = document.getElementById('Value1_2').value;
    });
    </script>

    But note that this is assuming that the Date fields are positioned at the very top of the DataPage Wizard. The ID 'Value3_1' can change depending on the position. A good way to check is to remove the codes in the HTML blocks to unhide the fields first and inspect the element using F12. 

    Lastly, go to the Logic section and set the Logic to be multiple AND blocks inside a big OR blocks like this:
    image.png.78365d2732a48c92049e9323dcdad88e.png

    This basically copies and pastes the dates in the first date fields to the others pass them secretly.

     

  2. I have read about adding criteria to my search field if I want to use a range for filtering or searching. However, my problem is I need to check multiple date fields and adding criteria to all of them will make my search form so messy and contain a lot of fields. Is there a way to use just two date pickers to select the start date and end date and select all records that has any of my date fields inside that range?

    Any suggestion is appreciated. Thanks!

  3. I have a simple table that contains the results from survey and I want to make a chart datapage from it for a presentation.  The problem I am having is that I can seem to plot the values in a chart. 

    image.png.fc8fb8d0016a08158dd1a2bafc34dd87.png

    This is what the table looks like. I know it isn't numerical values but I cant seem to find a way in the datapage wizard to use formulas. I plan on visualizing the popularity of each options (a,b, or c) for each question. 

    Any ideas is welcome. Thanks.

  4. I want to use one of the formula fields in my table as a search field for my tabular report page. I can include it to the search fields but when I changed its form element to any cascading element, it wouldn't allow me to use it for the "Field for value". It isn't available in the options to select from.

    I also tried using a Virtual field and same thing happened. The formula field is just a concatenation of 2 text(255) fields. I don't want both of those fields in the table since two columns takes a lot of space.

    Any ideas how to do this?

  5. I have a number of scheduled exports that failed due to "Connection Failure". The problem was on our end but I was wondering if those will still be counted as Datahub calls and will be deducted to my account?

    Anyone knows if it does?

    TIA.
    -Hexy

  6. Hi

    I have built a simple order tracking app and I want to send email notification to the users every time the status is changed. The problem is that I have multiple status for the orders.

    image.png.54add7c3aa07ee6a109de5b2f495d023.png

    Here is a sample of my table records. As you can see, I have "Placed" ,"Picked up" , and "Delivered" status. I have a couple more but the idea is that for each of these status, I want a different email message or content sent to the email address of the user.

    Currently, I am only using acknowledgement emails so the users will receive an email upon placing an order. Is there a way to do this? Thanks in advance.

    ~Hexy

  7. Hi  everyone,

    I am looking for this everywhere and I can't seem to find an article about this. Does anyone know what criteria (like uppercase, lowercase...) are used for the several password strengths that Caspio has by default as shown below?
    image.png.a275d6c683433c130d791af8bb293fb2.png

    I just wanted to know if there are available resources about this so I can document it or make my users aware of the requirements.

    Any help is appreciated.

    Thanks ~
    - Hexy

  8. Sorry for replying late @Tubby.

    I have tested both of this. They both work perfectly for Calculated Values! Thanks!

    I went with the '<br>' as I am most familiar with it and because I think CHAR(13) only works with calculated values and not formula fields. I am not sure if this is expected since formula fields and calculated values looks and works very similarly.

    Anyways, thanks for the help.

    Hexy

  9. Hi everyone.  I was  wondering if there is a way to put line breaks in  calculated values? Like I can concatenate strings without problem but I want the next field under my first field instead of just a space in the middle.

    Example:
    Field1
    Field2

    What I have now is: Field1 Field2

    I cant use <br> or press the Enter key. It does not do anything. I cant find it in Localizations either. Anyone has a workaround for this?

    Thanks,
    Hexy

×
×
  • Create New...