Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 19, 2023 12:45 PM
- I have a report that I am trying to create that will take all my dates request and I can sort by month.
Below is my table and I am needing to run a report for the month of march. So what I want is for the provider name to show all the data that happen only in March by the dates in the date requested which is a look up field for the file number that is attached.
- Next is
Apr 20, 2023 02:46 AM - edited Apr 20, 2023 02:46 AM
What do you mean by a report? A formatted PDF file? If so, you would typically need to combine a series of tools to do that for you, such as combining Make with Documint.
p.s. These tools can be challenging to use if you’ve never used them before, so if your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you create this, please feel free to contact me through my website: Airtable consulting — ScottWorld
Apr 20, 2023 07:12 AM
By report I mean just being able to pull data for certain month for providers.
Apr 21, 2023 01:40 AM - edited Apr 21, 2023 01:41 AM
Hmm, is the "Date Requested" field a Date field in the other table?
If so, I'd create a formula field in the table that contained that "Date Requsted" field and convert that into the format MONTH YEAR (e.g. Apr 2023) with `DATETIME_FORMAT()`
After that, you could use a lookup field like you have now and use view filters for it and you could filter by "March 2023", which would give you all the records that are linked to a file that was requested in March 2023
Apr 21, 2023 07:32 AM - edited Apr 21, 2023 07:32 AM
Yes it is linked and it still groups the dates together. I need it to be able to read each date separate.
Apr 24, 2023 02:27 AM
Could you provide an example of what you'd like to see exactly?