AnsweredAssumed Answered

Insert From Last (Hotel) Visited

Question asked by billowen on Jun 3, 2017
Latest reply on Jun 3, 2017 by billowen

I have a Table called Accommodations that lists the hotels a tour is staying in entry fields include DayNumber & Nights (they are staying there).

 

Using that and referencing the tour start date entered in the Group table, one can enter Day 1 first and the program will display the departure date and then by adding the number of nights, the check out date from that hotel. Example:

 

Day Number (entry)Arrival Date (calculated)
Check Out Date (calculated)Nights in Stay (entry)
14/20/20184/22/20182
34/22/20184/23/20181
44/23/20184/27/20184

 

I have been doing the math in my head: Day 1 + 2 (nights), okay manually enter 3 for the 2nd hotel's day number.

 

FinallyI got courageous and tried the Insert From Last Visited script step and couldn't get it to do anything: it didn't build a new record in the Accommodations table (although I tried with and without New Record step too) and so didn't enter anything (the original day # or the calculation I specified DayNumber + Nights, either).

 

Do you can see what I should be doing? Thanks!

Outcomes