I still have a need to create a form in Excel with my Grist data, and I’m trying to make it as seamless a process as possible; creating my Grist data to export as I wish it to appear on the form.
I have two concatenation formulas that I can’t seem to get right. The first is a simple combination of two Date/Time fields. I end up with an extra 7:00 that I think has to do with time zone but I don’t know how to make it go away. I would rather it say AM/PM. Also, I’d like it to keep the original Date format of MM/DD/YY.
"{}→, {}".format($TravelTo_Start,$TravelTo_End)
The second problem is joining 3 fields, one is a currency field but returns just a number. I’ve added a ‘$’ to the formula, but still have the dropped ‘0’.
"{} {} - ${}".format($LaborType.MatCode,$LaborDesc,$LaborType_Price)
I played with using a LookupOne (in various ways…)for the price but couldn’t make it work.
$LaborType_Price is an additional lookup field brought in with ‘Materials’ referenced table.
I’ve been playing with this all week & any help would be greatly appreciated!!