Sendmail Issues - Other Users Having Issues?
Any other users having sendmail issues frequently? Emails are currently not sending in our application and this has happened multiple times in the past few weeks.
Invalid Characters
Hi, I am trying to enter data in to a form via the report interface. When i try to submit I get invalid character error message but the error message doesn't report which character is the issue. The error message is below and the text from the file is attached. "1 . Failed to update data. ." Please could advise which characters are causing this issue so i can find and replace them and upload. Thanks
header within a report
Hi I use to print each record of a report as a "summary" and I want to insert a header - my name and address - on the top of each printed page. I have been told that this can't be done only creating an html page. I am not so good with html.... I tried to embed the report within a page but it is pasted as it is and can't be edited. How can I append this two rows before the report itself? Thank you!
Refresh the page (with a filtered report) when I click submit.
I created a page which consists of a form and a report (the report of the form). Lets say that I have filtered the report to find some records. When I add a new record and click submit is there any way to refresh the page and shows me the filtered records (which I have found them before the submit)? Without need to search them again. With other words with the refresh to return back to the filtered page view.
Error in CRM task - SearchRecrods
Hi, I am trying to fetch data from CRM to ZOHO Creator on User input of a fields like here "Accounts" using "SearchRecrods" task. It is working fine for when every respective fields have values in CRM response but what I notice that when any of the fields in CRM of any record is blank then I got the below error it seems the response can't handle null value or it doesn't include this field in JSON list even. so script can't iterate the list. I tried to use "ifnull" but not working so. for instance
Populating lookup based on another lookup
Hello, I have a form for new projects. I want to allow the user to select a contractor from a list of contractors to assign to the project. Each contractor also has multiple employees, one of which will be assigned to the project. What I hope to accomplish is a filtered list of contractor employees based on the selection of a contractor in a lookup field. Not sure how best to go about accomplishing this. Any help greatly appreciated. Best, Chris
Normalisation
Have a quite large database (around 500 records), need help with normalisation of the database and designing the Entity relationship diagram. Cannot attach the file as there is some error
Unable to add Alias Address when I config Email
I config email at step 1 Unable to add Alias Address https://phattoroi.top/
How to display line breaks in an html view for multi-line text?
If I put html line break code in the text then that br code shows up for people who view the field within Zoho's non-html views. But multiple lines of text show up as one line in an html view, although they show correctly in other types of views. Is there a simple way to make multi-line text show as multiple lines within an html view, without the html code showing up in other views?
Custom actions
Hi all, Can someone help me with the code for transfering "pendig orders" to "ready to deliver orders" ? With a custom action button "ready", and is it possible for the app to automatically add the date i pressed the "ready" button? Ex: I pressed "ready" today, the app automatically adds the date to a "ready date" field? Thanks all, i really need this!
Conditional dropdown - Set Filter Not working.
I have a lookup field and configured the condition in the set filter. The filtering condition shows in the box after the condition setup is done. I see the Set Filter is unchecked with no condition text if I navigate back to the field again.
Click to call in Form
Hi, I want to be able to click to call from a clients profile. This works from the Reports running off my Forms, but I want to be able to do this from within the Form itself so Data can be updated at the time of the call. However, unlike on the Reports screen, when I click a telephone number in the Form view it does not call the number as desired. Is there a any way to get this to work?
New form: how make visible only the report
Hi all, I'm creating my application with Zoho Creator. Every time I add a new form, I see in the section specified both the form and its report. What I want to is seeing only the report and adding new record with the usual "Add" button. Can someone help me? Thank you!
Subform Totaling of Invoice
I'm not the most skilled at coding, but I think something is wrong. I have created an order form that is similar to other templates I have seen online. I am having an issue getting Total amount of all the item subtotals entered into a subform. When I select the item, the subtotal of the item is populating, but the addition procedure to get the total is failing. I had this working before. I created a new application just to test this issue and make sure none of my other code was interfering. I
Calendar custom record summary does not show in HTML page
I have a calendar report embedded in an HTML page. I created a custom record summary, and it does not show. This is only for calendar reports embedded in HTML pages. I have tested this problem with list reports and the custom record summary shows.
How to get querystring value in stateless form?
I have written a custom function to show a stateless form. querystring = ""; for each Account in Accountinfo { querystring = (querystring + "accid=" + (Account.ID)) + "&"; } openUrl("#Form:Send_SMS?" + querystring, "Popup window", "height=400,width=400"); The forms opens correctly. But I am not able to access the query string passed in the form. l = input.accid; It throws error accid is undefined. What am I missing:
update a field in subform
HI Does any one knows how could i update a field in a subform ? The system refuses it it s very frustrating have a good week end
Editing subform within a subform
Hi, I've got three forms: - Parent registration form - Child registration form (subform within parent registration form) - and Program registration form (subform within child registration form) I've shown it pictorially below: I'm wondering whether I can get the child registration form to open as a popup dialog so that I can allow users to add program registration data to the child registration subform. Has anyone faced this issue before? Any ideas?
URL problem when sent to a gmail account
Hi, I new working with Zoho creator. Not a IT person. Just added 2 forms. When I add a employee in the first one I was able to send a mail to the employee with a URL link to the second form. When I try with my Office365 mail, it works just fine. When I try with my gmail adress, it's not working. Any ideas? Thanks Marie-Andrée
Prevent duplicate month/year form
The forms in my application are set up to record financial indicators by month and year. Currently I have a simple drop down box to select the month and a single line field to manually enter the year. The problem is that the month and year can easily be duplicated with a separate entry. How would I make the month and year fields exclusive so the same month and year combination can not be duplicated? Also, I assume a Look Up field would be needed to modify the data for a particular month.
Changing a dropdown list's content with a variable.
Thanks in advance for any help! Here is what I'm working with: Form A (created from a spreadsheet): Has 3 columns labelled: Fruit, Vegetable, Grain Each column has several related entries. Form B Contains: Dropdown List 1: Which displays the choices Fruit, Vegetables, Grain. Dropdown List 2: I would like this dropdown list to display choices from the appropriate column in Form A, depending on which which choice was selected in Dropdown List 1. I'm new to Zoho Creator so I know there's a way of
Embedding Report under Pages
Hi all, I am very new to Zoho Creator. I have created a page with six reports however they are all below each other, and for visual purposes, I would like to have them in two rows of three. Is this possible and if so, how? Any help would be greatly appreciated. David
Merging Unique ID to mail document
Here is the situation: I have a lot of members and I will ask them to update their records: name telephone etc. I can export all data to a spreadsheet. I want to merge the unique ID so they individually can correct the data. When I try to merge in MS Word I simply get the message: cannot open website. Here is an example of a URL I want a member to access: https://app.zohocreator.com/fluiddanmark/favrskovgym60plus/#Form:Kontakter?recLinkID=3069380000000373191&viewLinkName=Medlemmer What would be easy
Sendmail record template of another form
I'm aware this works in deluge sendmail ( To : email From : zoho.adminuserid Subject : input.Subject_field Message : input.Message Attachments : template:Invoice as PDF, file:input.Date_of_Event.Planning_Form )I would like to know if I can attach a record summary template from another form in this script. I am already attaching an uploaded file from another form with file:input.Date_of_Event.Planning_Form I have tried Attachments
iframe size dynamically?
Hello. I already see on the forum many similar questions but may be u fixed that. I would like to have the form's height change dynamically, as the content within the frame's height changes without scrolling iframe. Thanks!
Sharing my application with other users
Hi Zoho, I've created an application and would like to share it. I have added the user in Settings -> Share -> Shared details, but when he tries to enter the app he gets the following error message: "This application is not accessible. Sorry USERNAME, you are not allowed to access APPNAME. Please contact this application's administrator." When I try to invite the user through Settings -> Share -> Invite, both "Select Users" and "Select Groups" windows are stuck at "Loading", so I can never pick
Subform Display Issue Main Form
Currently my SubForm (in the MainForm) on ALL forms has this odd gap under the SubForm title. Any suggestions on how to fix this or what could be causing it?
Bug with embed report in HTML page
I embedded a report in an HTML page and the height sometimes doesn't show all the records. This problem only happens when I open the app for the first time and click on the page link, or if I refresh my window, and click on the page link. The report shows all of the records when I click on the link for the 2nd time. But I wanted to try something. Below is a picture of two reports that contain the same exact script. These 2 reports contain the EXACT same script, but one shows all of the records,
Dyanmic Subform
Hi, I have created travel form for Employee travel management. I want to create conditional form. Condition is here. employee may have either international travel or domestic travel. employee may have international travel as well as domestic travel. First, Employee will fill the international travel form. if he needs domestic ticket he can apply for it. Here i want conditional form. if employee says " YES" he needs domestic ticket then this form will appear down side to the international Form, If
Time Field
Hi, I want to manipulate a time field without displaying the date but there seems to be no time field available, just a time date field. Is there a way to hide the drop down calendar in a date-time field and just make it display time? Why isn't there a time field?
Create a report with calculated column and filter by calculated column.
I have a invoice form with invoice date, duedate. I need to generate a overdue invoices report where duedate is past current date. Also, I need to show the number of days between duedate and current date.
How to call a field name from another form ?
I have two forms in my application . I want to get value/data form one form to another one . How can i can get value/data form one form to another one and How to call a field name from another form ?
Filter a Report based on a date
Hi, I am building a club membership app. Each member has an expiry date. I would like to generate a report that displays a list of anyone expiring within, say, 45 days. On a the report, I am trying to use a Criteria condition. Expiry Date >> Before >> (now + 45 days) How do I code the "now/today + 45 days"? Best regards,
Restricting View For Calendar
Hello, I have created a calendar report that is based upon a CUSTOMER form that contains information such as... Assessment Date Assessment Time Support 1 (dropdown reserved for ADMIN to assign the call center to call customer to confirm appointment) Support 2 (dropdown reserved for ADMIN to assign the call center to call customer to confirm appointment) Rep 1 (once confirmed, ADMIN then assigns the lead to a representative) Rep 2 (once confirmed, ADMIN then assigns the lead to a second representative
Column Creation
I've searched all over and cannot find where I created a multi column view. I created this view and cannot find where to edit it, it changed the behavior of the fields on entry and I would like to delete it. Sorry for the vague reference, I'm new to the product and not quite familiar. Thanks!
Open url after deleting a record
How to OpenURL after deleting a record? I put the script in On Delete -> On successs and also on Delete -> Validate but its still not working
Search field in the dropdown
Hi, It looks like there is no search field in the new android version of the zoho creator app. How can I fix this? Regards, Gianfranco m
"You are not authorized to view this record"
This has never happened before. I am the one who is creating the application. How can I take this off? Any linked record within this specific record summary gets this error. If i work my way around the application, I can view the linked records, but if I try to view them via record summary from another linked record, I get this.
Auto populate fields in same form
On User Input I would like Curr_Version_Name and Curr_Notes to auto populate into a field (while remaining in their current fields) called Notes_History and to add a date/time stamp + a single line space In that same form I would like any changes On Update of the Curr_Version_Name and Curr_Notes to add an entry below the last one in Notes_History Been stuck on this one for a while. Would appreciate some help. Thanks, guys.
Lookup field question.... using the If statement to refer to the user input
Hi I have a lookup field named 'country' in a form which is looking up country names in another form. I am trying to write the code below to say something like "if the country = Singapore then make the 'project sell cost' field visible, which is currently hidden. My dilemma is how do I refer to the actual country name? Currently I am using the code below which is using the ID of the country. What am I doing wrong? Regards Martin
Next Page