Show last status registered in dropdown field, submission fo

[anibaldps]

Hi:

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!

Anibal

[bahar_vm]

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;

[Kurumi]

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!

 

[NailDyanC]

Hi just to add to the previous comment above, here is a article guide that you can use to know more about calculated value: https://howto.caspio.com/datapages/datapage-components/calculated-values/

I hope that helps.