Save and New for Children No longer an option?
Just making sure I am not missing something: On new forms, when you use the embedded 'New Child' button (its an option to add to the toolbar in a report link), it opens up the cool pop up dialogue box to enter your child. I see no way of doing a 'save and new' when using this new pop up. Am I missing something, or did they remove that option?
Forms button
I have made my forms look better and it is easier to enter data. My question is how I can get someone to press a button or tab to bring up these forms in a "New" data entry form? Equipment type I (child table) Tab/Button Agency(table)-------Equipment type II (child table) Tab/Button Equipment type III (child table) Tab/Button
Red line records
I have a request to update choices in a multi-select field and delete or make it an option where certain user roles can't select an option in the field...I don't really want to delete the previous option and red line several records, is there anyway to have a user not be able to select certain options in a field? Or is there a better way to deal with making the data changes that displays the previous option as red?
Form Assistance (Dynamic Fields / Embedded Reports?)
I am helping create a table for a 'materials requests' In this table, it references a master materials list that contains the types of materials a work-job may need (example: paint brushes, mixing cups, spray bottles, sharpies, gloves, painter's tape, etc.). It pulls in the material, cost , and allows the form to calculate a total ie: 3 paint brushes x $2= $6 in materials Some jobs may just need 1 material from this list, some may need multiple materials depending on scope. On my request table, I have the form with relationship functional where it pulls in the material, cost and does a calculation based on the user input on the qty and saves with no issues. However, we need it to function where if a request needs more items there can be a button/option to 'add more materials' and reveal another set of fields for more materials as they are added. Now once the record/form is saved, it saves the material as one line item or one individual record. Now since there is a job name field for reference in any request, and if additional materials are needed, we are okay with it creating additional records from that same form-session so the user does not have to add one material at a time and become time consuming. What is the best way to approach it a intake/input form to create multiple records when/if needed if a job needs more than one time? Request Date Requestor Job Name Materials Needed Cost Qty Total 10/1/2024 John Doe Pleasant Valley C1 Mixing Cups $2 4 $8 10/4/2024 Jane Doe Westchester B03 4" brush $4.50 2 $9 Mixing Sticks $10.00 1 $10 Lint Free Rags $15.00 2 $30 10/10/2024 John Doe Windy Vane D112 Foam Core Sheet $50 3 $150 Trash Bags $5 2 $10 *Note: right now max materials right now is 10 per the admin, but they may want to increase this to a unknown number at this time in the future as business grows.
Use Text field as a search field inside a form
Hi, I would like to create a search field inside a form using a text field. I found a video with the exact action that I want to do (https://www.youtube.com/watch?v=XgkfTpXTYBc). It's basically scanning a QR code and it will automatically get the exact data from another table. Could you please help me on this? Thank you so much in advance.Displaying Values in Proxy Field
I have a Text (reference proxy) field that displays the values of a table via a relationship. The table has two fields "Brand" and "Percent". I have successfully created the table relationship and the dropdown is showing the values as expected. The issue I am having is when I select a Brand name the Percent value goes away from the dropdown after selecting it. Is there a way to display both the "Brand" and the "Percent" after value selection?Rich Text Button with rounded edge
I have been working to move to the new forms, using our own buttons and Iforms to control user workflows. The problem I'm having is one of formatting Rich Text buttons. Formular URL buttons (when used in new forms) automatically fit the width of the column, and have rounded edges. They can be made to look better by placing them in a column of their own to constrain the width, but the problem comes when using Formula Rich Text Buttons. I can make it the same general width to fill the space, but the corners are square. - see screenshot Does anyone have a recommendation on how to round the ends to look like the Save & Close in the screenshot here? The current code of the Save & Keep Working button is below "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #1b8b0a; border-radius: 5px; color: #ffffff; display: inline-block; padding: 5px 0px 5px 0px; width:180px; text-align: center; text-shadow: none; border: 2px solid #1b8b0a; font-size: 12px \"href='" & $URL & "'>Save & Keep Working</a>"
Filtered Dropdown on Form
Hi everyone, so I am trying to create a dropdown for user to pick in a form and the dropdown need to be filtered from user previous selection. But if previous selection is not selected, user still be able to pick the dropdown and select from it. To make it easier to understand, let say I have a form (in table called Main Table) with three dropdowns (State, County, and City from three tables) and State < County < City. If user pick Texas in State, then County dropdown will filter to only show Counties in Texas. But if user decide not to pick anything in State, the County dropdown will show all County in every states. Then if they pick Dallas County then City will filter to only cities in Dallas County and State will still be empty. I am aware of Conditional Value (in Field Settings) but it requires user to first pick State in order to pick County. I am open to any suggestion and solution. Feel free to ask if you need me to explain more.
