Jump to content

Leigh

Members
  • Posts

    6
  • Joined

  • Last visited

Recent Profile Visitors

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

Leigh's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. I have resolved this by putting the code in an HTML block: <script> if ("[@field:Primary_Client]" == "Yes") { document.write("<a href='https://c3afw034.caspio.com/dp.asp?AppKey=appkeyhere&Household_ID=[@field:Household_ID]'>Pantry</a>"); } else { document.write(" "); } </script>
  2. Hello, I have very little Java experience and am relatively new to Caspio. I have read through all the postings on this forum and have tried as much as I can. My problem is this: I need to display a link on a line of a tabular report results page based on the value of a field in the line. Description: The line consists of information about members in a family. The family can have any number of members. One of the members is the primary member and that is indicated by a value of 'Yes' in a checkbox stored in the database. I want only the primary member to have the link to the pantry page and the other member lines to just display a blank space. This is to prevent pantry items being added for all the members when there can be only one pantry item per day for the group. I would like to see: John Smith Yes link_to_pantry Jane Smith No blank Jimmy Smith No blank Is this even possible? Thank you for any help you can provide. I am really stuck. Leigh Additional Info: I have tried the following in a calculated field, but can't get it to display a link: CASE WHEN [@field:Primary_Client] = 1 THEN '<a href="https://c3afw034.caspio.com/dp.asp?AppKey=a2dc40005863d83f783a4981a28b&GBurg_Household_ID=[@field:GBurg_Household_ID]">Pantry</a>' WHEN [@field:Primary_Client] = 0 THEN ' ' ELSE 'OKAY' END It displays the link code for the correct entry, but doesn't just display Pantry with a line under it.
  3. Thank you VERY much. This works perfectly!!
  4. I need to be able to pass a calculated field from a tabular report datapage to a submit datapage thru a link. The calculated field is 'Age'. it is calculated using the following: SELECT CAST(DATEDIFF(YEAR,'[@field:Date_Of_Birth]',GETDATE()) AS VARCHAR(10)) + ',' + CAST(DATEDIFF(MONTH,'[@field:Date_Of_Birth]',GETDATE())-(DATEDIFF(YEAR,'[@field:Date_Of_BIrth]',GETDATE())*12) AS VARCHAR(10)) AS Age I am passing other fields from the report to the submit page, but can't figure out how to pass the calculated field. Thank you! Leigh
  5. Thank you VERY much. This is exactly what I was looking for!
  6. I would like to calculate age as years and months and display the result in a field in tabular report. I can already display just the age in years, or just the age in months in fields, but I don't want to see 438 months as a persons age as an example. I want to display both together as years,months. How can I do this? Thanks
×
×
  • Create New...