jeffs88keys

It appears that if I want to see a calendar based on 3 different fields in my table, I literally have to run 3 different calendars. Is it possible to only run one calendar that reflects the date of 3 different fields on one calendar?

I knew I was overthinking it. So simple. Thank you !!!!

I am trying to create an input form where the user can look to see if a record exists prior to creating a new record. For example, in my image, I need to add JW Marriott Miami to the Resort Name field. I need to see if it already exists. I'm currently doing that via this cascading dropdown. However, now that the user sees that it does NOT already exist in the table, we need the capability to add it. I obviously can not do it via this cascading dropdown. What are my options here? It'l likely simply, but I'm missing it. Thanks.

Hello, I have a simple form. I want to fill in field:Arrival_Date with regular calendar popup. However, when the user selectes field:Departure_Date, I'd like it to default to the same value just entered in field:Arrival_Date so that the departure date can be easily selected based on the arrival date, not today's date which is the default. Think of it in terms of an online reservation system for hotels. Of course, all of this occurs prior to submitting the form. It needs to be on the fly as the values are entered. Is this possible? I can't figure it out. Thanks !!

@imJihyo Thank you. However, I'm trying to pass from a form and using virtual fields. There's no opportunity to create a calculated field. The URL is given to the end user in an email notification.

I'm trying to passthrough a field that often has multiple words as it's content (such as a song title). When doing so, there is no separator between the words, and thus the URL breaks after the first word. (i.e. www.website.com/?song=piano man - the url breaks after the word piano) Is there a way that I'm missing so that I can have a multiple-word passthrough without breaking the URL? Thanks !

Thank you so much....I may not have been clear. I'm not really looking to validate that the end_date is prior to the beginning_date. I just want the end_date to have a "starting point" equal to the beginning date. Case in point..... we sell vacations. A person might not travel until June of 2023. In the start date, we have to hunt for that date in the calendar. In the end date, it would be great if it would just pick up where the start_date left off. We can then just click on the end date which is typically in the same month....without having to hunt for the end date from today's date. I hope that makes more sense.

I have a submission form datapage. Simply trying to set up 2 date fields for a travel agency application. The 2 dates are "Arrival_Date" and "Departure_Date". Here's the question: Because we may be using dates that are up to 2 years in the future, once the "Arrival_Date" is entered using the calendar option. can the "Departure_Date" load the same date as "arrival_date" (without submitting) so as to avoid having to work forward from 'today'? The user could simply check a few days into the future from the preset "Arrival_Date". Thanks.

I can see this making sense. I'll definitely give it a shot. Thank you !!!

I have a table (Sales) where my employees enter their sales. Occasionally they need to modify the information in the entry (deliver date, cost, etc). I already have a Triggered Action that saves the original entry to a separate table (Sales_History) to maintain record of the original entry. What I'm trying to achieve is this.....how can I see what the exact change was in the entry.....meaning...which field was changed? Is there a method to compare the record that is in the main table (Sales) to the one that was moved to the Sales History table? Example: Salesperson changes the cost of the item, but all other fields remain the same. How can I auto determine that it was the price field that changed? Thanks !!

Very grateful for your time. I will give this a shot. Thank you !!!

Hello, I understand that this may be an html box on my report. I need to accomplish the following, and I'm not sure if can be done. If [field1] is blank or if [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS OUT OF COMPLIANCE" (and maybe in red???) (otherwise) if [field1] is blank or [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS IN COMPLIANCE" (and maybe in blue???) Thanks !!!

@CoopperBackpack I think we may be off. This is not a details datapage...this is a tabular report. I completely used the wrong terminology and I'm so sorry. Seeing the screenshot below, the elements that you see beginning with Vacation_Entry are the details shown in the example above. The two elements beginning with Trips_V2 are the 2 fields that are being tested to create either of the 2 return phrases that I'm looking for. I hope that clarifies easier. I'm sorry if I wasted your time with the previous snafu in terminology.

Hi @CoopperBackpack, Sorry for the delay..... my notification didn't go off. So I have this on a Details Report, and is based on a 2 table view. Table 1 lists the "trips", and Table 2 lists the components of the trip. The Details report shows the details of the Table 2 trip, but I am looking for the query above to be based on the Table 1 "trips". So if [trips:field 1] (text field) is blank OR if [trips:field 2] (file upload) is empty, then it creates the statement above in Red. Otherwise, a different statement is made (see OP above). I've attached a sample of what the display would look like.

Thanks, but Rules don't apply for what I'm looking for. Thanks.