I have two lists: one is a list of customers, and one is a list of service calls.
The customer list has [Driving Distance]
, which is the distance from our central office to their office; likewise, the service call list has [Travel Start Time]
and [Mileage]
for our employees to document their travel.
Now, here's my idea: when an employee creates a new service call, if they had to travel, take a guess at the mileage. I've already tried setting [Mileage]
's default value to this calculated formula:
=IF(ISBLANK([Travel Start Time]),
"",
[Client:Driving Distance]
)
However, SharePoint just threw an error back at me, saying that [Client:Driving Distance]
didn't exist. (I know it exists, but I guess I can't use it in a calculated column.)
Is there any way to implement my idea? If SPF2010 has a JSON API, I'm not familiar with it.
0 commentaires:
Enregistrer un commentaire