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

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • Answered
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
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 2
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
Hi Catherine,

Are you trying to create a report?

Thanks,
Gaurav
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb
No I am trying to make a monthly plan from yearly plan
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
If you are using a summary report then, you can group your rows by year.
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb
thanks. but how can I make it that the company only will show.. not the groups
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb
I have to make a field that i can multiple select a date :( so it can be summarized by yearly and monthly
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
No, you don't have to select multiple dates.
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb
what should i do> thanks so much for the help
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb
HI!



How can I also write multiple dates.. for example for this company i WILL BE VISITING IT FOR 4 TIMES A YEAR
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
For that you have to create 4 records with multiple dates.
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb
Thank so much for the help im sorry if i have many questions. i just need help
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
No Problem Catherine :)
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb
may I know how to have multiple dates because what I did if have different Field, It cannot be summarizes my date... 
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb
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
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
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
Photo of Catherine Dimayuga

Catherine Dimayuga

  • 232 Points 100 badge 2x thumb
Thank You so much. But is it really not possible to have multiple dates in one field? 
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
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)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,884 Points 20k badge 2x thumb
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/
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,884 Points 20k badge 2x thumb
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)
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
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.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
It means we have multiple visits with different dates right?
Photo of Cathee Dimayuga

Cathee Dimayuga

  • 220 Points 100 badge 2x thumb

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

Photo of Cathee Dimayuga

Cathee Dimayuga

  • 220 Points 100 badge 2x thumb

meeting will start after an hour?


again thank you very much

Photo of Cathee Dimayuga

Cathee Dimayuga

  • 220 Points 100 badge 2x thumb
to tell you honestly im on the middle of our process, im stuck in making monthly plan.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
Yes
Photo of Cathee Dimayuga

Cathee Dimayuga

  • 220 Points 100 badge 2x thumb
Hi Mr. Guarav
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
Hello Cathee,

How are you? Tell me.
Photo of Cathee Dimayuga

Cathee Dimayuga

  • 220 Points 100 badge 2x thumb
I sent you an email, are you available?
Photo of Cathee Dimayuga

Cathee Dimayuga

  • 220 Points 100 badge 2x thumb
I'm fine mr. Guarav. How about you?