Jump to content
  • 0

Timed editing block


Question

3 answers to this question

Recommended Posts

  • 0

Hi @cdutoit62,

I can suggest following steps to create your workflow:

1. Create a field in your table which will store an expiration date.

You can use DateAdd() function in the Formula field.

https://howto.caspio.com/function-reference/

You can use Triggered action or Calculated Value form element if you don`t want to set expiration date manually. 

2. Create a Сonditional Rule on Details section of your Tabular Report.

You need to set up a Rule which compares the current date with the expiration date. 

Please add a Virtual field and assign a hidden form element to it with a Timestamp default parameter.

3. Make all fields editable on Details section (assign TextField form element).

4. Create a conditional Rule which will make fields "Display only" if the expiration date is less then the Virtual field.

You can check this article for further information about conditional rules:

https://howto.caspio.com/datapages/forms/conditional-forms/

Hope this helps.

Regards,

Vitalikssssss

Screenshot.JPG

Link to post
Share on other sites
  • 0

Thank for the advice Vitalikssssss

My details page is not tabular.  I'm not sure if that makes a difference but when trying to add a rule the virtual field is available but for some reason the calculated field in the table is not.  I also tried to create a calculated field on the details page but it still does not show up on the rules field picker.

Link to post
Share on other sites
  • 0

Hi @cdutoit62 ,

Please note that only editable fields available in Conditional Rules.

Quote

Note that only standard, editable fields may be used in Criteria and the following cannot be used:

  • File Fields, Calculated Fields, CAPTCHA, and Distance Search fields
  • Smart fields, such as Timestamp and Password
  • Secondary field used in multiple search criteria (such as in Date Range)
  • Localized Number and Date fields, such as dd/mm/yyyy formatted date.
  • HTML Blocks
2

It doesn`t make a difference if you use standalone Details page i.o. Details section from Tabular report from my example.

Hope this helps.

Regards,

vitalikssssss

 

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...