Divya__OSSE-Con
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Capture Timestamp based on change in status
I 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 ------------------------------11Views0likes0CommentsRe: Quickbase ranking based on field value
Sure . 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 ------------------------------4Views0likes2CommentsRe: Quickbase ranking based on field value
Hi 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 ------------------------------6Views0likes4CommentsQuickbase ranking based on field value
I 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-Requisites
Thanks 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 ------------------------------11Views0likes2CommentsRe: Compare values based on Pre-Requisites
Mark, 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 ------------------------------0Views0likes2Comments