Jump to content

KAPITYAN

Caspio Ninja
  • Content Count

    39
  • Joined

  • Last visited

  • Days Won

    1

KAPITYAN last won the day on August 18 2019

KAPITYAN had the most liked content!

About KAPITYAN

  • Rank
    Advanced Member

Recent Profile Visitors

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

  1. I have two text fields in my table, one for date an other one for time. Is it possible to create a formula field within my table to create a datetime result?
  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.
  3. 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.
  4. 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
  5. 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 gi
  6. I have a formula field in one of my tables that calculates the difference between to date/time fields. I want the results to display as dd:hh:mm. Here is my formula as it is currently. Any suggestions would be appreciated. CASE WHEN [@field:TimeAssigned] Is Null THEN '' ELSE Datediff(minute, [@field:Time], [@field:TimeAssigned]) END
  7. 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).
  8. Thank you, @NailDyanC. I need to translate this into a Caspio 'Task' or Triggered Action. Would it be possible to show an example in that format for me to use as a guide?
  9. I want to concatenate values even if the first or second is blank. In such a way that there are no left over spaces if one is null. So I am trying to combine FirstName1 + LastName1 + FirstName2 + LastName2, and if Name 1 is blank, I prefer not to have any leading spaces in my result. Is it possible?
  10. 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.
  11. 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.
  12. 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.
  13. 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.
  14. 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?
  15. 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.
×
×
  • Create New...