I recently tried to implement the workflow described in this article, but adapted for Flex:
https://howto.caspio.com/tech-tips-and-articles/separate-input-fields-for-datetime-parts/

Below is an updated configuration to account for Flex. Keep in mind that at the table level, the Date/Time data type stores values in MM/DD/YYYY or MM/DD/YYYY HH:MM:SS format only, so the solution must handle the conversion from 12-hour input format to 24-hour output format accordingly.

I have put together two variations — one for 12-hour input format and one for 24-hour input format.

 

12-HOUR INPUT FORMAT

Pre-requisites:

1. On the submission form DataPart, add the following virtual fields:

- Virtual 1 — Date picker: use a Date input Calendar Popup text field form element.
- Virtual 2 — Hours picker: use a drop-down with values from 01 to 12.
- Virtual 3 — Minutes picker: use a drop-down with values from 00 to 59. I recommend creating a lookup table for this.
- Virtual 4 — Seconds picker: use a drop-down with values from 00 to 59. I recommend creating a lookup table for this. If seconds are not required, set it as a hidden field with a default value of 00.
- Virtual 5 — AM/PM picker: use a drop-down with AM and PM as values.
- Virtual 6 — Calculated value field that returns the hour in 24-hour format based on Virtual 2 and Virtual 5. Use the following formula:

```
CASE
WHEN ([@runtimefield:_Virtual 5]='AM' AND [@runtimefield:_Virtual 2]!='12' ) OR ( [@runtimefield:_Virtual 5] = 'PM' AND [@runtimefield:_Virtual 2] = '12')
THEN
CAST([@runtimefield:_Virtual 2] AS INT)
WHEN [@runtimefield:_Virtual 5]='AM' AND [@runtimefield:_Virtual 2] = '12'
THEN 
0
WHEN LEN(ISNULL([@runtimefield:_Virtual 5], ''))>0 AND CAST([@runtimefield:_Virtual 2] AS INT) < 12
THEN
CAST([@runtimefield:_Virtual 2] AS INT)+12
ELSE 0
END
```

2. Add the DateTime field as a calculated value using the following formula:

```
DATEADD(second, CAST([@runtimefield:_Virtual 4] AS INT), DATEADD(minute, CAST([@runtimefield:_Virtual 3] AS INT), DATEADD(hour, CAST([@runtimefield:_Virtual 6] AS INT), CAST([@runtimefield:_Virtual 1] AS DATETIME))))
```

3. You can hide Virtual 6 and the DateTime field using rules by creating a condition that always evaluates to true. Make sure to check the "Save hidden values" checkbox.







 

24-HOUR INPUT FORMAT

The 24-hour format is simpler since no AM/PM conversion is needed.

Pre-requisites:

1. On the submission form DataPart, add the following virtual fields:

- Virtual 1 — Date picker: use a Date input Calendar Popup text field form element.
- Virtual 2 — Hours picker: use a drop-down with values from 00 to 23.
- Virtual 3 — Minutes picker: use a drop-down with values from 00 to 59. I recommend creating a lookup table for this.
- Virtual 4 — Seconds picker: use a drop-down with values from 00 to 59. I recommend creating a lookup table for this. If seconds are not required, set it as a hidden field with a default value of 00.

2. Add the DateTime field as a calculated value using the following formula:

```
DATEADD(second, CAST([@runtimefield:_Virtual 4] AS INT), DATEADD(minute, CAST([@runtimefield:_Virtual 3] AS INT), DATEADD(hour, CAST([@runtimefield:_Virtual 2] AS INT), CAST([@runtimefield:_Virtual 1] AS DATETIME))))
```

I'm building my app in Flex, and I want a checkbox that will auto-populate the bill to and ship to portions of my form, but I'm not sure how to go about it.

I currently have two separate accounts and I’m trying to move a Flex-based application from one account to the other. The application includes multiple DataParts, tables, and custom configurations that I’d like to replicate as closely as possible.

However, upon checking, it seems that I cannot simply export and import the application the same way I would within Bridge.

Could you help me, please?

I would like to ask if there is a way to export a Flex application in Caspio. For example, exporting the full configuration such as DataParts, tables, and settings so it can be backed up or transferred to another account.

Is there currently a feature or recommended approach to export Flex applications?

Any guidance or best practices would be greatly appreciated.

Thank you!

I would just like to share this method of mine to get the records from a specific date range using Task. Then, create a simple report about it and send it via email.

Here is my setup for getting the records in between the next 2 weeks.

You may directly apply the Add n days to the condition but just to see the setup easier,  I've created the 1st day and 14th day variable blocks.

I hope this can be helpful to some!

I’m reaching out for some priority assistance to automate and enhance the behavior of a submission and update form on my app. Below are the specific requirements I’d like help implementing:

1. Hide the "AssignAsAsset" Checkbox:
   I’d like to have this field hidden from the user interface entirely.

2. Custom Button Behavior – "Confirm and Register as an Asset":
   When this button is clicked, I would like the following to happen:

   • The hidden field AssignAsAsset should be set to true.

   • Form submitted so that the record is added, thereafter, the user should be redirected to HTML Page #1.

3. Custom Button Behavior – "Submit":
   When this button is clicked:

   • It should submit/save the current form data.

   • Then redirect the user to HTML Page #2.

4. Update Form Behavior (View-Only Mode):
   On the update version of this form, if the AssignAsAsset value is true, I would like:

   • Both action buttons ("Confirm and Register as an Asset" and "Submit") to be hidden.

   • The page to appear as view-only—with a back button to take the user to the previous page.

Please let me know the best way to implement this, whether via JavaScript, Rules, or a recommended workaround.

Thanks in advance for your guidance and support!

Best regards,
Mark Mayhrai

EG: On page load, get the value of  a field to use else where, or set values.

The alert block fires outside of the event listener.

<script type="text/javascript">

I have a parent table and a child table, in a one-to-one relationship.  I had hoped to use a details/update form for data entry, however, when blank the fields on the form aren't visible. One workaround was to have a button link to an overlay with a data entry form, however, this causes issues when there is an existing record and the user clicks this button.

1) What is the best solution here? This seems like it would be a common problem, so I am probably missing something obvious.

2) Should I be using a triggered action on the parent table? E.g: After insert →  Insert a blank/default row into the child table with the new pat_id.

3) If a triggered action is the best solution, how do I set that up? I haven't been able to get this working. Where am I going wrong? - see attached. 

Thanks in advance,

Thomas

Further to that, the methods need to execute on load and binded to a control "change" event, would this be possible on Overlay, but standard ContentLoaded etc etc does not even work, even if you add a timer to a overlay, you can retrieve the attribute by id, but binding a chnge event fails.

Anyone else having these issues, it would be great to have some validation on Flex data pages, without reinventing the wheel.

EG: