Jump to content

DRAhmed

Caspio Ninja
  • Posts

    58
  • Joined

  • Last visited

Reputation Activity

  1. Thanks
    DRAhmed reacted to CoopperBackpack in calculation in a rule   
    Hello @DRAhmed
    If you apply the formula on the DataPage, this one should calculate the difference between the the date in format mm/yyyy and the today`s date in months:
    DateDiff(month, (TRY_CONVERT(date, (LEFT([@field:Date],2)+'/01/'+RIGHT([@field:Date],4)), 101)), SysUTCDateTime()) Replace the [@field:Date] with the field that stores date in mm/yyyy format. 
    I am afraid that I have no the table example that you mentioned. However, I believe it is possible to generate the values in Excel, for example
  2. Thanks
    DRAhmed reacted to CoopperBackpack in calculation in a rule   
    It looks like I was able to generate the values in Excel.
    Please try to download the table https://docs.google.com/spreadsheets/d/1m5wyCt7CKrk7etmGKhqwg-Tga3vQIIgX/edit?usp=sharing&ouid=108834513784025380354&rtpof=true&sd=true

    If you need steps to create the same file, please let me know, I will provide the steps.
  3. Like
    DRAhmed reacted to Aether in uploadcare   
    It seems that the uploadcare widget has a wide variety of function that can be used (like cropping, drag and drop of files, etc.), if you want to connect it to your actual field in your table and your not familiar much in coding then I suggest for you to check with our Professional Services and they can create a custom code for your needs. https://www.caspio.com/services/professional-services/
     
  4. Like
    DRAhmed reacted to ParkLoey in syntax error   
    Hi! Just to add a bit more info, I think the problem with the calculation was the result values. I believe CAST() function is used for converting a value to a specific datatype. 
    CAST(expression AS datatype) Since specialist and intern aren't datatypes but I guess values you want to show, this will not be validated.
    In case statements, you can set the value of the result simply like the one provided above.
    You can check these links for more samples:
    https://howto.caspio.com/function-reference/#:~:text=Return-,Case,-Evaluates a list
    https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/#:~:text=Birth. Learn more.-,Conditional Cases in Calculated Fields,-You can use
     
    I hope this helps  
  5. Like
    DRAhmed reacted to SangK in Bulk file download associated only with one record   
    Hello,
    I currently have user(s) uploading 30 separate files (docx, pdf, other) attached to 30 separate fields, per record in one table. 
    Anyone have an experience on how one can create a download button that will download the 30 separate  files using a single click, per record?
    Destination will be browser default, just looking for assistant with auto downloading all 30 files tied to a single record.  Any ideas would be greatly appreciate it.
    Thank you
  6. Like
    DRAhmed reacted to futurist in unable to find a way to create the desired app   
    Hi @DRAhmed,
    I think there's lots of nuances with the information you have provided and it would be better if you could provide a more thorough explanation for your workflow, but from what I can initially tell, these things would help:
    filtering for records based on a pre-defined criteria:
    https://howto.caspio.com/parameters/tech-tip-custom-filter-elements/
     
    cascading elements:
    https://howto.caspio.com/datapages/datapage-components/cascading-elements/
     
    calculated values:
    https://howto.caspio.com/datapages/datapage-components/calculated-values/
    https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/
×
×
  • Create New...