Button to create empty field
Hello everyone,
is there a way to have a button create a new field of any kind? For instance, I have a text field where I put a name. If I want to put a 2nd name for that same record, could I have a button to create a 2nd blank field? Anonther example is a reference: could I add a 2nd blank field to insert another reference to that record?
Thank you!!
5 replies
-
I have not seen any function that allows a user to create a field through a button.
What you are describing is trying to track multiple instances of similar data to a record. In your example you want to be able to have multiple names to a single record. Naturally one would just add another name (or reference) field. And keep adding fields for each new instance.
But how do you handle records that only have 1 name, or one that has 100 names. That may be extreme but you want to create a flow that is flexible.
In this case you would need to create a table and then link it to the original table to create a 1:N (one to many) relationship. Where 1 record in the original table has many records in the table linked to it.
So in your case, you could create a table called names then create a reference field to your original table, so now you can have one 1 name field or you can have many name fields.
This opens up another path of how to display the data that makes sense to your users, but that is another post.
-
I DID create a table called "names" but in the original table I want to be able to add a 2nd or 3rd reference to the table "names"!!!! One way is to insert 2-3 blank references from the begining, I was just wondering if this could be done with a button!!!!
-
pirinisz said:
but in the original table I want to be able to add a 2nd or 3rd reference to the table "names"!!!!It sounds like you created the reference in the opposite direction.
In your original table you should see a table to the Names table. If you only see a field then you created the link in opposite direction.
Go to your Names table and create a reference field to the original table.
pirinisz said:
I was just wondering if this could be done with a button!!!!Once you have the link the correct direction then yes you can create new records in linked tables with a button.
-
Can you guide me through that procedure please...?
-
I did it and had an idea inspired by your answer!! Thanks a lot Fred !!!
Content aside
- Status Answered
- 2 yrs agoLast active
- 5Replies
- 83Views
-
2
Following