Jump to content

Batchini

Caspio Ninja
  • Content Count

    65
  • Joined

  • Last visited

About Batchini

  • Rank
    Advanced Member

Recent Profile Visitors

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

  1. Hi. I need a Formula to combine two fields. Here's the formula that I'm using: CONVERT(VARCHAR, [@field:FieldA]) + ' ' + COVERT(VARCHAR,Year[@field:DateField]). I am trying to write a formula that will pull the year out of the date in this field. I am getting an Invalid Formula. Can you help?
  2. Can you apply localization in a Task? I have a negative value and here's how I want to display it: -$150 instead of ($150) in an email generated by a Task. Currently negative dollar amounts to appear as: ($150) Thanks for the help.
  3. Hi, I am trying to concatenate my two number fields with a string and it is giving me different result. Field A value: 201479652315 Field B value: 201454784878 Here's what I'm trying to do: Field A + Field B + '.docx' And I am getting dis result: 201479652315 2.014547e+4878.docx Here's the formula i am using: CAST([@field:FieldA] as VARCHAR) + CAST([@field:FieldB] as VARCHAR) + '.docx' Can you help?
  4. I need to pass a parameter on the website link but with condition. For example if field1 = a then pass parameter name=[@fieldname] otherwise it will be just the link. I tried Case When statement and use the a href with the link but it is not working if it has a parameter included in the link. Do you have any other ideas for this guys?
  5. I need to pass a parameter on the website link but with condition. For example if field1 = a then pass parameter name=[@fieldname] otherwise it will be just the link. I tried Case When statement and use the a href with the link but it is not working if it has a parameter included in the link. Do you have any other ideas for this guys?
  6. Thank you that worked. Do you also perhaps know How can I insert data from table one to table two when the value of ID is not on table two? Expected Result: send the information from table 1 to table 2 only if the ID on table 1 is not found in table 2?
  7. I need to reduce the space in the filed width of an editable report with attachable images. Here's a screenshot: As you can see there are whitespaces after the word chosen. Can you help me reduce it? Thanks.
  8. How can I create a a task that will update the records on table1 with the information on table 2 when the ID match in both tables? I already have all my records in the table 2that's why I come up with creating a Task instead of a triggered action. Can you help me creating this? Thanks.
  9. Hi @Barbie I tried using your code in a Gallery report and it did not work. I have a somehow same workflow with this but it did not work on my end. Does the code in Gallery report different from tabular report? Thanks.
  10. I have a report with search function. Is it possible to use a one field and be able to search for the value and a blank value as well? I am using a dropdown field and I tried adding 'Blank' in the display and leave the value as blank but it is displaying all the records instead of displaying the blank values only. Can you help?
  11. I want to send an email notification using Application Task and wanted to make the words inside the strong tag in the email body bold and it is not working on the email. It is just displaying the string tag in the email. Here’s a sample Task configuration that I have: Is it possible to make this Task read the HTML Tags? Thanks, B
  12. Hi, I have a datapage that I need to add labels per row but wasn't able to do so inside the Pivot DataPage or the Style. There are some rows which I can't add titles or labels. Can you help me with this?
  13. I have a table with a Student Number and a Student name in two different columns. Is it possible to get the Student Number and Student name in the same column in another table or view? Thanks.
  14. Hi, I am looking to make a cascading text field read-only. the cascading text field in my DataPage is the Virtual 4. How can I achieve this? Thanks.
  15. I have a table that has a multiple duplicated User_ID. Below are my table structure: Username Checkbox1 Checkbox2 Textfield Test Test Test Test2 Test2 Test2 If I check atleast one in Checkbox1 field with a 'Test' Username, all Checkbox2 with a username of 'Test' will be checked and all Textfield with a username of 'Test' will be marked as 'done'. I tried creating atriggered action but I am getting a recursive error. Can you help?
×
×
  • Create New...