Automatically Add Field Entry to Value List

[scchang]

FM 16.

I would like to have new field entries automatically be added to the value list for the same field. I tried searching but wasn't able to find any references to this. Apologies if it has been previously addressed and appreciate any advice. Thanks.

[Steve Martino]

Are you talking about something like this:

https://community.filemaker.com/thread/180106

[Lee Smith]

Hi scchang,

Which Value List are you using,

Custom Values?

Use a Value List from another file?

Values from a field?

Are you allowing entry to it?

Is it limited to who can make change?

HTH,

Lee

[scchang]

3 minutes ago, Lee Smith said:

Hi scchang,

Which Value List are you using,

Custom Values?

Use a Value List from another file?

Values from a field?

Are you allowing entry to it?

Is it limited to who can make change?

HTH,

Lee

Good questions and sorry for not providing more detail. It is a custom value list from the same file specifically for the field in question. Anyone can make an entry or change.

Thanks for your interest,

Steve

[Lee Smith]

For my dull brain this time of day.  

Custom Value list has "Allow entry of 'Other" values,  which will allow anyone with privileges to add to the existing Value List.

If this isn't what you are asking, let me know.

Lee

[scchang]

On 11/2/2017 at 9:11 PM, Lee Smith said:

For my dull brain this time of day.  

Custom Value list has "Allow entry of 'Other" values,  which will allow anyone with privileges to add to the existing Value List.

If this isn't what you are asking, let me know.

Lee

Thanks Lee.

I changed the field to a pop up menu from drop down list to enable "Allow entry of other values". When I choose "Other" from the list, a dialog box appears and I can enter a new value which appears in the field. However, in subsequent records, the newly entered value does not appear. Is there something I can do so that the newly entered value is retained in the value list?

[Lee Smith]

It's been a long time since I used that options. I like to control the values.

The FileMaker helps say

To allow a user to add or change values in the value list across records, select Allow editing of value list. An "Edit" option appears in the value list. This option is not available if:

•the control style is a checkbox set or a radio button set you selected Checkbox Set or Radio Button Set

•the value list you chose in step 4 uses values from a field

[doughemi]

Is this solution a multi-user solution? Do you want all users to see the new value?

[scchang]

1 hour ago, doughemi said:

Is this solution a multi-user solution? Do you want all users to see the new value?

I'm the only user  

[doughemi]

If you have a one-record utility table, add a field named VLValues.

If you don't, create a table with one record and relate it to your current layout's table by a Cartesian relationship (the X operator).

Add the VLValues field and populate it with your original values.

Create a value list using the utility::VLValues field.

Create a script AddValues

If [IsEmpty (FilterValues ( yourTable::YourField; utility::VLValues  ))]
	Set Field [utility::VLValues[]; utility::VLValues & ¶ & yourTable::YourField]
End If

 

Add an onObjectExit script trigger to your dropdown field and point it at AddValues

 

[scchang]

18 minutes ago, doughemi said:

If you have a one-record utility table, add a field named VLValues.

If you don't, create a table with one record and relate it to your current layout's table by a Cartesian relationship (the X operator).

Add the VLValues field and populate it with your original values.

Create a value list using the utility::VLValues field.

Create a script AddValues

If [IsEmpty (FilterValues ( yourTable::YourField; utility::VLValues  ))]
	Set Field [utility::VLValues[]; utility::VLValues & ¶ & yourTable::YourField]
End If

 

Add an onObjectExit script trigger to your dropdown field and point it at AddValues

 

I will certainly give this a try and report back. Thank you for your much appreciated help!