KAPITYAN

I have a field in the table that contains records that has '55' in the beginning. I want to have a calculation that once that record has a '55' at the beginning, I want to add '0000' before it. Like for example: Record 1 has a value of 55556789 then I want the result to be 000055556789. Can you help me with this?

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?

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.

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.

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

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]).

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

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).

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?

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?

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.

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.

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.

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.

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?