# Hi! Can you help me? How Can I count the Text Data form another table????

• 0
• Question
• Updated 2 years ago
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?

• 232 Points

Posted 2 years ago

• 0
• 6,070 Points
Hi Catherine,

Are you trying to create a report?

Thanks,
Gaurav
• 232 Points
No I am trying to make a monthly plan from yearly plan
• 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
• 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
• 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
• 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
• 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
• 232 Points
Thank You so much. But is it really not possible to have multiple dates in one field?
• 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. :)
(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:
1/16/2017 , 8/16/2017 , 3/4/2018
OR
foo | bar | baz
or a much more highly involved data structure such as XML, JSON etc:
<mydata>  <foo>bar</foo>
<baz>qux</baz></mydata>
OR
{  "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:

\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.
• 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
• 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.
• 6,052 Points
Yes
• 220 Points
Hi Mr. Guarav
• 6,052 Points
Hello Cathee,

How are you? Tell me.
• 220 Points
I sent you an email, are you available?
• 220 Points
I'm fine mr. Guarav. How about you?