ContributionsMost RecentMost LikesSolutionsCapture Timestamp based on change in statusI have HTML code page, which displays bus route statuses, for multiple locations. The users can update any of locations, route status, based on the service. I want to capture the timestamp, when the status changes and display as- This page was last updated on : 2/2/2022 1.56 PM. This time should be based on the last status update. How can i accomplish this? Please suggest. Thank you in advance. ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------ Re: Quickbase ranking based on field valueGot it. This works perfectly. Thank you for a very quick response. ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------ Re: Quickbase ranking based on field valueSure . All of the fields are in the same table. When an applicant submits his form, he has to enter all the information- Name, Email and College rankings. There are only 4 colleges , which are field names, and the applicant needs to specify the rank, for each of these colleges. All I am trying to do is, when the applicant enters the rank , he should not be able to specify the same rank more than once for each of the different colleges that he can choose from. Please suggest. ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------ Re: Quickbase ranking based on field valueHi Mark, When i tried this approach, it worked initially. But not anymore. The reason that i have identified is because - I have the same table for colleges and students. Colleges are field names with ranks as values, in the student form. So , i cannot use the [Related Student] and [Related College]. I tried to implement the workaround, with just using the college ranks, the system is throwing an error on saving, only when the combination is repetitive. Not the values. Please suggest. TIA. ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------ Re: Quickbase ranking based on field valueThanks Mark. That worked like a charm! ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------ Quickbase ranking based on field valueI have a project - College application. The students can submit application and specify their choice of college and specify a rank for each choice. College - Rank A - 1 B - 2 C - 3 How can i prevent the user from specifying the same rank for more than 1 college? I do not want the user to do this- College - Rank A - 1 B - 1 C - 1 Please suggest. TIA ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------ Re: Compare values based on Pre-RequisitesYes Mark, this is an EOTI app and anyone can register with the link. ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------ Re: Compare values based on Pre-RequisitesThanks Don. But the issue is there is no separate student user table. This application is open to "Everyone on the internet" and any user can register with the link. ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------ Re: Compare values based on Pre-RequisitesMark, I am at a point in creating relation ship between user and registrations. Currently, all the registrations lie in the same table- Registrations. Can i use quickbase actions to create a record in User table and copy the email address, when ever a new registration record has been added? Email address will be the key for the user table. I did this. but not able to derive the number of registrations tied to the user email. ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------ Re: Compare values based on Pre-RequisitesThank Mark. Will try and keep you posted. ------------------------------ Divya (OSSE-Contractor) Pogaku ------------------------------