I need to have monthly plan..
I have Yearly plan and in yearly plan I have
YEARLPLAN
Company ABC - AA, BB and CC Group
Company CDE - CC,DD and EE Groups
Company EFG - EE,FF,GG Groups
Date of Visits-- April, may, June etc 2017 (this may vary)
All I need to do is make monthly plan
For Example
April 2007
Company only - "NUMBER OF GROUPS"
How can I do it?
Thanks for your help
I have Yearly plan and in yearly plan I have
YEARLPLAN
Company ABC - AA, BB and CC Group
Company CDE - CC,DD and EE Groups
Company EFG - EE,FF,GG Groups
Date of Visits-- April, may, June etc 2017 (this may vary)
All I need to do is make monthly plan
For Example
April 2007
Company only - "NUMBER OF GROUPS"
How can I do it?
Thanks for your help
-
232 Points
Posted 2 years ago
Gaurav Sharma, Certified Builder and Expert
-
6,070 Points
-
232 Points
Gaurav Sharma, Certified Builder and Expert
-
6,070 Points
If you are using a summary report then, you can group your rows by year.
-
232 Points
thanks. but how can I make it that the company only will show.. not the groups
-
232 Points
-
232 Points
-
232 Points
I have to make a field that i can multiple select a date :( so it can be summarized by yearly and monthly
Gaurav Sharma, Certified Builder and Expert
-
6,056 Points
No, you don't have to select multiple dates.
-
232 Points
what should i do> thanks so much for the help
-
232 Points
HI!
How can I also write multiple dates.. for example for this company i WILL BE VISITING IT FOR 4 TIMES A YEAR
How can I also write multiple dates.. for example for this company i WILL BE VISITING IT FOR 4 TIMES A YEAR
Gaurav Sharma, Certified Builder and Expert
-
6,058 Points
For that you have to create 4 records with multiple dates.
-
232 Points
How>
-
232 Points
Thank so much for the help im sorry if i have many questions. i just need help
Gaurav Sharma, Certified Builder and Expert
-
6,058 Points
No Problem Catherine :)
-
232 Points
may I know how to have multiple dates because what I did if have different Field, It cannot be summarizes my date...
-
232 Points
in one company i might have 1-24 visit every year..
for example form ABC Company... Ill visit them January, April, July and also October.. how can I input multiple dates so it can be summarized by monthly quarterly or yearly
for example form ABC Company... Ill visit them January, April, July and also October.. how can I input multiple dates so it can be summarized by monthly quarterly or yearly
Gaurav Sharma, Certified Builder and Expert
-
6,052 Points
I am here in India. It's 6:19 PM (IST) here. So, we can communicate tomorrow.
Please email me at gaurav.sharma@elevateservices.com once you are available.
Thanks,
Gaurav
Please email me at gaurav.sharma@elevateservices.com once you are available.
Thanks,
Gaurav
-
232 Points
Thank You so much. But is it really not possible to have multiple dates in one field?
Gaurav Sharma, Certified Builder and Expert
-
6,052 Points
I haven't done such workaround yet but As far as I know only we can create multi-select text field but can't select multiple dates.
It is possible to have multiple dates in one field if you create a formula Date field and concatenate all your dates but that doesn't make sense. :)
It is possible to have multiple dates in one field if you create a formula Date field and concatenate all your dates but that doesn't make sense. :)
(Edited)
Ⲇanom the ultimate (Dan Diebolt), Champion
-
30,174 Points
I hesitate to contribute to this thread as it is so long and winding but here goes ...
In general you can synthesize your own field type by concatenating information together in a multi-line text field. The concatenation could be as simple as using a delimiter such as a comma or pipe character:
Using this approach you could create a single text field to represent latitude and longitude within a single field. Creating a list or array of dates represented in a single field can likewise be accomplished through script. In fact, it is possible to configure the datepicker QuickBase uses to select multiple dates are return them as a list. See: http://jsfiddle.net/gydL0epa/
In general you can synthesize your own field type by concatenating information together in a multi-line text field. The concatenation could be as simple as using a delimiter such as a comma or pipe character:
1/16/2017 , 8/16/2017 , 3/4/2018OR
foo | bar | bazor a much more highly involved data structure such as XML, JSON etc:
<mydata>OR
<foo>bar</foo> <baz>qux</baz>
</mydata>
{ "id": 1,
"name": "A green door",
"price": 12.50,
"tags": ["home", "green"]
}Then when a form opens to add, edit or view a record you call a custom unpacking script that takes the stored representation and splices in a human viewable interface and when the form closes you call a custom packing script to takes changed values and restore them to the internal representation you are using.Using this approach you could create a single text field to represent latitude and longitude within a single field. Creating a list or array of dates represented in a single field can likewise be accomplished through script. In fact, it is possible to configure the datepicker QuickBase uses to select multiple dates are return them as a list. See: http://jsfiddle.net/gydL0epa/
Ⲇanom the ultimate (Dan Diebolt), Champion
-
30,174 Points
See:
Does QuickBase Support An Array Of Dates Field?https://community.quickbase.com/quickbase/topics/does-quickbase-support-an-array-of-dates-field
IMA Grandmaster - Does QuickBase Support Chessboard Fields?https://community.quickbase.com/quickbase/topics/ima-grandmaster-does-quickbase-support-chessboard-f...
FWIW, I have an array of additional demos in the works involving creating custom fields representing everything from Musical Scores, Mathematical Equations, UML Diagrams, Mind Maps, Fishbone Diagrams etc, and my favorite Category Theory Diagrams.
Yes we desperately need a Category Theory Diagram Field in QuickBase! This is the internal representation stored in a multi-line text field:
Does QuickBase Support An Array Of Dates Field?https://community.quickbase.com/quickbase/topics/does-quickbase-support-an-array-of-dates-field
IMA Grandmaster - Does QuickBase Support Chessboard Fields?https://community.quickbase.com/quickbase/topics/ima-grandmaster-does-quickbase-support-chessboard-f...
FWIW, I have an array of additional demos in the works involving creating custom fields representing everything from Musical Scores, Mathematical Equations, UML Diagrams, Mind Maps, Fishbone Diagrams etc, and my favorite Category Theory Diagrams.
Yes we desperately need a Category Theory Diagram Field in QuickBase! This is the internal representation stored in a multi-line text field:
\begin{xy}
\xymatrix {
U \ar@/_/[ddr]_y \ar@{.>}[dr]|{\langle x,y \rangle} \ar@/^/[drr]^x \\
& X \times_Z Y \ar[d]^q \ar[r]_p & X \ar[d]_f \\
& Y \ar[r]^g & Z
}
\end{xy}And this is the beautiful Category Theory Diagram field displayed for human consumption:(Edited)
-
31,698 Points
My 2 cents for this would be to make the "visits" a child table. Then just have a "date" field, and you can have multiples, then build many different types of reports based on the date and grouped how you'd like.
Gaurav Sharma, Certified Builder and Expert
-
6,058 Points
It means we have multiple visits with different dates right?
-
220 Points
for example.. I have to visit 1 company with many groups...
Group A- January , May, August and December
Group B, Feb, april, July, Nov..
and then many companies in a year.. around 100 companies
-
220 Points
Gaurav Sharma, Certified Builder and Expert
-
6,052 Points
-
220 Points
meeting will start after an hour?
again thank you very much
-
220 Points
to tell you honestly im on the middle of our process, im stuck in making monthly plan.
Gaurav Sharma, Certified Builder and Expert
-
6,052 Points
Yes
-
220 Points
Hi Mr. Guarav
Gaurav Sharma, Certified Builder and Expert
-
6,052 Points
Hello Cathee,
How are you? Tell me.
How are you? Tell me.
-
220 Points
-
220 Points