booking

I am creating a booking system with the logic of slots availability But when I select the slot from the gallery it doesn't fill the form I already input Gallery.Selected also tried with LookUp('Data Source',ID=Gallery.Selected.ID) and it doesn't work either

I am developing a power apps site, for this I am creating a booking site I created a list in share where I located the available slots for the day I type the formula for filtering the slots only to show the slots available for the selected date and also to be greater than the current time but...

I am making a booking system for what I am developing a weekly view calendar, I am creating a gallery for the headers of this calendar. The thing is that in the calendar some months contain a few days from other months, like the follwing picture as you see the month is January (Enero) and...

Hi, I'm looking to have 1 sheet that has a list of resources that can be booked. On that sheet if you choose a date and time it shows which resources are free on that date and which are not. If you then want to book one of them, you enter say a "Y" and it then pulls through to a calendar style...

so i have in column A...booking point...and under that...x376x, x324x.... in column B, i have product type....under that, TR Swap for whatever reason, when i pull this data in using a vba macro based on the criteria above, it's also pulling in booking point "x324xVAL," but i dont want that...i...

Good Evening, I have two queries: Firstly, I have a excel spreadsheet where it imports the booking data from the word form. Owing to the word form timing format, the timing in excel appear as 0100-0200 whereas I would like them to appear as 01:00-02:00. Is that possible through coding or...

Hi, I hope someone will be able to help me please. Ok I am trying to work out how long a community centre is open each day. In Column A I have the date, in Column B I have the start time of a booking, in Column C I have the end time of the booking, Column D is the duration of the booking. I...

We have a booking package issued by our corporate office, and we have a local PM file we use to mange our construction projects within our office. Obviously, the data in the PM file is originally sourced from the Booking Package, however the data within the booking package is across multiple...

Hi i have a wee array formula here to show me last booking {=MAX(IF('[calendar.xlsx]full year'!$D$8:$ABG$103=B2,'[calendar.xlsx]full year'!$D$4:$ABG$4,""))} '[calendar.xlsx]full year'!$D$8:$ABG$103 - is where you book names B2 - client name to look for '[calendar.xlsx]full year'!$D$4:$ABG$4 -...

I'll be grateful for any assistance, I feel that I'm close to a solution, but need help in properly defining the measure [EffortAssigned] - either that or I'm trying to do something that is not possible. I apologize for the length of this post, but I hope I've described the situation clearly...

My formula has magically stopped working.. it used to look like this: =IFERROR(IF(COUNTIF(BookData!O:O,EnqData!Q3)=0,"",INDEX(BookData!B:B,MATCH(Q3,IF(BookData!H:H>=C3,BookData!O:O,""),0),0)),"") What this does: First portion - Counts whether the unique customer reference in Q3 matches...

Sorry if that's confusing. There are two sheets, both have a unique reference on them. One is enquiry data, the other is booking data. I need to match enquiry dates to booking dates to work out lead times, find out how long it takes our customers to book after requesting a brochure (enquiry)...

Hi There I have a data set with multiple columns where I need to count the unique fields in a seperate tab based on multiple criteria. <tbody> PNR Booking Date Booking Agent MAX Booking Agent ID AAVBHD01 10/09/2018 AO 99355 AAWTZK01 05/09/2018 BM 86788 ABDYNH01 10/09/2018 GM 23023...

=SUMIFS('Booking Data'!$I:$I, 'Booking Data'!$D:$D, $S$6, 'Booking Data'!$S:$S, $U7, 'Booking Data'!$T:$T, W$4, 'Booking Data'!$J:$J, "<>X",'Booking Data'!$U:$U,'JG EU'!$C$2)+SUMIFS('Booking Data'!$V:$V, 'Booking Data'!$D:$D, $S$6, 'Booking Data'!$S:$S, $U7, 'Booking Data'!$T:$T, W$4, 'Booking...

Hi there, I have data that when i vlookup it only picks up the first value. What is the best way of being able to find the corresponding value in a different column if the criteria matches? For example, i want to be able to find what all the Type 2 bookings are for the individuals. What...

Hi all, I am trying to find a way to extract duplicate data from one table where each value has multiple rows and get it into a table where each value has only one row. So in Table A, I have the following columns: employee name, holiday booking date, future booking?, past booking?, sum of...

Hey there! I'm working on a project where I need to calculate shared bills among multiple properties. The problem is that occupation varies across them, with people checking in and out, but bills needing to be calculated so that people can pay correct proportional amounts. I've been trying to...

Hi Am looking for help. I have two tables in power pivot. The first one show employee attendance (see example below). The second shows employee daily booking (see example below). What am looking to do is show all employee bookings within the employees attendance. I can do this for the employees...

Suppose a contact is booked on 9th May-2016 for 3 months . Since the day of booking how many times the contract has been renewed and what is the last date of renewal till current date. example <colgroup><col><col span="5"><col><col span="4"></colgroup><tbody> Last Date of Renewal...

Main Report: I have my main booking references in column A, secondary supplier booking references in column B, amount due in column C. Fund Report: I have my main booking reference in this report. For each main reference, there can be 1 secondary supplier ref, or multiple. If my main...