Base - specific questions on auto-fill

I am using this software to create forms for work orders. I cannot get it to properly generate a work order number for me. On top of that, I need to be able to put a text prefix into the work order number, i.e. “GB-00001”. I created a field titled “Work Order Number” and told it to auto-generate a number, but it’s not when I make a new record.

Another question - I made a check box entitled, “Completed”. When I check that, I want it to auto-generate the date clicked in field “Date-End”.

Am I asking too much? I’m tired of jacking around trying to figure it out…

You wrote:

I am using this software to create forms for work orders. I cannot get it to properly generate a work order number for me.

I suspect that you have incorrectly setup the work order to generate a number so try this method.

  1. Go to your Table and open it under Design View. Do you have the field that you want to generate the number set as your Primary Key? If not please do so.
  2. Now go down to “Field Properties” located in the lower portion of the same design view window you are in and set the Auto Value field to “Yes”
  3. Now, save your changes,close the Design View window and return to your Form.

NOTE: I have found it helpful to click the save button on the menu after closing any previous window. Now open your Form and test it for auto generation by filling in your fields (Not the one you want to generate. Leave this blank), with random info. Once you save the form you should see the number generate after the form opens a new form. To see this arrow back to the form you just filled in.

Your second Question states:

I made a check box entitled, “Completed”. When I check that, I want it to auto-generate the date clicked in field “Date-End”.

Not exactly sure of your question here but here is an alternate method that i hope helps. Leave the check box blank and create another label with the words Date-End entered. Now whenever you want to refer to this as a Date-End all you do is place a check mark in the check box (by pressing the space bar) to refer to the Date-End.

If this is not your intent please repost your question with more information of your intent.

Hi @brandot83,

If you have multiple questions, please submit them separately so that we can answer them one by one.

Have you gone through the Base documentation available on the wiki?