Fetch and Update
Hi, I have a form "Lesson Items" with the dropdown field "To_Do". I have a second form called "Plans" that has a lookup field to "Lesson Items", and (also) a dropdown field called "tasks". I already have it set up to pull in the values of the lookup items "To_Do" field and populate the "Tasks" field. That works fine. But what I want to do is make it so that when I update a "Lesson Items" form, it will update any "Plans" forms that have the same ID in the "Lessons Items" lookup field. I have tried:
Record Summary format is modified when printing and downloading as pdf
Hello, I have a record summary design but when I try to download or print one in the report page, the format is changed and it looks very different from the original design, I need it to be exact the same format. I attach the original design and how it moves when I try to print it Note: It is duplicated because I need two copies in the same sheet Thanks
Function to populate a field in a report with corresponding data from another report
I have a form and report (A) in which I forgot to add a field called 'User1'. I have another form/report (B) that has the the field 'User' in it. They both have a field called 'Patient ID' that is common between them. I would like a function script that I can execute as a one off that will do something like this: for each record in FormA where 'FormA Patient ID' = 'Form B Patient ID' update 'FormA User1' with 'FormB User' There are 15000 records to update. Would this be possible? Thanks in advance
Update and insert into form at the same time
I need to write a script so when importing records into a form, the existing records are updated, while the new records are inserted. How can I start writing such a script? Thanks!
Insert Image or logo in a form
Dear Sir I have create on form having two field "Name" and "Image" and create a function module and use above code Code as follows string Pipeline_Management.Image(string name) { imagelnk = Image[Name = input.name].Image; imagelnk = imagelnk.replaceAll("/sharedBy/appLinkName/","https://creator.zoho.com" + zoho.appuri); imagelnk = imagelnk.replaceAll("viewLinkName","#View:Image_Report"); imagelnk = imagelnk.replaceAll("fieldName","Image"); return imagelnk; } But the return statement
Subform Record Delete Behavior
Hi, Can someone confirm for me that as soon as i click the "X" delete button on the subform, that record is deleted, regardless whether i Submit the main form or not. Is there any official documentation about this behavior? Is the subform On Delete script executed before or after the subform record is deleted? Again, can't find any documentation that addresses this.
Avoid duplicates while importing, with a composite key
I am trying to import records into a Form, and need to avoid duplicate entries ; the key for each row is a composite key made from field A and B. if ( (FORMX [A = input.A && B = input.B ].count() >= 1 )) { alert "Duplicate! Please check your entries！"; cancel submit; } But the same script does not work for ON ADD validation . Can someone shed some light into this?
how to extract email from muti-line text?
hi there is records which contain one email in mutli-line field how to extract such email from whole text of this field?
Form Timeout?
Hi all, Is there a way to implement a form timeout? Ideally, I'd like to be able to set a timeout on a form for a period of time where there has been no user interaction define an action when the timeout is reached (in this case load another form) I could try this by building a page with a timeout if I was using a browser, but my app is used within the Zoho Creator Mobile app so I specifically want it to load a form or view on timeout. Thanks in advance!
too long time - adding field to form
hi there is too long time when i add new field in big form https://creator.zoho.com/appbuilder/rfclient/ikeaserv-app/form/zayavki_form/edit was tried on firefox/chrome/safari, macos when i add in a little form - all works well
How can i make a two colum layout only for particular fields?
I just created a form consist of two columns. i arranged the fields. While arranging the subforms field i just want to display in the single column is it possible ? Please suggest me
zoho.currenttime
Hi Sorry of these are dumb questions .. just started using the system ... When I create a timestamps using zoho.currenttime it seems to include the date .. is there a way to only include the time .. Also is there a way in formula to work out the delta between two timestamps .. Example .. first record is (time) 15:00 and second record is 15:12 - so answer would be 12 Thanks Mark
Error login Mass Downloader
Hi Since 2 days ago I cant login anymore using the file downloader found here: https://help.zoho.com/portal/en/community/topic/download-all-file-attachements I need to back up all my files stored in ZohoCreator locally Please help Raul
open url
hi. can someone please help me i am trying to pass values from a report to a stateless form my reports url shows as: https://app.zohocreator.com/******/*******/#Report:Quotation?Fare_ID=3 and i wish to open a form using open url and assign fare id field in the form the value of reports fare id. i appreciate your help regards adeel haroon
Failure to receive Email confirmation on Outlook
Please help us on our problem - We are not receiving email confirmation from Zoho to Outlook emails but in Gmail were able to received all the email confirmation - Before we were able to received it even the recipient use their Outlook emails Hope you can help us or advise us what to check or what to do. Thanks!
I can create a feedback system with stars, for people to qualify and turn this rate is associated with a record?
I can create a feedback system with stars, for people to qualify and turn this rate is associated with a record? I would like to go with Zoho creator to interact with existing records. If not possible, any ideas? Something like this.
Customer Portal
Hi, I have created an application and enabled customer portal thru application settings. Later I registered 2 users to this portal for testing purpose. I created a few records by logging in with user X. However when I logged in with user Y, then I am able to see the records created by X and vice-versa. Both the users have default customer profile. This should not happen as one user should not see the data (records) of other user. I am not sure why this is happening. Anyone please help ? Thanks, Milind
One app two CRM accounts
Hi, is there a way I can share an app from my account (A) to two users that are in two different accounts (B and C) and the app access the users corresponding CRM (A, B and C) ??
Newbie Question
I am looking to see if I can use Zoho to create an application for a mobile device where I can have a set of icons on the screen and pressing an icon or a combination of icons automatically updates a record or number of records depending on the combination of icons pressed Thanks Mark
How to show an activated checkbox in an order listing to indicate that the "notes" field contains additional info
I have set up an orders application in Zoho Creator which includes a “notes” field for additional info. On the order listings form, I want an activated checkbox to show up indicating that the “notes” field contains additional info (if the "notes" field is empty, the checkbox is non-activated). On the orders entry form, I need to include a checkbox, which, when activated, shows the activated checkbox on the order listings form. Any help would be very much appreciated.
How to create a daily attendance sheet that automatically populates
Hello. I have this screen shot from an application from the Marketplace, but I can't find the app anymore. I would like to create something very similar to this in my app. After selecting an Instructor, the Enrolled Students section is displayed & populated. Does anyone know how I would achieve this format in a form?
How to unhide fields that have been hidden on load, when i choose an item from a visible dropdown? Then unhide another dropfield or fields on select from this now visible dropdown and so on???
Hide many fields with hide on load. Now when i make a selection on "Product types" want to unhide some hidden field / fields. Getting errors.. not sure about the script needed
creator customer portal permissions
I see in the user permissions for a zoho creator app that i can define field based permissions. I do not see a way to do that with the customer portal. How would I do this?
Display school result system
I want to create a school result system in zoho form, when user enter their roll no they go their result page
customer portal profile fields
I am working on a solution in zoho which is centered around the customer portal. The firs thing I need to do is have some additional customer profile fields. How do I add fields like mailing address, phone number, billing address etc.. to the profile fields? Currently it just asks for email and password.
Form cannot submit
Hi, I created a form and tried to submit it. It just hangs. Could anyone help? https://app.zohocreator.com/zoho_zoho812/hbhd2016/#Form:Pendaftaran
how to send email from custom email address?
hi! there is email of application admin - "app-admin@email.com" and custom email - "custom-email@mail-xyz.com" how to make sending using internal "sendmail" of zoho creator so that 1) from address will be "custom-email@mail-xyz.com" 2) emails from zoho creator's email service will be not in spam because of SPF and DKIM settings of mail-xyz.com email service
Dates Between
Good day, I have a form that receive StartDate and EndDate I need to create a record for each date between StartDate and EndDate how I iterate each date to build the insert into?. Thank you,
Reorder Multi Select Values
Hi, I have a Multi Select Field and it is working good. Sometimes I need to rearrange the order of the Selected Values in the Multi Select Field for some reason for instance if three Values have been selected in the order Val-01, Val-02, Val-03 .. Then If I need to rearrange that order like Val-03, Val-02, Val-01. What I have to do is delete all selected Records first then again select those three entries in the order that I want to achieve -Val-03, Val-02, Val-01.--. What would be great if there
Subform only works in Mobile App
I have created a subform to sort data on the back end as we process orders. The subform has a status field with a drop down but when I try to edit that field in the report in order to sort submissions I receive an error stating "You can submit this form only through the Zoho Creator App" Is there any way to get around this?
Auto identify subform rows
I am just starting with Zoho Creator. T have a form Jobs with a Job_No field (year & job No). There is a subform Labor. I want to populate a field Job_No in Labor with the Jobs Job_No every time a row is added. Please Help alexscott@btl.net
fetch records
I have two forms in an application. One is called Asset List and the Other Asset Manager. Asset Manager has a field called 'Asset Scan' which scans a bar code. Asset list has a field called 'ID Tag' which lists all of the codes which may appear in Asset scan. How do i fetch the description, depot, serial number and model from the Asset List form and place this as text in a separate field called Asset Details which is in the Asset Manager form, based on the Asset Scan being the same as the ID Tag?
How do I use 3 iterated records to filter a larger list?
I have a large "Price" form with the following fields: Product Date Terminal Price Then I have a form for "Customer" which has the following fields: Customer Name Products Terminals There is also a "Product" and "Terminal" table with additional details. What I Want to Do: I want to create pricing so that it only shows prices for the customer when the prices match their "Product" AND "Terminal". I have tried a lot of things but I am stuck. Any ideas on how to do this? Any help would be FANTASTIC!
Error Messages
I'm a complete beginner and am just trying to get to grips with zoho creator. However I'm finding it very frustrating as when I try to add coding which is identical to the examples given in the guide I get error messages e.g. adding an email notification to a schedule sendmail [ from: gillgannon12@gmail to: thegannons@eircom.net subject: "Birthday Alert" message: "Happy Birthday <br />" ] gives an error on line 2, improper statement, even though I used the 'send email' drag and drop! How can a bracket
Modified_Time is not updated in the case of bidirectional relationship lookup fields
"Enable bidirectional relationship" option in lookup fields is a great feature, but I think that there is still a problem related to it. Let me start with an example: I have a form named Participants and another one Workshops. In the Participants form I have a lookup field named ChooseWorkshop - which refer to a field WorkshopName in Workshops form. I enabled the bidirectional relation in the ChooseWorkshop field, so a lookup field WorkshopParticipants is created in Workshop form. The WorkshopParticipants
URGENT: Is sendmail working for other users?
sendmail stopped working this morning in our production code. I wrote this simple test function just to see if emails are being sent. They are NOT. I checked my account usage, I'm not over my email quota. void WalkIn.OM.Temp.Test() { sendmail ( To : "lex.shan@walkintour.com" From : zoho.loginuserid Subject : "zoho testing email subject" Message : "zoho testing email body" ) }
Rich-text field deluge
Hi A quick question- is 'on user input' deluge not possible for Rich-Text fields? I only see 'On update'.
How can i show lookup field id
How can i show lookup field id inside any module
Record Access Based on User
I have searched the forums but do not see an answer to this. I need to restrict salespeople to only seeing and updating their own records only. Managers and Admins will be able to see all. But I do not want salespeople to be able to view/update others records. Is this possible? I know I can restrict by Groups but I need more granular control. Thanks in advance for any assistance.
External plugins iframe not working
I tried to use iframe(a widget) from external website in my zoho page. But it is not working. Please let me know what is the problem ? Regards, Webber
Next Page