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
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
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) ??
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?
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
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
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" ) }
How can i show lookup field id
How can i show lookup field id inside any module
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
OnValidate
Hello everyone. You can use alerts and cancel Submit in native modules (Leads, Accounts ...?, If it's possible, how it would be. I welcome your comments. Regards
how to autorefresh Date_Time in views of zoho creator reports?
hi! made report when i open entry - i can change Date_time field. This field depends on system current time. is it possible autorefresh this field in view without openning entry? example 1) i open this view and see list of entries 2) for each entry there is own Date_time setting 3) after 10 minutes in browser window i refresh this view 4) after refreshing - for each entry their settings of Date_time has increased at 10 minutes each
how to make search string - inside a form?
hi there is working form and there is database with about 1,500 records like "city - area" how can i in working form make a search string in which user enters first N characters of city name and below this search string appers a list with all cities which names correspond entered characters with ability to pick up city name see example from other website
Footer with paging numbers
I know that this question is quite old (as I find it in the forum the last years) but as an update, does anyone of you found a hack way to create paging footer? Something like 1/5, 2/5 etc in each page.. I know how to create sticky footer but what about paging?
"Sort by" in reports not working?
Hi Zoho, I'm trying to sort my Flags_n_Alerts report in my app, I try to sort the report by Added Date and by Recepient, the added date and time sorting is only sorting by the time (meaning 12:00 tomorrow will be higher ranked than 17:00 today) and the text sorting is not working at all.... Please fix Thanks Ravid
how do I make a subform show multiple records that were already added according to an action in the mainform?
Hi! I have an application with the following forms: Products Purchase Order Purchased Products Sales Orders The Purchase Order form has the "Purchased Products" as a subform. The "Purchased Products" form has lookup field from Products. So the user loads the form Purchase Order, clicks on Add New "Purchase Products", selects the product and add the purchasing price and quantity. Then other fields as Subtotal and Total are updated on the form "Purchase Order". So far so good. Now, my problem is on
iCal option for timezone?
When I add an iCal feed to an Outlook calendar it shows the event at GMT. In the Zoho app the time zone is set for EST (New York). Outlook shows the event time 4 hours later than in Zoho. Is there an iCal option to indicate the time zone offset? Here is an example of the feed https://creatorexport.zoho.com/zoho_admin3897/appowner/ical/appname/4PsSWBXKUx16BJK0dfQ0G6h8OOakkyBztZwg8ewY0JHD44B3XKSVsHZsfbMWdGFwQpFSpx7n3m0HeuR68sF8y7ZPayJC72s2F9Rv/DTSTART=Next_Contact_Date_Time&DTEND=Next_Contact_Date_Time&SUMMARY=iCal_Display&Record_Owner_Company_Link.Email=bryan@domain.com
Send Emails to a list of the application's users
Hello Everyone, I am currently writing a script that basically needs to send an email to a specific list of users. Given the user id, is there a way to access their account email address? Right now I have: for each m in Review_Board_Member [ID != 0] { sendmail ( To : m.User.[THIS IS WHERE I NEED HELP] From : zoho.adminuserid Subject : "Sweet" Message : "This works" ) }Also let me know if there are other problems with this code, all it's
how to add record via URL (http)?
hi there is website, which can send via http data from filled form website send it as "http call": http://my_site.com/?name=NAME&email=EMAIL@EMAIL.COM&phone=PHONE_NUMBER&lead_id=225298 http://my_site.com i can replace with http://creator.zoho.com/my_application/my_form/ how can tune my form so that it can record new entry when such "http call" from website is done?
Zoho Reports integration task for lookup field
Hi, I am using the integration task in order to add rows in zoho reports data base. I am using this kind of script: rowInfo.put("Email link Zoho", input.Email_link_Zoho); rowInfo.put("Horas Extra", input.Horas_Extra); rowInfo.put("Promedio Mensual Horas Extra", input.Promedio_Mesual_Horas_Extra.toString()); mapResponse = zoho.reports.createRow("Empleados Activos", "Empleados Activos", rowInfo); So far it works perfect except for the lookup fields, it returns the ID number and not the actual names
Zoho Capabilities - Multiple step/Multi party editing of data
Hello All, My client is in need of the following workflow: 1. A form is submitted outlining a new product idea 2. An email is sent to a preset list of emails saying something like, "A new idea was submitted you have x amount of time to respond to the idea with your thoughts, respond using this form (link to a response form). 3. The response forms simply edit the same table as the original request form - basically there is a column in the request table for each binary yes/no response from every notified
date validation between two date fields
I want to resolve exactly the same case herehttps://help.zoho.com/portal/en/community/topic/date-validation-between-two-date-fields I can not find where to setup this code? Where I should go to include code validation for a determined field Best Regards Natalia
Auto-fill date field UNLESS in Calendar view?
Hi, I have a date field in my form auto-populated to current date in the "on-load" function. This is great except for when I want to access the form from a Calendar report. I want to be able to click on the date in the Calendar (any date) and this date populates the date field. The only way I've been able to do that is to delete the on-load code. Is there a way to make it so that the date field auto-populates to the current date unless the form is loaded from calendar view? Thanks,
How to include a link / response in email to update a field in record?
Hi there, My app "Booking Management" sends an email notification to "freelance clerks" with appointment details. They need to accept or decline this appointment. Email notification set up under deluge script - no problem. Custom action "accept" & "decline" in Zoho Creator report - no problem Now there is my problem - I would like to include the option to "accept" or "decline" in the email & update the record. I have set up a stateless form (link to main form create a booking) to embed in the email:
Suggested Practice for modifying in use application in creator
Our organization is using zoho creator in live production but we're always needing to make changes to the live version. Sometimes (often) it seems making some changes can "break" our work flow and causes pains. What is the best method for updating production apps in separate environment and then deploying? Right now we're able to "replicate" the app and the work from there but the data does not transpose we it's copied. I suppose two main questions: 1) Is their a way to more automatically transpose
Bulk Edit disable not working
Hi I have created an application in Zoho Creator and I want to restrict Bulk Edit in Reports. I have unchecked the Bulk Edit Record from Reports Setting -> Restrict Visibility but Bulk Edit is still enabled. Is there anything that I am missing.? Attaching screen shot for the same. Please advise. Thanks
How to add New Line Charachter in Zoho Creator using XML RPC API?
Hi, I am importing data through XML into zoho creator using xml rpc api, and it works very nicely. Now i want to insert a new line in long string text. Is this possible or not? I have tried alot, but getting no luck. Tried for new line like this: \n, <br>, <br/>, <br />, %OA, %OD. here is xml format: <ZohoCreator> <applicationlist> <application name="my-app"> <formlist> <form name="form-name"> <add> <field
HTML Image Tag
Hi, I'm a bit stumped on this, and I hoped you might be able to help me? I'm trying to learn how to display external images in Creator. I have a form called "Images". It has a formula field which has this expression: "<img src='http://help.zoho.com/portal/en/community/images/imgLogoAdmin.gif' />" But when I look at the view, it has a broken image icon. I can't get any external image to work. I'm a bit puzzled, I'm afraid I just can't see what I might have missed. I wondered if you could help? Many
how to add entries via email - when using email forwarding on email server?
hi! just made form to add entries via email all works well task - add entries when i send email to "order@mailserver.com" on "order@mailserver.com" there is forwarding rule - all inbound emails send to creator form's email rule is turned on when i send directly to creator form's email - entry is in when i send "order@mailserver.com" - there is no entries how to add entries when using forwarding?
Next Page