Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by alanhoffman

  1. Thanks Vicki. I've found a way using Integromat. Whilst not ideal, it works at least. Preference would be that this was a part of the offering of Caspio (as is the case with Knack). Cheers..
  2. Using Stripe as a payment processor, Stripe his a description field. It is possible with other systems (eg Knack) to populate this field with an item from the transaction (eg transaction invoice number). I(s it possible to do this with Caspio? It is very difficult t reconcile the Stripe account without capturing an identifier from the Caspio system
  3. Thanks for this.. Yep - familiar with Zapier and Integromat. However, I know Knack has this as a direct feature so was hoping Caspio would do do the same. Cheers.
  4. Regarding using Stripe as a payment processor, I understand how to store information in Caspio that is generated by Stripe. However, is there a way to pass information into Stripe eg pass an invoice number FROM Caspio TO Stripe so that when you look at transactions within the Stripe system, you can see that reference number. Cheers..
  5. Hi. I have a tabular datapage that produces a report that shows 4-5 columns showing name, town etc. - and each row is for a different "Member_ID". One of the columns is a calculated field ("Entry_Count") that uses the Select function to count the records in another table for each Member_ID. I would like this report to hide any row where the count is zero. Any suggestions would be greatly appreciated... Perhaps there is some coding for this (I assume to be placed in the header or footer). Many thanks...
  6. Hi... I am developing an app and would like to create a system that allows customers to message each other through the app. Whilst I have come up with a basic format, it is not even close in appearance and style of standard messaging systems such as Messenger (Facebook), Messages (Apple) etc. Is there a solution here within Caspio - or a 3rd party that allows customer-to-customer messaging that can be integrated into my Caspio App. Many thanks...
  7. Hi all.. I have a weekly calendar data page in my which shows that days for which assets are available.. Is it possible to set the background of the entire box containing all the data conditionally i.e. different colors for different assets e.g. Asset 1: TV Asset 2: DVD Asset 3: PC The weekly calendar shows 1st March 2nd March 3rd March TV Ref: A1233 - TV Ref: A1238 DVD Ref: A1234 DVD Ref: A1236 DVD Ref: A1239 PC Ref: A1235 PC Ref: A1237 - In the weekly calendar, is it possible for each of the assets to have a different colour background for the entire box they are in? I hope the above is clear enough... Many thanks
  8. Ahhh.. sorted - for weekly anyway... type(2) needed to be type(3)... This worked: <style type="text/css"> #target table:nth-of-type(3) td:nth-of-type(6) {display: none;} #target table:nth-of-type(3) th:nth-of-type(6) {display: none;} #target table:nth-of-type(3) td:nth-of-type(7) {display: none;} #target table:nth-of-type(3) th:nth-of-type(7) {display: none;} </style> <div id="target"> Many thanks ....
  9. Many thanks Matilda... I tried this an unfortunately it doesn't work so I'm obviously doing something wrong here.. On saving, the system removed </div> from the footer and changed the header to: <style type="text/css">#target table:nth-of-type(2) td:nth-of-type(1) {display: none;} #target table:nth-of-type(2) th:nth-of-type(1) {display: none;} #target table:nth-of-type(2) td:nth-of-type(7) {display: none;} #target table:nth-of-type(2) th:nth-of-type(7) {display: none;} </style> <div id="target"></div> Any suggestions? Thanks again..
  10. Hi Caspio gurus.. Is it possible to have the Month and Week calendar to only show Monday to Friday? i.e. hide Saturday and Sunday. Thanks...
  11. Hi Caspio gurus.. I have a Pivot Table datapage report in my app that close to meeting my needs. However, in a tabular report, I am able to add html sections in a column that enables me to capture the id of a line record and open another datapage using that record ID. I would like to be able to do this in my Pivot Table datapage report if possible. Any suggestions would be greatly appreciated. Cheers, Alan
  12. Yep... sorted... Thanks Walter.... It took a while to work through the code but I got there in the end...
  13. Hi gurus... I have a Caspio App supporting online customer interaction. As part of this, I have access to a bank server-based payment system for paying via credit card. My Caspio linked html page successfully collects data and transmits (POST) to the banking app via a php webpage. The bank processes this data and produces a report back via another php page indicating if the transaction was successful. My challenge is getting the php webpage data back into the Caspio app for storing in the appropriate tables. Does anyone have any advice on a simple way to do this. Whilst I have API access as part of my plan, I don't need full API integration as the Caspio app more than adequately covers my needs. It is this one page of data only that I need to get back into the app. Any advice would be greatly appreciated.. Cheers, Alan
  14. Unfortunately it is a bit more complex than that - but difficult to explain in this format. I'll try using rules to see if I can create a solution using the "Required" feature. Thanks again.
  15. Thanks for the input to this. It looks like I'll have to reconfigure the structure to make this work efficiently. I appreciate the support. Cheers
  16. Hi there.. I have a "Single Record Update" data page that produces several lines in a report. However, on occasion, the filters on the report produces "No Records". In this instance though, the Update button still operates and is causing a few minor issues when people press on "Update" despite there being nothing to update (yes, I've learnt a lot about users). Is it possible to disable the Update function when there are no records in the report.. Thanks again..
  17. Hi there Caspio gurus... I have a table: Orders.. In this table is a variety of columns holding data in columns: Orders_Food_Order_1 Orders_Food_Qty_1 Orders_Food_Order_2 Orders_Food_Qty_2 Orders_Drink_Order_1 Orders_Drink_Qty_1 Orders_Drink_Order_2 Orders_Drink_Qty_2 The Food_Order and Drink_Order fields are text and hold different food and drink orders from different customers and may hold the same data in different columns eg for Food Order 1 Qty 1 Order 2 Qty 2 Order 1 Qty 1 Order 2 Qty 2 Customer 1: HotDog 1 Fries 2 Shake 1 Coke 1 Customer 2: Fries 2 Burger 2 Customer 3: OnionRings 1 HotDog 1 Coke 1 Customer 4: Burger 2 OnionRings 1 What I would like to be able to do is aggregate this data so that I can perform calculations on that data - specifically how many orders for each type of food? ie Burger: 4 Fries: 4 HotDog: 2 OnionRings: 2 Shake: 1 Coke: 2 Any assistance would be greatly appreciated.. Cheers..
  18. Brilliant. Many thanks iren.. that's great. Much appreciated.
  19. Many thanks for this Aurora. One more question though. This certainly worked but the results seemed a bit variable i.e. it did not work every time I applied it. Strangely, for the same data page, it seemed to work on some occasions and no others. Would there be a reason for this? Also can you advise how I change the days? When it works, it shows Tuesday to Saturday and not Monday to Friday. Thanks again...
  20. Is it possible to set up a Calendar Data Page so that it shows weekdays only i.e. Monday to Friday? Thanks again..
  21. Hi there... I have what is hopefully a simple question to resolve.. I am running a calendar data page which shows different codes for each date i.e for an individual client, they might shows as AV, NA, SH, PH, BC, BR or WE. Is it possible to put a code in the footer of the calendar results page so that each cell can be color coded differently for each of the above records e.g. AV = green, NA = red etc. The alternative consideration would be for each value to be color coded rather than the entire cell i.e. the text would be different colors, not the cell. The value field is [@field:RT_Diary_Availability] The date field is ​​[@field:RT_Diary_Diary_Date*] or ​[@field:RT_Diary_Diary_Date] Many thanks...
  22. Hi all... I have a need to take a single field (an autonumber ID field "people_id") and insert it directly into several unrelated tables as a number field. Is it possible to do this as a single event via HTML coding - or indeed any other method - If so, once again, any advice/info would be gratefully received. Many thanks, Alan
  • Create New...