Jump to content
  • 0

Show last status registered in dropdown field, submission fo




I'm trying to see if there is a way to show the last status registered for a given application number.

This is the definition of my table:

App_Number1 - Status1

App_Number1 - Status2

App_Number1 - Status3

How can i configure a dropdown field in a submission form to only show me the LAST status registered for a given App_Number?

I want to force the user to only choose the last Status for an App_Number.

I would appreciate any help!


Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi Anibal,

You can sort the dropdown by the submission date field if you have one. This way it shows the last submitted status in the dropdown first; if you want to remove the other options from the dropdown list, you can write a Java Script to remove them. There is a similar example at viewtopic.php?f=14&t=12179

Another solution I am thinking of is to disable the dropdown so it shows the last status and user can not pick any other option from the list since the dropdown is disabled. This also requires Java Script but much simpler like:

var d1 = document.getElementById("InsertRecordFIELDNAME");

d1.disabled = true;

Link to comment
Share on other sites

  • 0

Hi @anibaldps,

You could also set/choose it automatically as the last record using the Calculated Value. This allows you to generate calculations and another calling of fields which you can use for concatenation. You can check the documentation here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/

Check these videos for more information:


I hope this helps!


Link to comment
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.

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.

  • Create New...