Jump to content

cordova

Members
  • Posts

    12
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

cordova's Achievements

  1. Hi, I have a List Report DataPage and among the fields, I have School_1, Educ_Attainment_1, School_2, Educ_Attainment_2, which basically means that users should add in their two highest educational attainments and from which school they studied (for example, one person would have a Bachelor's Degree in Harvard University, and a Master's Degree in Princeton University, while another person would have a Master's Degree in University of Michigan and a Doctorate Degree in Stanford University), and that works fine. But is it possible to hide one's educational attainment (and the affiliated university) if it's a Bachelor's one? So for those who records who has educational attainments of Bachelor's that field should be hidden and the university.
  2. Hi, I have an application that allows employees to time in and time out twice (so on my table i have four fields, two for time-in and two for time-out, all Date/Time fields) and have a break time as long as they want (and I store the break time on a Date/Time field wherein if an employee took a break of one hour and 30 mins, the break time field would look something like "12/30/1899 01:30:00" and I don't necessarily care about the date because I only used the hour and minute as the placeholder for the break time spent by the user). My question is how can I get the total minutes spent by the customer for that particular day? The formula should go something like: ((time difference between first time-in and first time-out) + (time difference between second time-in and second time-out)) - break time So if I have: Time-in 1: 02/15/2022 08:00:00 Time-out 1: 02/15/2022 10:00:00 (wherein time-in 1 and time-out 1 returns two hours, meaning the employee rendered 2 work hours) Time-in 2: 02/15/2022 10:30:00 Time-out 2: 02/15/2022 15:00:00 (wherein time-in 2 and time-out 2 returns 4 and a half hours, meaning the employee rendered 4..5 work hours) Break time: 02/15/2022 00:45:00 (which means the employee took a 45 min hour break, and have this 45 min break subtracted from the 6.5 hours rendered (2 work hours + 4.5 work hours), which would total to 5/75 hours or 345 minutes) Is there a way to do this on a formula field in the table?
  3. Hi, I have a submission form with a couple of fields that are required (and they should also only accept numbers) along with a file field. The submission works fine, but say, when a user fills out all fields (including the file field) except for one of the number fields (or if i input a text instead of a number in one of the fields), when I hit submit, the page gets reloaded telling me to fill in all of the fields properly (to not leave any fields blank or to input only numbers), which is expected, but I noticed that the file I have attached earlier disappears. Is there anyway to retain the file when the validation arises?
  4. Hi, Is it possible to highlight the entire field including the label with maybe a different background when that field's text box is selected?
  5. Hi, I have a date field in my submission form and I want to prevent the user from selecting a date that is not within a specified range of dates. Like for example, I only want the user to input dates that are within 12/01/2022 to 12/12/2022. Any dates that are not within that period will not be allowed.
  6. Hi. I'm using a Details DataPage with a search form and I'm aware that there is a 'Search Again' link that takes me back to the search form, but can I instead have a Back button beside the Update button that essentially behaves the same way as the 'Search Again' link?
  7. Hi, I have an account number field and I'm wondering whether I could use a formula or a calculated field that outputs the account number but masks it with asterisks except for the last four digits. Something like: ********7890
  8. Hi, I have a date field and I need to have a formula field that outputs the first date of that date's previous month, and another that outputs the last day of that date's previous month, but I can't get the right syntax.
  9. Hi, I was wondering whether it would be possible to move back and forth between my records in my Details page by pressing the left and right arrow keys on my keyboard instead of the buttons on the page
  10. Hi, So I have an HTML DataPage wherein I embedded multiple Report DataPages as iFrames. Would it be possible for me to have a button in the HTML DataPage that activates all the Download Data link for each of the Report DataPages so that all of them are 'clicked' all at once then generates the documents all at once? This way I wouldnt have to download them individually.
  11. Hi, I want to know whether it is possible in a submission DataPage to place some fields in a container and make that container scrollable.
  12. Hi, I want to create a formula field (that puts last name and first name next to each other) and set this as unique, but I can’t seem to make this unique since apparently some of my records have the same first name and last name. Is there a way for me to mark each duplicate records with their nth iteration? For example: First_Name Last_Name Complete_Name Complete_Name_Nth_Iteration John Doe JohnDoe JohnDoe John Doe JohnDoe JohnDoe2 John Doe JohnDoe JohnDoe3 If ever I was able to make the Complete_Name_Nth_Iteration, I could then finally set that field to unique, but I’m not sure how to achieve this.
×
×
  • Create New...