Some questions and problems (1/2)

Support
3

Hi f.i.SCIENCES,

Point 1. There are a couple of ways to go about this, firstly, exactly what Jean has provided for you. Also if you read through this thread you’ll see I’ve answered through the thread that you can also add a display type without a regex expression, you can just define you own mask.

Adding Records into Database - How do I? - Five Community Forums

Point 2. I think there could be a misconfiguration on your form to the associated table and Five can’t map the field correctly. Please verify everything on the form is correct in the fields being mapped to the table. Alternatively, I could email you privately and you could export your application in an FDF file and send it to me to have a look.

Point 3. By default, Five takes the value in the first field on your form and enters it into the app bar up the top, however, I have attached an FDF that you can import and have listed the steps below to show you how you can get more than one field data in the app bar.

MultiFieldTitle.fdf (2.9 MB)

Steps

  1. Import the FDF I have attached.

  2. Navigate to Tables under the Data menu and you will see a table called Customers. The table has a field called FullName and I still have Name and Surname fields as well.

image
image1404×740 33.4 KB

  1. Navigate to Forms under the Visual menu and you will see a field called FullName, ensure you include this field in the list.

image
image1404×741 34.4 KB

  1. Navigate to Functions under the Logic menu, select the UpdateFullName record in the list and click in the Code field to open the editor. The code is using the field property on the Five object with the fieldID from the form to concat the Name and SurName fields. The code is provided below.

function UpdateFullName(five, context, result) {
five.field.FullName = five.field.Name + ’ ’ + five.field.Surname
return five.success(result);
}

image
image1404×739 26.5 KB

  1. Just cancel out of the editor and the form.

  2. Navigate to Forms again under the Visual menu, select the Customers record and navigate down to the field records again.

  3. First select the Name field, click the Events tab ad attach the UpdateFullName function to the On Exit event. Do this also for the Surname field.

Tip: On events execute on the browser, Do events execute on the server.

image
image1404×738 36.9 KB

  1. Now select the FullName field, click the Display tab and type false in the Show If field.

Tip: If fields take JavaScript statements, so by typing false in the field, the field won’t show on your form.

image
image1404×793 44.2 KB

  1. Save your form again and run your application.

  2. You can now enter a name and a surname and on exiting each of the fields they are populated in the app bar.

image
image1184×523 21.1 KB

Point 4. Sorry I can’t reproduce your scenario. I’ll let you know what I did and you can let me know what steps I have missed. I did this in the running application.

Steps

  1. I used a form that had a list page type, ie, I clicked the tab at the top and the list appears on the right.

  2. Click the Add button.

  3. Fill in the form and left a required field empty.

  4. Clicked the Save button. (Received an error, which is correct.)

  5. Clicked the Cancel button on the form as I don’t have the Delete button here. The form is removed and I return to the list.

We are doing something different, because Five won’t let me return to the list without filling in a required field. Could you please tell me the steps I am missing to reproduce your error.

Point 5. At the moment we don’t display the total row on the list most to the right, however, thank you of informing us of this, we will take this on board as its a good idea and thanks for the compliment about the user interface!

I’ll wait to here back from you to help you further.