DRAhmed
-
Posts
58 -
Joined
-
Last visited
Reputation Activity
-
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
-
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.
-
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/
-
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
-
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
-
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/