Jump to content

KAPITYAN

Caspio Ninja
  • Posts

    39
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by KAPITYAN

  1. We have a few column names with yes/no data type. I want to have a formula that will put the persons name in the accountable column if name is marked true.

    Here's the formula:
    CASE WHEN [@field:Stack] = 'TRUE' THEN 'Stack'
    WHEN [@field:Lucy]= 'TRUE' THEN 'Lucy'
    WHEN [@field:Lucy]= 'TRUE' AND [@field:Stack] = 'TRUE' THEN 'Stack , Lucy'
    WHEN [@field:Lucy]= 'TRUE' AND[@field:Stack] = 'TRUE' AND [@field:Edward] = 'TRUE' AND [@field:Sebby] = 'TRUE' AND[@field:Maria] = 'TRUE' THEN 'Account manager'
    END

    If 2 names are marked true it only gives me 1 name in the accountable column. What I really want is a formula to put the column names in that field if true I don't want to list every type of combination that could be There are 6 names that can be marked true so there can be a lot more combinations.

  2. We have a few column names with yes/no data type. I want to have a formula that will put the persons name in the accountable column if name is marked true.

    Here's the formula:
    CASE WHEN [@field:Stack] = 'TRUE' THEN 'Stack'
    WHEN [@field:Lucy]= 'TRUE' THEN 'Lucy'
    WHEN [@field:Lucy]= 'TRUE' AND [@field:Stack] = 'TRUE' THEN 'Stack , Lucy'
    WHEN [@field:Lucy]= 'TRUE' AND[@field:Stack] = 'TRUE' AND [@field:Edward] = 'TRUE' AND [@field:Sebby] = 'TRUE' AND[@field:Maria] = 'TRUE' THEN 'Account manager'
    END

    If 2 names are marked true it only gives me 1 name in the accountable column. What I really want is a formula to put the column names in that field if true I don't want to list every type of combination that could be There are 6 names that can be marked true so there can be a lot more combinations.

  3. I'm trying to concatenate a couple of number fields into a text field with a comma in between and it keeps rounding the numbers off at 4 digits past the decimal. How can I get it to show the full numbers?

    Here is the formula that I am using:
    CONVERT(VARCHAR, [@field:Num1Address]) + ',' + CONVERT(VARCHAR, [@field:Num2Address])

    Both fields are Number Data type. 

    Result should be:
    23.901365999999,54.95645


    But the result that I am getting is:
    23.9014,54.9564

  4. I am receiving an invalid formula error on the following:
    CASE WHEN [@field:END_Pickup] IS NOT NULL THEN [@field:Carrier_Date] + Try_Convert(datetime, [@field:END_Pickup])ELSE 'END Not Provided'END

    Carrier_Date is a date/time datatype and END Pickup is a number datatype. But the value of the Carrier_Date field upon record update form element is a TimeStamp.

    My current workflow:
    When the Carrier User submits the record, they fill out how many minutes they are from the pick-up site. Upon submit there is a Timestamp. For the Company user, when they view the record, I am trying to give the estimated ETA END. So the timestamp + the number of minutes.

    The sample result should be:
    2/21/2020 11:39 AM

    The time of 11:24([@field:Carrier_Date]) + the Value of the minutes 15([@field:END_Pickup]).

  5. How can I hide the Search Form section of a Tabular report, without hiding the Table report itself?


    I tried this out in my own html file:

    <style>
    #caspioform {
    display: none;
    }
    </style>


    But it hides the whole datapage. I need to hide only the Search Form section. And I need to do it only in my .html file, not the datapage ( I mean I can't do this on the footer o header).

  6. Hi, I have a submission form datapage with a virtual field that has its value set while on the page and a text field. I want the value of the virtual field to set the default value of the editable text field. Can I do this?

    For example:
    In the first 2 dropdowns, pick the first option available, I want to set Name to the value of Virtual8 'Recommended Name' after you select from the first 2 dropdowns, 'Recommended name' (Virtual8) is valued. I want 'Working Checklist Name' (Name) to then be valued with what is in Virtual8. 


     

    image.png.e6e856d66c033d31c4a5a3f141521893.png

  7. I have a one to many relationship but I only want to see the most recent event in my report. I am using a calculated field SELECT TOP 1 ContactID FROM Contacts WHERE ContactID = target.[@field:ContactID] ORDER BY CallDate but I get all the results not the most recent.

    For example, I have a table Contacts with one person and table calls with. But I only want to see the when the last call was made. I want to display only the recent record/s.

  8. I have a radio button that uses custom values. I need to select one of the options as the default but the tick to do so is not working. Can you please advise what I'm doing wrong?

    Like for example, I have the options "Any, Yes and No" and I want to make the option "Any" as the default one. The "tick" to do so normally shows in green but it is currently black/gray and won't set the default. By the way, removing and reinserting has not changed.

  9. I have a date field that loads today's date and time in the search and results Tabular report, which then does not allow the event name dropdown field to show any options. The date field is the parent field for event name field's cascading dropdown. I want only the current date to auto-populate in the field without the time. Also, be able to have them choose another date. I want the field to be a parent field in the cascading dropdown.

  10. How can I format the Name in a reverse order by displaying first the first name instead of Last Name. My table has client' last name and first name in the same field, listed with last name first, with a comma, ie, Balot, Kevin. I want to reverse the name, keep them in one field, but put first names first, with no comma, ie, Kevin Balot

    Is there a way to do that automatically so I don't have to make the changes manually?
     

  11. I have a problem with the text area field using Inline Add. Once we click add another new line character in the text area field, it seems that when we used it in email notification(both Details and Submission forms) it ignores the next line structure and just continue its character spacing.

    Example:

    It should be like this:
    "This is a test item for new line character.
    New sentence begin here start of the second line."

    Not like this:
    "This is a test item for new line character. New sentence begin here start of the second line"

    It should break into another line.

  12. I have a form that when I print the HTML blocks they extend to far across the page and is not readable is there a way to set the margins?  Once I click print preview, the right side of the page is broken and cut off.  I want to show the whole scale or the whole page.  

    Please let me know how to fix this.

     

  13. I want a create web datapage with cascading dropdownlist.
    I have create 2 table.
    1-state 2.student.
    1.state table are 3 field. 1-Id(auto number) 2.State name(text) 3.(district name)
    2.student table are 3 same field. 1.(auto number) 2 state name 3.district name.


    All I want is a cascading dropdown list which under the state.

  14. Thanks for all your responses.  I have also an idea to add a feedback form on my DataPage, I can easily use a submission form for that. but I want to use something like a pop-up instead of displayed, so it could look more user-friendly. How can I do that?

×
×
  • Create New...