Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by IamBlossom

  1. I use a Date field which is a Text(255) to be the column of my Pivot table(it contains month of the year). When I preview the DataPage, the column is sorted alphabetically. How can I display the column to be ordered by month correctly?
  2. I would like to have a formula field that will check if the File Field is blank or not. Below is the formula. It validates, however, it does not work as expected. CASE WHEN [@field:Images] IS NULL THEN 'No image attached' ELSE 'Image available' END I used this format in other field like Text(255) and I am getting the expected output. I am wondering why it does not work in File DataType. Can you please help me? Thanks in advance!
  3. I have this formula that pulls up the record associated by ID, then display in a single line. SELECT CAST(Name AS nvarchar) + N', ' FROM PE_USER_TABLE PE_ID = target.[@field:PE_ID] for xml path(N'') The result is Marco, Mary, Marie, How can I remove the last comma "," ? Thanks!
  4. I have a Text(255) field which is set to Cascading Dropdown. I would like to use Formula field as Field for value, however, I cannot pull up any Formula fields from the available options. Is this a default behavior? Thanks in advance!
  5. IamBlossom

    Auto Search

    I would like to hide the search button then automatically filter the reports page based on the value selected in the search fields. Do you have any idea on how to do that? Thanks!
  6. Payment Integration is not available in my account. However, I saw a code on how to implement this feature. I put this in an HTML Block and tried it in Header/Footer as well, but both seems not working. Is it possible to use such code like this to have Payment Integration? <form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_top"> <input type="hidden" name="cmd" value="_s-xclick"> <input type="hidden" name="hosted_button_id" value="8Q8JUB3GQE8YW"> <input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_paynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!"> <img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1"> </form> Thank you for helping.
  7. Hi @NailDyanC, Thank you for your response. I have two tables, Student_Record and Student_Info. Both tables are linked together. Student_Record contains Payment field. Per Student_ID, I want to sum all the payments that particular student made. If greater than 0, then the Status should be Active, else Inactive. Here is my formula: CASE WHEN (SELECT SUM(Payment) FROM Student_Record WHERE Student_ID = target.[@field:Student_ID] > 0 THEN 'Active' ELSE 'Inactive' END I have this in my calculated field. I want to use Status as my filtering criteria but it seems that it is not allowed. Thanks.
  8. Hi @kristina, I got the same issue. Adding another field to the table and use formula will do. But, in formula field, Select function is not allowed. Is there another workflow for this? Thanks.
  • Create New...