Jump to content

telly

Caspio Ninja
  • Content Count

    50
  • Joined

  • Last visited

About telly

  • Rank
    Advanced Member

Recent Profile Visitors

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

  1. Can I use a wildcard such as % or * in the file name to be collected from the source SFTP folder such as LUTO_Outlet*.csv because the name of the file to be collected will change slightly each time? I find Datahub in general very good, but lacking in certain features which I and other Caspio customers have reported and requested via the appropriate channels.
  2. Can you help with Case Statement involving a date/time field and a number field? I am receiving an invalid formula error on the following: CASE WHEN [@field:Min_Rendered] IS NOT NULL THEN [@field:Reminder_Date] + Try_Convert(datetime, [@field:Min_Rendered])ELSE 'ETA Not Provided'END Reminder_Date is a date/time datatype and Min_Rendered is a number datatype. But the value of the Reminder_Date field upon record update form element is a TimeStamp My current workflow: When the User submits the record, they fill out how many minutes they are from the location site. Upon submit there is a Timestamp. For the Company user, when they view the record, I am trying to give the estimated ETA. So the timestamp + the number of minutes. The sample result should be: 1/19/2020 11:29 AM The time of 11:19([@field:Reminder_Date]) + the Value of the minutes 10([@field:Min_Rendered]).
  3. I’m looking to create a report of given table with a timestamp field that should give me Count of records group by Cole_ID and Minute submitted of timestamp field.So for example the following table If same Cole_ID was entered 3 times at same minute, it should give only one record listing the Cole_ID with count 3. I need a group by query against the entire table, the purpose of this is to see how many records where edited at the same minutes (we are suspecting a system error). How can I accomplish that with Caspio?
  4. telly

    Data Page Name

    Hi, Is it possible to get the name of the DataPage and display it on the Header?
  5. Hi , I need help with formatting the Date, as of the moment the format that I have is 01/01/2020 and I want it to be display like this January - 01 - 2020. Is this possible? Thanks.
  6. Hi Frank, thank you for confirming. I added the responsive code, still can't replicate the issue. It would be helpful if you provide the link of the DataPage that has this issue for us to be able to test on our end. Thank you. -Telly
  7. Hello Frank, We implemented a Caspio Mobile Kit and set the field to autocomplete. However, we wasn't able to replicate the issue. We tested it using android phone and iPhone and both are working. Please refer to these screenshots: May I know what browser did you use, version of your iPhone and type of deployment that you used? Thanks, Telly
  8. Hi - I need to use a font "Poiret One" one of my DataPage, I tried to set the style inside the header and add !important, but no luck. Here is my screenshot of the DataPage Also is the font that I wanted: Thank you in advance.
  9. Hi- Is it possible to logout the user and redirect it to the login page after submitting a record? Example|: User logged in, then submit a record and it will redirect it to login page.
  10. Hi, Is it possible to adjust the Grid edit (spreadsheet style) "box"? Because I keep on scrolling to the left so that I can input characters in to the field.
  11. Hi - I have 20 List Data Type in my table and I would like to display it in the Data Page, but I was not able to add more that 15 list Data type . Can I add more than 15 list Data type in DataPage?
  12. Hi @SunakoChan- Thank you so much, is it possible to get only the month or year of the birthday field?
  13. Hi - I need help on combine my Date and auto-number field in my formula. I have this formula: [@field:Birthday] + [@field:Age], and it is just adding the age to date. Thank you in advance.
  14. Hi - I want to stop form submission if certain criteria is not met, is this possible?
  15. Hi @SunakoChan- Thank you for that, but can you provide me also the style of the Submission button?
×
×
  • Create New...