View only the last 4 lines in a data field?
Hi, I'm new to QuickBase and I'm having trouble with a formula for a text field. We have data line 1-7, but I only want to pull the last 4 lines in the data (data lines 4-7). I've tried using the part...
Forum Discussion
Can you post an example of what your data looks like?
Yes, here it is below. We want to view only the 2/3/2019 message.
05/04/2018 09:24:39 MST EP1RFCXP1 (EP1RFCXP1)
||elevation:5400|| INDIANA/91ST (WEST SIDE OF INDIANA) -ELEC SVC UG 1PH
120/240 GAS SVC - NO LOAD INFO PROVIDED WITH APPLICATION. CONTACT INFO:
JANE DOE 999-999-999 JEFFERSON CENTER METRO DISTRICT
ContactType: OWNR
ContactName: JEFFERSON CENTER METRO DISTRIC
TelephoneNumber: 999-999-999
PhoneNumberExtension:
Address: 1900 Misc street,LAKEWOOD,CO,80228-1814
01/31/2019 12:30:53 MST Kristi R Clark (230257)
design and project transferred to a new designer. waiting on customer verification for route.
2/3/2019 12:55:04 MST Krisit R Clark (230357)
Contacted customer and left Voice Message.
05/04/2018 09:24:39 MST EP1RFCXP1 (EP1RFCXP1)
||elevation:5400|| INDIANA/91ST (WEST SIDE OF INDIANA) -ELEC SVC UG 1PH
120/240 GAS SVC - NO LOAD INFO PROVIDED WITH APPLICATION. CONTACT INFO:
JANE DOE 999-999-999 JEFFERSON CENTER METRO DISTRICT
ContactType: OWNR
ContactName: JEFFERSON CENTER METRO DISTRIC
TelephoneNumber: 999-999-999
PhoneNumberExtension:
Address: 1900 Misc street,LAKEWOOD,CO,80228-1814
01/31/2019 12:30:53 MST Kristi R Clark (230257)
design and project transferred to a new designer. waiting on customer verification for route.
2/3/2019 12:55:04 MST Krisit R Clark (230357)
Contacted customer and left Voice Message.